I need assistance with setting up control filters for the “Select Year Format” and “Select Analysis Period” options. Here’s the requirement:
Select Year Format Filter:
Calendar Year: When this option is selected, the “Select Analysis Period” filter should display
months starting from 01-01-2020 to 31-12-2020
Policy Period: When this option is selected, the “Select Analysis Period” filter should display
months starting from 22-10-2020 to 21-10-2021.
Could anyone please help me implement this functionality? Adding Image for view.
Do I get you right, your elements in the filter “Select Analysis Period” should change depending on the parameter “Select Year Format”?
If yes, you could create two calcuated fields for the different format types using the formatDate and toString function:
After that you use the ifelse function in another calculated field to change the output format depending on what is selected in the parameter.
After that you create a filter on that calculated field.
Hi @ajay44. Checking in. We have not heard back from you regarding your question. Please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - QuickSight Arena).
