why doesn't my calendar range let me pick dates?

#1

I have a simple dashboard, with one table and 1 calendar range.

It works nicely - If I select yesterday, I have only data from yesterday. Same for week and so on. When a range is selected, it does what it needs to do.

My issue is that I cannot pick and choose my own dates, only ranges (tokens is the right word I believe, what appears if you click on the triangle on the “to” side" current week, last week, yesterday and so on).

If I click on the calendar icon, it looks like a calendar is shown, but stays empty:

calendarrange

My question is thus: How can I pick and choose my own dates? The configuration of the filter is the default (no manual tokens, “apply default hierarchy” has no effect).’

Maybe of interest, I am showing raw data in a table, so there are no actual date fields (so no date hierarchy) in my cube. The date filter from the dashboard is passed via a bridge filter.

Cheers,

#2

Hey @guillaume,

Since you are using a bridge parameter, what is the value type of your bridge parameter? Is it a Range Date or a Range Member? As seen in the following support article, since calendar ranges use time dimensions (which are a specialized form of hierarchy), range member should be the value type of the bridge parameter if a calendar range filter is being used to pass values to it.

https://www.dundas.com/Support/learning/documentation/cleanse-consolidate-modify-data/using-a-bridge-parameter#h2-6-date-range-selection

#3

Hi Cristian,

Bull’s eye indeed. By properly following the doc, it works as intended. Thanks a lot for your help!