Vertical bar chat: QuickSight: Reference line values not appearing in tooltip (Min, Max, Average, Median, Quartiles)

Q&A
, , , , , , , , ,
1

Hello Community,

I am working with Quick Sight and using with reference lines (Min, Max, Average, Median, and Quartiles) in a vertical bar chart visualization.

The reference lines and their labels are displayed correctly on the chart itself. However, when hovering over individual data points, the reference line values do not appear in the tooltip.

Note:
Although the visualization displays six bars, the Average, Median, Q1, and Q3 calculations should be computed using only five bars.

The orange bar represents data derived from Parameter 1 and should be excluded from these calculations. The remaining five bars, shown in blue, are derived from Parameter 2 and should be included when calculating the Average, Median, Q1, and Q3 values.

I attempted the following:

  • Enabled Detailed tooltip
  • Added the corresponding measures (Average, Median, Min, Max) to the Tooltip field section
  • Verified that the tooltip supports multiple fields

Unfortunately, the reference line values still do not appear in the tooltip as expected.
My questions:

  1. Is this a known limitation in QuickSight where reference line values are not supported in tooltips?
  2. If so, is there a recommended workaround to display reference line values (Average, Median, Quartiles, etc.) within the tooltip?

In this visual, four bars are displayed. However, when calculating Average, Median, Q1, and Q3, only three of the bars should be considered, and one bar should be excluded from these calculations.

I’ve attached a screenshot for reference.

Any guidance or best practices would be appreciated.

Thanks in advance for your help!

Thanks,
Pradeep

2

Hi @bpradeepkumar ,

I just tested this out and I do not believe you can include the reference line values (average, median, etc.) directly within your tooltip. Specifically for a detailed tooltip, it needs to be derived from a field within your dataset. A potential workaround you can do is create separate calculated fields for each of your reference line calculations (average, median, etc.) and then that why you can add them as a field within your tooltip. Another potential solution is to include the values within your reference line labels. It is not a tooltip but that is another way to make sure each value is included within your visual.

Moreover, I can leave the ‘feature-request’ tag attached to this post to help increase visibility to the Quick team but unfortunately does not become visible to them on a system’s support side until after this topic is completed.

Hope this helps and let me know if you have any further questions!

3

@JacobR

Thanks for the response I’ve got a solution.

Thanks
Pradeep

4

Hi @bpradeepkumar ,

What was the solution that you came up with? Sharing the solution you came up with would be very helpful for the community as other community members may run into the same scenario you were in.