Page-level date filtering

Questions & Answers
1

image

Greetings, community! How do I add a page-level filter for a particular date field (one among my report columns) to the page? Please see attached screen grab for an example from the DEMO reports.

Please help!

Many thanks!

2

Hi,

This is a dynamic date filter for “Time” dimension members.
Please read more here:
https://docs.eazybi.com/eazybi/analyze-and-visualize/date-filters

But it would be possible also to filter your report by columns using regular expressions (if you select date field measure in columns), see attached gif below.

Martins / eazyBI support

filter%20by%20date
filter by date.gif1490Ă—749 355 KB

3

Thanks Martin,
But what if I don’t want to show all the Issues, I have a couple of calculations that group the filters and I want to filter by like a variable, let’s say:

Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
  DateBetween([Measures].[Issue Forecasted Go Live Date]
    ,'Jan 2019',<The current value of the Page filter Time>)       
)
  , [Measures].[Issues created])

is that possible?

4

Yes, it would be possible to filter the report rows (issues in your case) by a measure with a dynamic variable.
First, make sure that you imported “Forecested Go Live Date” field as measures from Import options page. Create a new calcualted measure using this formula

NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
DateBetween(
[Measures].[Issue Forecasted Go Live Date],
'Jan 1 2019',[Time].CurrenthierarchyMember.Startdate
)
AND
[Measures].[Issues with Forecasted Go Live Date]>0
)
)
)

Then click on the column and choose to filter rows where the new measure > 0
Note this formula is using [Time].CurrenthierarchyMember.startdate to find the first date of the selected Time page filter.

Martins

1 Like