Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi I have a data set similar to the below
Months | |||||||
Milestone | 01/01/2019 | 01/02/2019 | 01/03/2019 | 01/04/2019 | 01/05/2019 | 01/06/2019 | 01/07/2019 |
A | 01/01/2019 | 01/01/2019 | 01/01/2019 | 01/01/2019 | 01/01/2019 | 01/01/2019 | 01/01/2019 |
B | 03/02/2019 | 15/04/2019 | 15/04/2019 | 20/04/2019 | 20/04/2019 | 20/04/2019 | 20/04/2019 |
C | 15/06/2019 | 15/06/2019 | 20/06/2019 | 01/06/2019 | 01/06/2019 | 01/06/2019 | 01/06/2019 |
D | 20/06/2019 | 20/06/2019 | 25/06/2019 | 25/06/2019 | 25/06/2019 | 25/06/2019 | 25/06/2019 |
E | 15/07/2019 | 15/07/2019 | 20/07/2019 | 15/07/2019 | 15/07/2019 | 15/07/2019 | 15/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?
Could you please share how you solved this problem? I seem to need something similar.
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
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.
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
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |