Hi there,
I have a 1 year data record for issues created and resolved and I’d like to see in a chart the cumulative sum of them for the last 60 days, but considering the previous data before 60 days ago. Whenever I try to create a filter for the last 60 days, the data before that is not considered, therefore my cumulative sum starts in 0 instead of the cumulative sum of the last 10 months. How can I solve that?
Hi @guilhermepass7,
Measure “Issues created” and show the number of issues created in the selected period. If you choose to show 60 days in the timeline and add a standard calculation for Cumulative sum (Add standard calculations), eazyBI accumulates results for the time period on report rows.
If you want to see the count of issues created from the beginning till the end of each period, create a new calcauted measure “Cumulative Issues created since beginning”.
For the calculation use function PreviousPeriods to aggregate Issues created count:
Sum(
--set of previous and the current Time periods
{PreviousPeriods([Time].CurrentHierarchyMember),
[Time].CurrentHierarchyMember},
--sum up created issues
[Measures].[Issues created]
)
More details on calcauted measures are described in the documentation: Calculated measures.
Best,
Zane / support@eazyBI.com