All topics
English

Build and use reports · 3 min read

Create summaries with totals, averages and monthly trends

Group policies by carrier, add metrics and follow applications over time.

In this guide
  1. Recipe: active book by carrier
  2. Choose the appropriate calculation
  3. Read groups, subtotals and grand total
  4. Recipe: applications by month
  5. Validate before reuse
  6. Keep learning

For: CRMDAY One users with the Insurance profile.

Recipe: active book by carrier

  1. Create a Policies Summary.
  2. Group by Carrier; optionally choose Status for Then by.
  3. Filter Status = Active.
  4. Keep the automatic count and add Sum of Net premium. Add Average of Net premium as another metric.
  5. Check the preview and save a clearly named definition.
Summary grouped by carrier and status with active-book preview.
Summary grouped by carrier and status with active-book preview. Open the image to enlarge it.

Choose the appropriate calculation

CalculationMeaning
CountNumber of included records.
SumTotal field value in the scope.
AverageAverage across records with numeric field values.
Minimum / MaximumSmallest / largest value in the set.

Add up to six numeric metrics beyond the automatic count. Explicitly choose the intended field: Plan year is numeric, but summing years does not measure premium.

Read groups, subtotals and grand total

The example includes eight active policies: $1,320 net premium sum and $165 average. Aurora has three policies and $510, Blue Harbor three and $480, Sunrise two and $330.

Expand or collapse the second level. Do not add subtotals again to their children. The overall average comes from records, not an unweighted average of differently sized group averages. The table percentage represents record-count share. Premium is not automatically agency commission or revenue.

Eight active policies: $1,320 net premium sum and $165 average.
Eight active policies: $1,320 net premium sum and $165 average. Open the image to enlarge it.

Recipe: applications by month

  1. Create another Policies Summary.
  2. Group by Application date and choose Month.
  3. Use date filters for the desired range.
  4. Choose Records for the chart value and Line or Columns.
  5. Sort groups in ascending natural order for a chronological series.

The image distributes 12 fictitious applications across August, September and October. Created at measures entry into the system; Application date measures the business event.

Twelve applications across August, September and October 2026.
Twelve applications across August, September and October 2026. Open the image to enlarge it.

Validate before reuse

Click an actionable group or chart segment to inspect records with the original filters preserved. Check dates, status and values before presenting the analysis.

Date grouping supports day, week, month, quarter and year. Timestamps use the user’s time zone; date-only fields preserve the day. Keep the same criteria when comparing results.

Keep learning

Updated October 25, 2026.