Versions Compared

Old Version 16

changes.mady.by.user Denise McGettigan

Saved on

compared with

New Version Current

changes.mady.by.user Denise McGettigan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Period variance mode allows you to compare time units within current and previous periods side by side, e.g.
Info

You must select a dimension to activate this mode; it is not available in Summary view.

Period Variance mode allows you to compare time units within current and previous periods side-by-side, for example, months of this year vs. months of last year.  If this mode has been enabled for your site, it will become available once you select a dimension.  

Table of Contents
maxLevel2
minLevel2

Info
iconfalse
titleRelated articles

Note that period variance mode is not always enabled and can only be turned on by an advanced administrator with permission  .

How the grid appears in this mode

The grid displays a column for all active properties in the current dimension, then uses a double-height header.  The upper header displays the periods, the lower headers display current, previous, variance and % variance for each period.  This mode is effectively a combination of period and variance modes.  

Insert excerptUse Variance modeUse Variance modenopaneltrue

Example

In this example we want to look at

It is effectively a combination of Period mode and Variance mode.

The following example uses Period Variance mode in the Sales database to analyze a customer's spending for the current month, compared with the previous month.

We

You want to

see

view the sales figures and

also view Select 

the variance as a percentage.

  • From the 'Sales' database select 'Ship to' dimension and select a customer (in this example, we have selected 'Intercast'). Focus on that customer.

    1. Click the Customer dimension, select the customer (Intercast Ltd), then click the Focus button. The grid displays columns for the active properties (such as Code and Name) for that dimension, a Total column, and a column for each time unit in the current period.

    2. Click Period > Current month. 

    Select 

    1. Click Mode > Period

    variance, as shown below.
    Image Removed
     The grid will update, as shown below, and you can now compare Intercast's results for the current month (June 2019 with the previous month (May 2019). The % variance between the months is displayed as a column.
    Image Removed

    1. Variance. The grid updates to display a double-height header. The upper header displays the periods, the lower headers display current, previous, variance and % variance for each period.

      Image Added
    Info

    Only one measure can be used in period variance mode

    Related pages