I have a scatter plot and a filter for country. I want the chart to be enhanced by the tooltip only if user selects a value or more in the country.
If the user selects all, the tooltip can be blank
Designed a calculation that reads as
ifelse( count(countover(country),,PREFILTER))<COUNT(cOUNTRY), COUNTRY,‘’).
Named this calculation as country selection and wanted this to be part of scatterplot tooltip.
But this calculation is not validating.
It throws out error as we are trying to mix aggregate and non aggregate calculation in the same field.
Please put out thoughts here on what is the best way to achieve this use case?
Hi @SAILAKSHMI,
There is currently not a feature that allows tooltip’s to react differently based on a selection in QuickSight.
One work around you could potentially try; setup your sheet in free-form so that you can layer visuals. Have one visual with no tooltip and another with tooltip turned on. Then you could create a rule to hide the visual based on your control selection.
Another workaround could be setting up an action on the scatter plot and a table underneath that is filtered by the action to match the users selection. (You can remove lines and cell color to make it look a bit more similar to a tooltip).
Nonetheless, I agree that more flexibility with the tooltip would be a great addition so I’ll mark this as a feature request for our support team’s visibility.