Limit the selection for a Date in dashboard filter
I would like to make the UX for my users better by limiting the selection of the dates listed when using a date field in a dashboard filter.
I have a simple test dashboard that is based on the date_time schema where I use a presentation variable to filter on the month-year. This works well however when selecting the filter, the selection list shows every month-year in the date_time schema. I would like to limit the selection to the last two years.
So instead of Jan-80 through Jan-36, I would list 10-18 though 10-20.
Addendum: I have a workaround that is okay. I created a business view with a dynamic filter to limit the dates included from the Date_Time schema Date table. The main problem (same with all month-year selections) is sorting. I have no way to sort the selection in date order. Is there any way to change the sort for month-year?