Skip to main content Skip to complementary content

Trend over time analysis

Show the performance of a measure over time, optionally broken down by a dimension with low cardinality.

Trend over time analysis

Trend over time analysis showing the average cost of sale over order date

Creating trend over time analyses

  1. In Assets, click Analysis.

  2. Drag and drop Trend over time into the sheet.

  3. Click Add dimension and select a temporal dimension.

  4. Click Add measure and a select a measure.

  5. Optionally, to add an analysis period, do the following:

    1. In the properties panel, under Analysis properties, turn on Analysis period.

    2. Under Calendar period, select the calendar period to use.

    3. Under Period, select a specific period to use.

    Information noteAnalysis periods requires calendar periods in the logical model. For more information, see Defining analysis periods with calendar periods.
  6. Optionally, in the properties panel, under Appearance, adjust the appearance of the analysis.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!