Date filter with month granularity

Question & Answer
, ,
1

Financial reports are generated for a month. I need a drop down where user can select from 2024 July, 2024 Jun, 2024 May etc… in descending order with current month as default. This report also need to show data for previous year same month.

This simple need has been anything but complex to accomplish. I am still looking for a solution.

So that control can sort descending, I added a prefix to a field in data set like ‘M-0: 2024 July’ so that control would sort in descending order.

But to default this to show current month like M-0: 2024 July, I need a dynamic default and that does not seem to be an option / feasible for anonymous users (only for named users). So for this to work for anonymous users, had the data set field return something like M-0: Current month (so that I can set static default for the parameter as M-0: Current month). If using spice to refresh there is a period of time (around the turn of month) where M-0: Current month is not really current month (and that is a big deal for financial reports).

I have seen some feature requests on this (at least a year old) and is there any update on when this will be addressed.

  1. Control drop down should be sortable in descending order
  2. Month granularity for date selection

Thank you

2

Hi @metrics,
Thank you for bringing these feature requests back up in the community. I agree that these could be valuable additions.
At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. While I cannot currently say a timeframe on when this could be added, I will tag this as a feature request to boost visibility.

Did you have any additional questions regarding your topic outside of the feature requests?

Thank you!

1 Like
3

Thanks Brett. No questions besides feature request.

Also, I was able to work around the feature requests by using Quicksight SDK and passing parameter values that are evaluated at run time.

1 Like