Field Value in Visual Title from Filter

[riley.anderson]

I have a visual that displays state group, and state with number (calculated field (state + denserank of states based off state display order))
I then have multiple visuals below that are breakdowns of each state and have a static filter of specific states. I want the title of each breakdown visual to be the ‘state with number’ calculated field which is used in my top display. I know I can add paramaters in titles but I don’t use them in my breakdown visuals, or don’t know how to apply them.
That is because if any new states are added they can be placed at any point and pre-existing ‘state with number’ values will change based on my calculated field being based off of denserank of states.

Initial Raw Data:
|State Group|State|Display Order|State with Numbers (Calculated Field)|
|SG1|S1|1|1 - S1|
|SG1|S2|2|2 - S2|
|SG1|S3|3|3 - S3|
|SG1|S4|4|4 - S4|
|SG2|S5|5|5 - S5|
|SG2|S6|6|6 - S6|
|SG2|S7|7|7 - S7|
|SG2|S8|8|8 - S8|

Therefore my breakdown visuals will have titles of ‘1 - S1’, ‘2 - S2’ etc… which are all filtered by ‘state’.

Data once new states are added:
|State Group|State|Display Order|State with Numbers (Calculated Field)|
|SG1|S1|1|1 - S1|
|SG1|New State 1|2|2 - New State 1|
|SG1|S2|3|3 - S2|
|SG1|S3|4|4 - S3|
|SG1|S4|5|5 - S4|
|SG2|S1|6|6 - S1|
|SG2|S2|7|7 - S2|
|SG2|S3|8|8 - S3|
|SG2|New State 2|9|9 - New State 2|
|SG2|S4|10|10 - S4|

I would then want my previous visual filtered to ‘state’ = ‘S2’ which was labelled ‘2 - S2’ to now be labeled ‘3 - S2’ and so on.

Any questions and please just ask, many thanks.
Riley

[Neeraj]

Hi @riley.anderson ,

Thanks for posting your questions on the QuickSight Community Q&A Forum!
Can you elaborate little more on breakdown visuals , what you are looking to show ?
From details you are shared it seems to be easily doable with small multiple charts . As you provide “state with number” calculated field as part of small multiple, it will break down into set of visuals applying respective filters on each visual and can dynamically adjust to values in calculated field. With new values added it will automatically adjust to title for each of the breakdown visuals. Example screenshot -

We hope this solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution.

[riley.anderson]

Hi @Neeraj,

Thank you for your response. Her is a screenshot of my ‘main’ visual:

My ‘State with Number New’ will have unique prefixed numbers, just need to make an amendment to the source data.

My breakdown visuals then look like this:

It is a breakdown of a field called ‘Defendant Group’, each of the breakdown visuals have a single filter which will be one of the states. You can the see the current titles I have on the breakdown visual’s don’t match up because the titles have static names.

Thank you for your suggestion but unfortunately that won’t help my my use case.

Any further questions and please just ask, many thanks.

Riley

[riley.anderson]

Hi @Neeraj,

Just wondering if you ever had chance to look at the above and see if my request was possible in anyway.

Any help will be appreciated, many thanks.

Riley

[duncan]

Hello @riley.anderson !

Are you still running to this problem, and if so have you tried any workarounds to get past it?

Could you elaborate on why you are not able to use a parameter to title these visuals? After looking over your question I believe you should be able to add a parameter to your visual that will update as you filter the visuals.

[duncan]

Hello @riley.anderson !

Do you still need help on this issue, and if you found a solution could you share it to help the community?

Again, I believe you should be able to add a parameter to your visual that will update as you filter the visuals.

[Tatyana_Yakushev]

I think what you are trying to do requires QuickSight to execute some query and compute something to show a title. QuickSight doesn’t let users do that at the moment. I would explore using Insight visual as a title (and position it right above the visual that has hidden title).