Restrict the data to start from current Month onwards and do not display any past months in Date field Filter in quicksight

Question & Answer
, , , , , ,
1

Hi,

I have a requirement to Restrict the Years/Months displaying in Date Picker and show only starting from current month onwards to future months. Also Don’t Need to have option to select date, Only Need Year-Month as options.
As we Know, Date Picker is the only option available for a date field, I have created a calculation to display it in string format ‘YYYY-MM’. But I need to set this always start with Current month and based on selection in Starting Month, display next 12 months data.

image
image1770×690 110 KB

Here I have added monthly date filter and selected the staring date as Start of this month and Ending date as End of Next 12 months. And Selected only relevent option in Select Month filter , so it displays 12 months.
But I want a Drop Down Control in YYYY-MM format, which starts with Current month. What ever month selected in Start Month, Visual need to display next 12 months from start month. How to achieve this.

  1. The Goal is I don’t Need a date picker for date, need drop down in ‘YYYY-MM’ Format for selecting Start Month which always starts with Current Month.
  2. Visual need to display next 12 Months from What ever Start Month is selected
2

Hi @Ganga,
There’s a bit to this question in regards to working with calculated fields and testing out; perhaps it may be easier if you are able to upload your analysis with sample dataset to the QuickSight Arena so that we can test out some potential options. Are you able to do that?

Thank you

3

Hi @Ganga,
It’s been awhile since we last heard from you so following up to see if you had any additional questions, if able to upload to Arena or if you were able to figure out a different work around for your solution?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

4

Hi @Ganga,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!