Show Extra Fields in Chart Tooltips

By default a chart tooltip shows the X value and the Y value of the point you hover. Use the Tooltip section to add other columns from your query result, such as a region, an owner or an ID.

Turn it on

1. Open the widget and choose a chart type.
2. In Visualization, expand Tooltip.
3. Switch on Show extra fields in tooltip.
4. Open the Fields menu and tick the columns you want. Untick a column, or remove its chip, to take it out.

When you hover a point, each selected column appears under the usual values as column name: value.

Format a field's value

Under Fields, each selected column has its own Value Formatting block. Choose a Type (Number, Text, Currency or Date) and set the options, such as prefix, suffix, precision, locale or currency. This is the same formatting used elsewhere in chart settings.

• Each field is formatted on its own. It does not change the other tooltip fields, the axes or the chart values.
• Leave the type as DEFAULT to show the value as it comes from the query.
• Removing a field also removes its formatting.

How it behaves

• The list contains every column in the query result, and each field is labelled with its column name.
• The existing X and Y values stay as they are. Switching the option off returns the tooltip to its default.
• A column with no value for the hovered point is left out.
• If Show Tooltip is switched off, the chart shows no tooltip, so the extra fields are not shown either.
• Values come from the query result row behind the hovered point.

Supported charts

Bar, Bar (label rotation), Line, Line + Bar, Stacked Bar, Stacked Area, Negative Bar, Radial Bar, Waterfall, Funnel, Pie, Donut, Boxplot, Candlestick, Bullet, Pictorial Bar, Scatter / Bubble, Scatter 3D, Scatter Regression, Scatter Visual Stream, Heatmap, Sankey, Treemap, Sunburst and Geo Route.

A few charts combine rows, so the extra fields only appear where a hover maps to a single row:

• Treemap and Sunburst: on items that have no sub-items only. Parent shapes add up several rows and show no extra fields.
• Sankey: on links (source to target). Nodes add up several links and show no extra fields.
• Heatmap: on cells. Row and column totals show no extra fields.
• Scatter Regression: on the observed points. The fitted curve is calculated, so it shows none.
• Scatter Aggregate Bar: in scatter view. The aggregated bar view shows none.
• Geo Route: on routes, places and regions that match a row in your result.