Date Changes Graph

[Anonymous]

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

[hic]

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