Dashboard, set last date as default in date filter?

[JMJ1]

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.

[Dawid]

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..