The Aggregation Table Widget displays summarized data, such as sums, averages, or counts, for selected datapoints across managed entities in a tabular format. It helps you quickly compare and analyze aggregated values across multiple entities within a chosen time period.

Image: Aggregation Table Widget

Creating Aggregation Table Widget  

1. Access the End User Application.
   
2. Select the Dashboard to which you want to add the Calendar widget.
   
3. In the dashboard view, click Actions > Add Widget.
   
4. Select Tables from the Widget Styles list in the left pane, and select Aggregation Table Widget in the right pane.
   
   
   
5. Click Proceed to display the Add Widget screen.
   
6. Provide the name/title for your widget.
   
   
   
   
7. Select the module  (i.e. Asset, Device, Locations etc.) from the drop down list.
   
8. Select the Datapoint, Field, or Count metric from the Select Measure option.
   
9. Select "Enable Viewing of Instance-specific data" for viewing instance data.
   
10. Click on Add Module Metric to add more modules to the widget. Using this option, you can view two metric values on a day in the widget.
    
11. Select the duration.
    
    
    
    
12. Select the Aggregation type. The following aggregation types are available.
    
    Avg
    Min
    Max
    Last Value
    First Value
    % in Control
    SD SAMP
    SD POP
    
    Refer to the document on Understanding Datapoint Expressions for more details.
    
    
     
13. Click Create. The table will be created and displayed on the dashboard as shown below.
    
    
    
    Image: Aggregation Table widget in a dashboard

 
Advanced Options 

1. Apply Color Rule
   
2. Refresh Settings
   
3. Reorder
   

 

Apply Color Rule 

Refresh Settings

The Refresh settings in the widget allows you to set the time interval at which the widget data automatically gets refreshed.

Note: This option is available for Table widgets and Image Layout widgets.

 Reorder