I have Time dimension in pages.
Lets say I want to filter my report from 15th of january to 8th of march
Currently the user has to drill through and click on multiple date fields in the dropdown
- click multiple and deselect current month or what ever period was selected previously
- click on the plus in front of Previous year
- click on the plus in front of 2024
- click on the plus in front of Q1 (Jan-Mar is Q1)
- Click on the plus in front of Jan to open january
- click on Jan 15 and shift+click on Jan 31
- click on Feb to select the full february
- click on the plus in front of Mar to open March
- click on 1st Mar
- shift+click on 8 Mar
- click OK
Having a more user friendly way to enter that range would make it more convenient. Maybe a Javascript calendar selector or just a plain text field?
2 Likes
Hi @sandervall
Thanks for posting your question!
Unfortunately, it’s impossible to select a fully custom date range directly in the Page dropdown. However, you can create a workaround using calculated members in the Time dimension. Create calculated members for specific date ranges you frequently use (e.g., “This Tuesday to Sunday”, “Last Tuesday to Sunday”) using a relative date calculations to make these ranges dynamic: Calculated members in Time dimension
This way, you can select your custom date ranges from the dropdown without multiple clicks.
Here’s an example of how to create such a calculated member “Last Tuesday to Sunday”:
Relative example
Aggregate(
[Time].[Day].DateMembersBetween(
'last week tuesday', 'last week sunday')
)
Exact date example
Aggregate(
[Time].[Day].DateMembersBetween(
"Jan 15 2025", "Mar 8 2025")
)
You can create similar calculated members for other frequently used custom date ranges.
We do, however, have a ticket open in our backlog about date range feature. I have added your vote to it.
Best wishes,
Elita from support@eazybi.com