Create and edit period-over-period analysis

Sigmaโ€™s guided workflow for building period-over-period analyses provides a quick and convenient way to evaluate performance over time. Generate dynamic period comparisons without entering complex custom formulas, then easily visualize the results to identify trends, patterns, and anomalies.

This document explains how to use the built-in period-over-period features in data elements (tables, pivot tables, and visualizations).

User requirements

The ability to use Sigmaโ€™s built-in period-over-period features requires the following:

  • You must be assigned an account type with the Edit Workbook and/or Explore Workbook permission enabled.
  • You must be the workbook owner or be granted Can explore or Can edit workbook permission.

Key terms

The following terminology is used throughout this document:

Current period
The reference period used as the starting point for the comparison.
Comparison period
The lookback period used as the end point for the comparison.
Period value
The metric value for the current period.
Comparison value
The metric value for the comparison period, or the value used to compare the current and comparison periods (depending on the comparison value type).
Comparison value type
The type of comparison generated (difference, % difference, or value).

Build a period-over-period comparison

Jump-start your period-over-period analysis with Sigmaโ€™s guided workflow. Your input generates a comparison grouping that can be augmented, edited, and visualized as needed.

  1. Open a workbook in Explore or Edit mode and select the data element you want to update. If working with a visualization, maximize the element to view and edit the underlying data table.

  2. In the table, click the caret () in an existing column header to open the column menu.

  3. Hover over Add column via, then select Period over period comparison.

  4. In the Add comparison modal, configure the comparison, then click Done.

    • Compare field: Select a column containing the metric or variable you want to compare.

    • Aggregate: Select an aggregation method to calculate the period and comparison values.

    • Using date column: Select a date column to aggregate for the current and comparison periods.

    • Comparison time frame: Select the comparison period to determine the lookback and date granularity.

    • Output: Select one or more comparison value types.

      Difference
      Period-over-period difference as a raw number.
      % difference
      Period-over-period difference as a percent.
      Value
      Total metric value for the comparison period as a raw number.

    In table elements, Sigma creates a period-over-period grouping with columns containing the current period, period value, and comparison value (demonstrated in the following screenshot).

    In pivot tables and visualizations, Sigma creates underlying data columns containing the truncated date (based on the selected comparison period) and comparison value. You can then use the new columns to configure the element properties.

    ๐Ÿ“˜

    Regardless of data element type, when you select multiple comparison value types in the Output field, Sigma generates a separate column for each.

    ๐Ÿ’ก

    Visualize your period-over-period comparison with a KPI chart. For more information, see Build a KPI chart.

Add a comparison value

Add a comparison value to an existing period-over-period grouping.

  1. In the table, locate the column containing the period value you want to compare, then click the caret () in the column header to open the column menu.

  2. Hover over Add column via, then select an option in the Comparison time frame section.

    ๐Ÿ“˜

    Available options depend on the date granularity of the existing comparison. For example, if the period value is aggregated by month, it can only be compared to other monthly periods. In this case, the Comparison time frame options include Last month, Same month last quarter, and Same month last year. Other comparisons like Last year or Same week last quarter arenโ€™t available because they donโ€™t provide proportionate period comparisons.

    Sigma adds a new comparison value column to the same grouping.

Edit an existing comparison

Quickly change an existing comparisonโ€™s period, value type, and aggregation method.

๐Ÿ’ก

Sigma calculates comparison values using the DateLookback function. To make changes beyond comparison period, comparison value type, and aggregation method, edit the columnโ€™s Sigma-generated formula.

  1. In the table, locate the column containing the comparison value you want to modify, then click the caret () in the column header to open the column menu.

  2. Edit the comparison period, comparison value type, or aggregation method:

    • To change the comparison period or comparison value type, hover over Edit comparison, then select a different Comparison time frame or Output option.

    • To change the aggregation method, hover over Set aggregate and select a different option.


Related resources