I have a user-defined dashboard which normally shows data up to the last complete month. I’ve set its default to a fixed date (1970-01-01) and have logic in my views/explores so they filter for the last complete month if the filter has that value, otherwise using the date of the filter so that users can see the data as it was in previous months.
I’ve been asked to make this more intuitive, i.e. default to the start of the current month, but I can’t see a way to make a dashboard filter dynamic like this without manually resetting the default every month.
I suppose I might be able to create another filter/parameter and do something funky to dynamically generate the options as something like ‘last month’, ‘May 2019’, ‘April 2019’ etc then add more logic to set the original filter based on this but it seems like quite a lot more code to add, when the Explores supporting this dashboard are already quite complicated.
Any other ideas?
LinkedIn
Twitter
