Month and Year Picker in Filter

Question & Answer
,
1

Hi There

Is there any way to filter data by passing only Year + StartMonth + End Month?

I need to get data in a specific range of months, the user will use a control to the first and last month to be filtered, I was not able to see how to filter data with month ranges in QuickSight.

Cheers

image (27)
image (27)1037×645 19.7 KB

2

Hi,

you can create the calculation field base on you date with formate of month-year.
add filter on it and use rolling date option as given below in image

image

Hope this work for you.

Regards,
Naveed Ali

1 Like
3

Hi @Naveed , Thanks to help me on that question.
Could you please show me how to create this calculated field?
I’m trying to create it with parseDate but it does not allow me to filter the data by range.

1 Like
4

I’m using this calculated field to create the YYYY-MM

parseDate(concat(toString({year_number}), '-', toString({month_number})) , 'yyyy-MM')

2 Likes
5

Hi,
this should work

regards,

1 Like