Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Every milestone has 'snapshot_date' and 'finish_date' and I want to upload it on a graph.
How can I create the graph attached?
Thanks for your help,
Liron
You can visualize this as a Scatter chart:
1) Select Milestone as first dimension, Project as second
2) Use Avg(SnapshotDate) and Avg(FinishDate) as measures
3) "Show arrows" on the Presentation tab
4) Uncheck "Force 0" for both axes on the Axes tab
5) "Show grid" for both axes on the Axes tab
6) Format both measures as Dates on the Numbers tab
See also Recipe for a Scatter Chart
Good luck!
HIC