Apply Parameter to the Edit Tool Tip field?

[praveen.gp]

Hi,

Is there an option to add a Parameter to the Edit Tool Tip Field ?
If not Could you please add it as a Feature item.

I have Aggregation Field having Parameters (Max, Min, Avg, Percentile). When I select one of the Aggregation Type it is to be reflect in the Tool Tip, but it is showing just Aggregation Type.

[andrepgn]

Hi @praveen.gp,
let me understand better your use case:

• you have a Parameter, like AggregationParam, which can have values Max, Min, Avg or Percentile
• you then I suppose use AggregationParam to calculate another field which have to change the aggregation with respect to the param. Something like:

ifelse(
    ${AggregationParam}="Max", max(Sales),
    ${AggregationParam}="Min", min(Sales),
    ${AggregationParam}="Avg", avg(Sales),
    ${AggregationParam}="percentile", percentile(Sales, 90),
    avg(Sales) // default
)

When you now show a visual, you want to tooltip to reflect the selected parameter value, is it right?

If so, then you can proceed by creating a calculated field, which if I understood is what you have done. Something like AggregationType = ${AggregationParam}.

Now, if you edit the tooltip and select your field AggregationType, you give the name you want to the label (e.g. “Aggregation Type”) and then you select Displayed value = Unique Value, this should give you the desired output.

Take a look at the screenshot below to see if this is what you are looking for

Let me know!
Andrea

[praveen.gp]

Thank you @andrepgn

I missed this part AggregationType = ${AggregationParam} .
Adding this works for me.

Actually I tried to add to the ‘suffix’ or ‘prefix’ to my Transaction Time(secs) field in the tool tip(screenshot). Appreciate if there is a way to do that ?

[andrepgn]

If you mean having something like Transaction Time (secs): 0.17 [avg], where avg changes when the control changes, I think that at the moment unfortunately you cannot do it.

There are other workarounds, but I think that it’s too much effort.
Try have a look at this one: Toggle Between Overlapping Visuals in QuickSight Using Parameters or Controls

You can overlap different visuals, each one will be related to a specific aggregation.
Then you switch btw visuals based on the control.
By doing so, you can avoid generating a dynamic calculated field which changes aggregation based on the control/parameter.
You will just show a different visual and then you can select the aggregation directly in the visual configuration and the select “Show Aggregation” in the Visual Tooltip Properties.

Longer, but if necessary…

Andrea

[praveen.gp]

I think I am good with the first option for now!
Second option is also good. But For my requirement I will go with first option

Thanks @andrepgn !