cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
timneo Frequent Visitor
Frequent Visitor

Creating a milestone slippage chart

Hi I have a data set similar to the below

 

 Months
Milestone01/01/201901/02/201901/03/201901/04/201901/05/201901/06/201901/07/2019
A01/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/2019
B03/02/201915/04/201915/04/201920/04/201920/04/201920/04/201920/04/2019
C15/06/201915/06/201920/06/201901/06/201901/06/201901/06/201901/06/2019
D20/06/201920/06/201925/06/201925/06/201925/06/201925/06/201925/06/2019
E15/07/201915/07/201920/07/201915/07/201915/07/201915/07/201915/07/2019

 

Each month, I get an update for milestones A-E (Months are the row headers)

 

and I want to build a chart like this:

 

Capture.PNG

 

I can't seem to add in a 2nd date for the Y axis, I'm guessing people don't usually do this sort of thing, so probably needs to be in python or R?

3 REPLIES 3
timneo Frequent Visitor
Frequent Visitor

Re: Creating a milestone slippage chart

nb the blue triangle is a nice to have and isn't in the data set - it covers the data points that have effectively happened to show no further updates will happen for that data set.  its data points would be the same on each axis, ie X:01-Jan-19 Y:01-Jan-19, X:01-Feb-19 Y:01-Feb-19 etc

Highlighted
dearwatson Member
Member

Re: Creating a milestone slippage chart

Hi timneo

 

Yep I don't think thats possible with the default visuals and I don't know of a custom visual for a slippage chart yet. 

 

You could be the pioneer! 

 

I'd be looking to R or building something custom to solve this one. 


Cheers

Greg

"The commonality between science and art is in trying to see profoundly - to develop strategies of seeing and showing." - Edward Tufte
timneo Frequent Visitor
Frequent Visitor

Re: Creating a milestone slippage chart

Cheers,

 

Just so I understand this, both R and PY require a non default install for use.  So anyone with the desktop client will need R or Python install to view the output.

 

I assume if the server has python installed, anyone can view it on the server, just not desktop?  Our IT is locked down, so I'll have to get them to install R/python before I can make any changes.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 132 members 1,690 guests
Please welcome our newest community members: