Totals

<< Click to Display Table of Contents >>

Navigation:  Dashboards > dashboard-item-settings > grid >

Totals

Previous pageReturn to chapter overviewNext page

 

The Grid dashboard item enables you to add a summary value (a total) calculated against displayed values of an individual column, and show the result under this column. Note that you can add any number of totals for each column. For example, you can obtain the number of column records, average or maximum value, etc.

Dashboard-Grid-Totals-Main

This topic describes how to create, edit or clear totals.

The topic consists of the following sections.

Totals Overview

Create and Edit Totals

Clear Totals

You can use the following summary functions when creating totals.

Count - The number of records.

Sum - The sum of the values.

func_sum

Min - The smallest value.

Max - The largest value.

Average - The average of the values.

func_average

Auto - The total is calculated using the type of summary function specified for the measure corresponding to the current Grid column. Note that in this case, the total is calculated based on values of the corresponding data field from the underlying data source.

You can create totals using different sets of summary functions. This depends on the type of the data source field providing data for the target column.

Icon

Data Source Field Type

Supported Totals

field-list-icon-boolean

Boolean

Count

field-list-icon-byte

Byte

Count

field-list-icon-date-time

Date-time

Min, Max, Count

field-list-icon-number UIElements_DataSourceBrowser_FieldListIconNumericFloat

Numeric

All available types

field-list-icon-string

String

Min, Max, Count

Important

Note that the Auto type is available only for the Measure column.

To create a total, use the context menu of the column header. Right-click the required column header, select Add Total and specify the type of summary function used to calculate a total.

Dashboard-Grid-Totals-AddTotal

To change the total type, right-click the required total and select a new total type.

Dashboard-Grid-Totals-ChangeTotalType

You can delete one total or all the totals in a particular column.

To delete a single total, right-click a total and select Remove.

Dashboard-Grid-Totals-DeleteOneTotal

To delete all column totals, right-click the column header and select Clear Totals in the invoked context menu.

Dashboard-Grid-Totals-ClearTotals