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

When displaying the aggregation results, Visual Analytics will consider the formatting applied to the topmost and leftmost selection and accordingly show the formatting in the result returned by a function. 

Example 1: Leftmost Selection

In this example, the currency (standard) formatting is applied to profits, and number formatting is applied to quantity ordered new. On selecting cells for analysis, Visual Analytics shows the aggregation result in $ because the first selection is the leftmost cell in the table. 

Example 2: Topmost Selection

In this example, the currency (standard) formatting is applied to profits and number formatting is applied to quantity ordered new. On selecting cells for analysis, Visual Analytics shows the aggregation result in numbers because the first selection is the topmost cell in the table.