All topics
English

Build KPIs and dashboards in Analytics · 2 min read

Create application and renewal trends

Show change over time and understand which date the chart distributes.

In this guide
  1. Define the event
  2. Choose module and metric
  3. Set date and granularity
  4. Read and open a month
  5. Adapt to future renewals
  6. Give the chart room
  7. Keep learning

For: CRMDAY One users with the Insurance profile.

Define the event

Trend answers how something changed over time. The example measures monthly applications by Application date. Effective date would answer a different question for the same policies.

A date field is required. For current active-book size, Indicator or Share is usually more suitable than an entry-date series.

Choose module and metric

  1. Choose New KPI → Trend.
  2. Select Policies and Number of records.
  3. For value trends, choose a suitable numeric field and calculation; this changes the question.
  4. Continue to Period and filters.
Trend using policy count.
Trend using policy count. Open the image to enlarge it.

Set date and granularity

  1. Select Application date; verify the suggested field because the model can default to a different date.
  2. Choose Last 12 months.
  3. Group the series by Month.
  4. Add only the product/status/owner filters required by the question.
  5. Name it Applications by month — last 12 months and create.
Application date, last 12 months and monthly granularity.
Application date, last 12 months and monthly granularity. Open the image to enlarge it.

Read and open a month

The example has 18 applications across August, September and October. Hover or tap to inspect a point and click to open that period’s records.

Grouping can be day, week, month, quarter or year. Zero points alone do not establish an import failure or access issue; check context and records.

Adapt to future renewals

Use Expiration date, a future range such as Next 60 days and an Active-policy filter to show upcoming expirations. Name it Planned expirations: it does not prove renewal completion.

For values, sum the appropriate field and explain its meaning. Expiration-date and application-date series measure different events.

Give the chart room

Use Large or Full width for many periods. If empty, check date-field values and whether the range includes them.

Document the definition and validate at least one point through its records. Dates and access follow the user’s context.

Keep learning

Updated October 25, 2026.