Need help with Time Filter


#1

We currently have this report and want the data only for a specific period. how do we do this?

here is how our report looks like:

let me know if report defiition would be helpful


#2

still looking for a solution.


#3

Hi @knayak,

You may use Time dimension on columns and on pages at the same time to filter time. Please see a short video on documentation page how to do this:
https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-Pagedimensions

An alternative option is to define a calculated member in Time dimension and aggregate weeks matching some relative time frame, for example, the last 4 weeks.

Aggregate(
  Filter(
  [Time.Weekly].[Week].Members,
  DateBetween([Time].CurrentHierarchyMember.StartDate,
    '4 weeks ago','today')
 )
)

Then use this calculated time member in your report and expand it to week level.

More calculation examples you can find in eazyBI Demo Account:
https://eazybi.com/accounts/1000/cubes/Issues/

Best,
Zane / support@eazyBI.com