Show only data for some period out of all data

Questions & Answers
1

Hello I am using a cumulative timeline graph.
We want to display only the data from the 21st year to today among all the data.
However, if the filter is used, accumulated information is not displayed, only the filtered period is displayed. Is there a way?

2

Hi @sm.park,

If you use eazyBI standard calculations to add the cumulative, it starts the calculation from the first member in the filtered row set.
Instead, you can copy the cumulative formula and modify it in a custom calculation that sums values from the ‘beginning of time’ with the PreviousPeriods() function. For example, cumulative issues created

Sum(
  {
    PreviousPeriods([Time].CurrentHierarchyMember),
    [Time].CurrentHierarchyMember
  },
  [Measures].[Issues created]
)

Lauma / support@eazybi.com

1 Like