Tooltip issue

Q&A
, ,
1

Hi QuickSight Community,

I am facing an issue with sheet tooltips in a pivot table when using a parameter-based calculated field.

I have a calculated field called Level, which is driven by a parameter. Based on the selected parameter value, it dynamically returns different dimensions (for example, Site or Program). I use this calculated field as one of the row dimensions in my pivot table.

The pivot table itself renders correctly without any issues.

However, when I configure a sheet tooltip for the pivot table, I observe inconsistent behavior.

Expected Behavior

When hovering over any data cell in the pivot table, the sheet tooltip should open successfully and display the corresponding tooltip visual.

Actual Behavior

  • The tooltip works correctly when hovering over the Total rows/cells.

  • However, when hovering over individual data cells, the tooltip fails and displays the following error:

    image
    image705×342 44.8 KB

    image
    image703×343 43.1 KB

What makes this confusing is that the calculated field itself is valid because:

  • The pivot visual renders correctly.
  • The parameter switches between dimensions as expected.
  • There are no validation errors while creating the calculated field.

To further isolate the issue, I replaced the parameter-based calculated field with the actual dimension (without using the parameter). After doing so, the sheet tooltip worked perfectly for every cell without any errors.

This makes me believe the issue is specifically related to how sheet tooltips evaluate parameter-based calculated fields.

My Questions

  1. Are parameter-based calculated fields fully supported in sheet tooltips for pivot tables?
  2. Why does the tooltip work correctly for Total rows but fail only for individual data cells?
  3. Does the tooltip evaluate calculated fields in a different context than the source pivot visual?
  4. Is this a known limitation or a product bug?

I’ve attached a screenshot of the error for reference.

Any insights or recommendations would be greatly appreciated.

Thank you!

2

Hi @Swetha_Jayachandran,

Hope everything is well! That is definitely some interesting behavior you are encountering. To my knowledge, I do not believe there there is a tooltip limitation within parameter-based calculated fields. My guess for why Total rows is working is because it is technically counting that as a separate aggregation, and maybe it is having trouble interpreting with the parameter context.

If possible, could you please send me an Arena View with no sensitive data, as I would like to see more in-depth why this could be occurring and potentially finding a workaround from there.

Thank you!