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.
Where the history comes from
Section titled “Where the history comes from”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 |
Highlights
Section titled “Highlights”- 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.