As a first PowerPivot project I created cumulative flow diagram.
For this I used disconnected tables:
The next step would be to add the average lead time from one phase to the next.
The picture (of a simplified example Pivot) in the link below clarifies the problem.
it should be calculated as follows (see the blue arrow):
Picture: https://www.dropbox.com/s/q8vxfrfgxh8e9g9/Power Pivot lead time.png?dl=0
For this I used disconnected tables:
- HistDate table = one date every 7 days in the past, starting today.
- Data table = a list, of items containing the creation date and the date each phase is finished,
The next step would be to add the average lead time from one phase to the next.
The picture (of a simplified example Pivot) in the link below clarifies the problem.
it should be calculated as follows (see the blue arrow):
- Lead time = “completion date” - “Creation date” where the “number of created items” is smaller or equal to “the number of completed items” of the current row.
Picture: https://www.dropbox.com/s/q8vxfrfgxh8e9g9/Power Pivot lead time.png?dl=0
