Applies to: Nevron Gauge for SharePoint (WSS3.0, SharePoint 2007/2010/2013)
How to configure a gauge web part that displays the SUM from a table column?
Say you have a data set with three columns A, B and C. In this example we will use the following SharePoint list:
We will configure the gauge to displays the contribution of column A (Pointer 0) to the grand total of all columns (A, B and C). We will also compare with the combined contribution of columns B and C - shown with a red marker (Pointer 1).
1. The pointer value for column A (Pointer 0) must have this expression:
=SUM(Fields!A)
2. The pointer value for the SUM of columns B and C (Pointer 1) must have this expression:
=SUM(Fields!B)+SUM(Fields!C)
3. To configure the gauge axis to show the grand total of all columns (the sum of A, B and C), we will do the following:
- Set the gauge axis Min to a constant zero: =0
- The gauge axis Max value must be set to this expression: =SUM(Fields!A)+ SUM(Fields!B)+ SUM(Fields!C)
Article ID: 162, Created On: 12/22/2010, Modified: 1/29/2013