Simplify custom date range for Time dimension

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