DataViewer

Dataviewer: Plotting an Average/Total Column

Add an additional column to include average/totals for the filtered data

As of August 2024 Dataveiwer will no longer be available for new clients. We advise using the PowerBI functionality as an alternative see Adding a Power BI Report .

Existing clients however will still be able to use this functionality. 

In Dataviewer, it is possible to add an additional column to include average/totals for the filtered data.

Plotting an average/total column

This is really simple to do, just follow these steps. 

  1. Open your Data set and create a new Exhibit.
  2. In the Data pivot table view, set up an unfiltered table showing all of the data.
  3. Click the filter funnel icon for the column or row you'd like to plot an average/total for and tick the Show: Total box.

    image 127
  4. You can also calculate a sum, mean or count of the data in the Values area by clicking the filter icon.

image 128-1