Configuring a Multi-Category Table Chart

A multi-category table chart uses a metric that has multiple group by fields. You can configure the chart so that all the group by fields display in columns to the left of the value fields.

For example the following table has three group-by fields (on the left) and one value field:

Country State Sex Population
Brobdingnag West Male 500034
Brobdingnag West Female 500154
Lilliput West Male 346034
Lilliput West Female 37656

These are high-level instructions. They assume you are familiar with configuring a table. Ensure that the project contains an appropriate metric with more than one group by field, and a data source (or data sources) to provide the chart data.

Procedure

  1. Add a chart of type Table, subtype Simple.
  2. Add one series for each column in the table. Choose the same category field for each series, as you would for any multi-series chart or table.
  3. Use the same category field in all series, as is usual.
  4. Define the value fields as follows:
    • Use group by fields so the categories display in different table columns.
    • Use an aggregation field, in the usual way.

      For example:

      Series Category Field Value Field Value Field Type
      1 Country State Group By
      2 Country Sex Group By
      3 Country Population Aggregation
  5. Order the series to display the categories (group by fields) in the order desired.