In Quick Sight, I want to create a title that automatically displays based on the maximum value of the date column I filter. I see that in the title settings there is an option to select a parameter as the value. So, can I create such a parameter?
If you create 2 parameters, “DateStart” and “DateEnd”, and put them as filter control.
When user select “DateEnd”, this value can be assigned as parameter and shown in the visual title
Is this the correct way to create it? I tried, but in that case the filter can no longer be added as a control for users to interact example 3rd picture.
you can have 2 parameter with 2 filter control like this
And the visuals should apply 2 filter. one of them is using “After”. Another one using “Before”
Thank you for your help, I’ve understood how to do it. I did it as follows:
-
I created parameters for the start and end values. Then I built a controller based on these two parameters so that users can interact with them.
-
After that, I created another filter for a field in the dataset (as shown in the picture).
⇒ The execution flow works as follows: the controller changes the parameter values → the parameters change the filter range → the filter is applied successfully.
1 Like
Hello @royyung ,
Can I transform a parameter before displaying it in the title, for example subtract 1 year from pEndUsedDate or format the display?
For instance: addDateTime(-1, 'YY', ${pEndUsedDate})
I couldn’t find a way to achieve this requirement.