cumulative flow diagram with start point

Question

Hello,

I need to show an cumulative flow diagram similar to https://eazybi.com/accounts/1000/cubes/Issues/reports/187032-cumulative-flow-diagram, but the start point needs to be zero.

The diagramm is gernerated by the measure "issues history".

Cache(
NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),
Cache([Measures].[Transitions to]
- [Measures].[Transitions from])
))
+ [Measures].[Transitions to]
- [Measures].[Transitions from]
)

I want to include only history, that is after the configured time frame of the report.

How can I modify "issues history" so that only the values in the time frame count, so every line starts at zero?

Zane eazyBI Support · Answer

Hi @winternina

I believe you have found the solution already. However, I will answer if someone else has a similar use case and finds this post.

Measure "issues history" represents values as they are at the end of the selected period. Measure considers all changes even before the selected period to correctly accumulate the data and construct the value as it was at the end of the period.

However, sometimes it makes sense to start from point zero, especially for longer or maintenance projects.

We have prepared a dashboard for Kanban projects: https://eazybi.com/accounts/1000/dashboards/41359-kanban.

The dashboard contains a Cumulative Flow diagram for the selected period without showing the baggage of resolved issues in the past: https://eazybi.com/accounts/1000/cubes/Issues/reports/621572-cumulative-flow-diagram-for-selected-period.

Best,

Zane / support@eazyBI.com

Fabian Lim · Answer

Hi @winternina

You may want to try using the date filter feature explained here: https://docs.eazybi.com/eazybi/analyze-and-visualize/date-filters

Regards