All topics
English

Build and use reports · 3 min read

Cross dimensions in matrices and explore charts

Build a line-by-status matrix and inspect the policies behind each result.

In this guide
  1. Recipe: insurance line by status
  2. Read cells and totals
  3. Choose chart and value
  4. Open underlying records
  5. Recognize aggregates and limits
  6. Keep learning

For: CRMDAY One users with the Insurance profile.

Recipe: insurance line by status

  1. Create a Policies Matrix.
  2. Choose Insurance line for Rows.
  3. Choose Status for Columns; two different groupings are required.
  4. Keep Records as the matrix and chart value.
  5. Add relevant filters and inspect the preview.
Matrix configuration: insurance line in rows and status in columns.
Matrix configuration: insurance line in rows and status in columns. Open the image to enlarge it.

Read cells and totals

Each cell represents the intersection of a row and column. The 12 example policies are distributed across Health, Medicare and Life and Active or Processing status.

Row totals combine a product; column totals combine a status; the grand total covers the scope. Heat shading helps comparison. Selecting a monetary metric changes cells from counts to values.

Matrix and chart of 12 policies by product and status.
Matrix and chart of 12 policies by product and status. Open the image to enlarge it.

Choose chart and value

ChartUse
ColumnsCompare products or periods.
BarsCompare carriers with long names.
LineChronological evolution.
DonutCategory share of a count or sum.
No chartPrioritize the table or matrix.

Charts require grouping. In Chart, select Records or an added metric for the displayed value. Donut is unavailable for averages, minima and maxima because these are not additive parts of a total.

Selecting a bar chart and the displayed value.
Selecting a bar chart and the displayed value. Open the image to enlarge it.

Open underlying records

  1. Click an actionable group, cell, bar, point or slice.
  2. Check the side panel and record count.
  3. Use pagination and the configured record columns.
  4. Open a record to inspect its details.
  5. Close the panel to return.

The image opens Aurora’s three active policies. Their premium sum is $510, while the panel contains three records: amount and count are different measures.

Detail of three active policies in the Aurora Health Demo group.
Detail of three active policies in the Aurora Health Demo group. Open the image to enlarge it.

Recognize aggregates and limits

Charts with many categories may combine some into Other or leave remaining groups in the table. Investigate individual categories or refine filters to inspect the components of an aggregate.

Large-group warnings mean the result was limited. Prefer status, product, carrier or owner over thousands of unique client names in a matrix. A cross-tab is not evidence of historical journey conversion.

Keep learning

Updated October 25, 2026.