Build a paired chart

A paired chart places several measures side by side as panes that share one category axis. Each pane has its own mark and its own scale, so a measure can appear as bars in one pane and as a trend line in the next, both read against the same categories. It is a chart type of its own - pick Paired Chart from the chart type selector.

Add a pane for each measure

A paired chart has three shelves. Category holds the field every pane shares, Panes holds the measures - each one becomes a pane - and Color is optional.

Click Add pane to add another; a chart holds up to 6 panes, and the same measure can fill more than one - the classic case is a count shown as bars in one pane and as a trend in another. Drag a pane by its grip, or use the arrow keys, to reorder it, and Remove pane drops one once there are two or more. Rows are sorted by the first pane.

1. 1Pick Paired Chart from the chart type selector.
2. 2Drag the field you want to compare across to Category.
3. 3Open a pane's measure pill - it reads "Add a measure" when empty - and choose the measure it shows.
4. 4Click Add pane to add another measure's pane, up to six in all.
5. 5Set each pane's mark, and give it an over field where you want one.

Give each pane its own mark

A pane's mark picker offers Bar, Line, Area, Dot, and Text. Because every pane is independent, you can mix them - bars for a total, a line for a rate, a single Text value for a headline figure - all sharing the same categories.

Draw a pane over its own field

Each bar, line, or area pane can take an over field, shown beside the word "over". Dropping a date there turns a line or area pane into a trend drawn over time, while the other panes keep their category grain. A line or area pane with no over field yet prompts you to pick one to trend. Text and dot panes show one value per row, so they have no over field.

Format a pane

Each pane carries its own formatting. Open a pane's Format pane to set its Color and Number format (Compact, like 1.5K, or Full, like 1,534); a bar pane adds Show values, and bar and dot panes add Gridlines. All options opens the full format pane for that pane's chart type, and Reset formatting clears your changes. A pane also carries its own aggregation and visual calculation, set from its measure.

Drop a dimension on the Color shelf to color every pane by that field's members.

Compare with a year earlier

A pane drawn over a date by month or quarter can compare each period with the same period a year earlier. In the pane measure's visual calculation menu, pick % Change or Difference, then choose Year as the period instead of Month or Quarter. A period with nothing a year earlier stays blank rather than showing 0%. The comparison respects the chart's date filter, so a month the filter only partly covers is left blank instead of being compared against a full one.

Resize and rename

• Drag the divider beside the category labels to widen or narrow that column.
• Drag the divider between two panes to change how much room each gets.
• Drag the line under the first row to make every row taller or shorter. Rows otherwise fill the tile or sheet and follow it when you resize.
• Double-click any of these dividers to reset it.
• Double-click a header - a pane's or the category column's - to rename it. Press Enter to save or Escape to cancel. Saving the original name again restores the default.

Pin a tooltip

Hover a bar, dot, value or point on a trend to see its tooltip. Click it to pin the tooltip in place. Close it with its close button, Escape, a click outside the chart, or a second click on the same cell. Only one tooltip stays pinned at a time.

Build it from the chat

You can ask for a paired chart in the Analyst pane or a dashboard's Storyteller pane in plain words - "show orders as bars and as a trend over order date in one chart" - and Golden builds the panes for you. The chat also reads the rows a paired chart draws, so you can ask about what it shows, and it can add a year-over-year pane or change the grain of one. Paired charts work the same way in Analyze and on dashboards.