Need help with Time Filter

Questions & Answers
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:

image
image.png2264×450 55.3 KB

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