The status bar at the bottom of Visual Analytics window displays built-in aggregate functions when two or more segments are highlighted. By default, Visual Analytics only displays the sum of numerical values for the highlighted segments. To choose more functions, right-click on the status bar and then click the desired functions.

Contents

• Aggregation Functions
  • Count, Count Number, Count Distinct
  • Sum
  • Max, Min
  • Average
  • Standard Deviation
• Aggregation Formatting
  • Example 1: Leftmost Selection
  • Example 2: Topmost Selection

Aggregation Functions

Count, Count Number, Count Distinct

• Count: When selected, this function returns the number of selected segments.
• Count Number: When selected, this function returns the number of selected segments containing numerical values. Null values are ignored.
• Count Distinct: When selected, this function returns the number of unique values in the selected segments. If there are duplicate values then it considers at least one duplicate value in the result. Null values are ignored. See Example.

Sum

Selected by default, this function returns the sum of numerical values in selected segments. Null values are ignored.

Max, Min

• Max: When selected, this function returns the largest numerical value in selected segments. Null values are ignored.
• Min: When selected, this function returns the smallest numerical value in selected segments. Null values are ignored.

Average

When selected, this function returns the average value in the selected segments. Null values are ignored.

Standard Deviation

When selected, this function returns the standard deviation of all values in the selected segments. Null values are ignored. 

Aggregation Formatting

Example 1: Leftmost Selection

Example 2: Topmost Selection