Hi everyone,
I have built a dashboard with a month filter (date time format).
The info in this dashboard read from a table that is loaded and updated periodically with new months. I would like that default value of the month filter be always the last month loaded in the table.
Is it possible? Any solution would be highly appreciated.
What do you mean by last month loaded? The maximum value on a timestamp / datetime column from the source column? If yes then unfortunately there’s no way to achieve that. The filters, even though they work on a specific field, are not aware of your data granularity. There’s no way to specify that your, let’s say, activity_date, is aggregated on a month level and use something like “LAST VALUE”.
The only thing that comes to my mind is a dimension max_month and then yes/no dimension “is_last_value” and making this as a filter. But it wouldn’t override the date filter if somebody chooses something anyway..