Create a time intelligence measure
A time intelligence measure reports a number against time: this quarter beside last, a year-to-date running total, a twelve-month moving average. It carries a period comparison, a time intelligence axis, or an accumulation, and it is the only kind of measure that does.
Before you start: open a semantic layer and go to Business Context → Measures, then select Add → Time intelligence measure. To compare it with the other kinds, see Choose the kind of measure.
When the option is missing
Section titled “When the option is missing”Two capabilities have to be on. Creating one needs period comparisons enabled for your workspace, which is what puts the entry in the menu. The settings themselves need Business Questions enabled; without it the section is simply absent, with nothing to say why. Measures already built keep working and stay editable whatever the first setting says.
Both are switched on by Astrato, not in your workspace. Neither appears in Administration, so an administrator in your workspace cannot turn them on there. If the menu entry or the section is missing and you need it, ask your Astrato contact.
What the comparison windows mean
Section titled “What the comparison windows mean”Read Period axes and comparisons for what the comparison windows mean and how the axis is shared between measures.
Compare a ratio across periods
Section titled “Compare a ratio across periods”A time intelligence measure can compare a ratio, such as average order value: total sales divided by the number of distinct orders. Create a Time intelligence axis dimension first, then create the measure as a time intelligence measure and choose that axis under Time axis in its Time intelligence section. Each period works out its own numerator and denominator and then divides, so the result is never an average of row-by-row ratios.
The ratio is worked out at the level you ask for. With a daily axis, each row compares one day’s values. With no axis in view, a KPI works the formula out over the whole selected period: a customer who appears on several days counts once in that period’s distinct count, and daily ratios are never added together. Growth is (current − previous) ÷ |previous|; give the measure a percentage format to show it as a percentage.
- A ratio can combine other measures, as long as each of them is itself an aggregate. Measures over unaggregated fields, conditional measures, and measures that carry their own comparison or have parameters cannot be compared this way.
- A whole-period comparison with no axis in view cannot use a time intelligence axis whose range starts or ends at the earliest or latest date in the data.
- Standard, calculated and conditional measures have no Time intelligence section. A comparison one of them already holds is kept when you save it, but cannot be edited there.
To add up, or otherwise combine, values worked out per period rather than compare two periods, see Period axes and comparisons.
Related
Section titled “Related”- Define a measure in Business Context covers creating, publishing and checking any measure.
- Predefined periods such as YTD and MTD.
- Period axes reference for every axis setting.