Skip to content

Dynamic Trends

A number tells you where you are; a trend tells you where you’re heading. Dynamic Trends charts any measure over time on a clean, modern dashboard, so managers can spot a slowdown, a growing backlog or a slipping margin at a glance. Each trend is a card with:

  • the latest value, and the change against the previous period in green or red, depending on whether higher is better;
  • an area, line or column chart;
  • a Day / Week / Month / Quarter / Year switch;
  • a table view of the same figures.

Clicking a point opens the records behind it.

Each trend chooses its History From:

By Period Snapshots
How Each point is the measure calculated for the records whose Date Field falls in that period A background job saves the measure’s value every day
History Straight away, as far back as your data goes Builds up day by day from the day you set the trend up
Good for Things that happen on a date: sales invoiced per month, orders created per week Things that are a state: open orders, overdue balance, items below reorder point
Needs A date field on the measure’s table (Posting Date, Document Date, Order Date and so on are suggested for you) The Dynamic Trends job running
Clicking a point Opens that period’s records Opens the records as they are now
  • Ratios and percentages: divide one measure by another, for example profit %. See Ratios and percentages.
  • Personal trends: measures with {USERID} or {SALESPERSON} chart each user’s own figures.
  • Audiences: show each trend to everyone, or only to the users you list.
  • Secure: values are calculated with the user’s own permissions to the data.
  • Regional formats: values follow the user’s settings, and the chart axis uses short numbers (12k, 1.2M).

Next: Setting up.