Dynamic Title with calculated fields

Q&A
, , , ,
1

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?

image
image739Ă—448 14.8 KB

2

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

3

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.

image
image275Ă—804 33 KB

image
image562Ă—615 25.1 KB

image

4

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”

image
image590Ă—366 28.3 KB

image
image232Ă—659 22 KB

image
image232Ă—659 22.1 KB

5

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.

image
image275Ă—804 33 KB

image

6

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.