Powered by Temper

Calculated data series

You can create an automatically calculated data series on any Bar/Line Chart. The calculated series can be a:

  • Sum

  • Difference

  • Average

  • Percent

  • Percent Change

 

How do I add a calculated data series?

Navigate to the Chart with which you want to work, then:

  • Click 2018-04-25_1054.png in the top right corner of the page.

  • In the resulting drop-down menu, click 2018-04-25_1055.png.

Edit_data.jpg

 

In the resulting window:

  • Either add a series by clicking 2018-03-26_1643.png or edit an existing series by clicking its name.

  • Configure the series as you normally would.

  • Locate the "Operator" field under the "Calculated Series" section. In that field, choose which operator the calculated series should use. Depending on which you pick, various new fields will appear.

    If you chose:

    • Sum: Enter each series you want to be added together in the “Series” field.

    • Difference: Enter the series you want to subtract from in the “Series to subtract from” field and the series you want to be subtracted in the “Series to subtract” field.

    • Average: Enter each series you want to be included in the average in the “Series” field.

    • Percent: Enter the series you want as the numerator in the “Numerator Series” field and the series you want as the denominator in the “Denominator Series” field.

    • Percent Change: Enter the baseline series in the “Baseline or Original (% change from)” field and the current series in the “Actual or Current” field.

  • Click 2018-02-22_1616.png.

The series’ column will be automatically filled in with the appropriate data. Click 2018-02-22_1616.png to finalize your changes.

 

Have more questions? Submit a request