Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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:

 

 

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?

4 Replies

  • dearwatson's avatar
    dearwatson
    Continued Contributor

    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

    • Anonymous's avatar
      Anonymous
      Not applicable

      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.

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Could you please share how you solved this problem? I seem to need something similar.