Pivot table view
The pivot table view displays search results as a statistics chart that summarizes the data and provides insightful aggregations. It offers several visualization types (area chart, bar chart, heat map, and so on) and several aggregations (balance, first, maximum, and so on).
Fields
To add a field to the pivot table:

In the Field section, click Add .

Configure the following parameters:
Field
Type
Description
Value
Mandatory
Field
Dropdown list
Defines a table field.
List of available fields.
Yes
Position
Radio buttons
Sets the field position.
None / Row / Column
Yes

Click Save.
Visualization
To configure the Pivot table visualization:

In the Visualization zone, click Add .

In the Type dropdown list, select an option.

To enable the desired aggregation, click the applicable switch to turn it on.

If you configured several aggregations, select Default next to an aggregation to set it as the default aggregation.

Click Save.
Visualization options
The following table lists the available visualization options.
Visualization 
Description 

Area Chart 
An area chart displays graphically quantitative data. It is based on the line chart. 
Bar Chart 
A bar chart or bar graph is a chart or graph that displays data in rectangular bars with heights or lengths equivalent to the values that they represent. 
Col Heatmap 
A column heat map shows the magnitude of data in a column as color in two dimensions. 
Column Chart 
A column chart displays categories along the horizontal axis and values along the vertical. 
Heatmap 
A heat map shows the magnitude of data as color in two dimensions. 
Line Chart 
A line chart is a type of chart that displays information as a series of data points connected by straight line segments. 
Row Heatmap 
A row heat map shows the magnitude of data in a row as color in two dimensions. 
Stacked Bar Chart 
A stacked bar chart is a graph used to break down and compare parts of a whole. Each bar in the chart represents a whole, and segments in the bar represent different categories of that whole. 
Stacked Column Chart 
A stacked column chart is used to compare the contribution of each value to a total across categories. The column in a stacked column chart is divided into categories, with each column representing a total. 
Table 
A table is a collection of related data held in a table format. 
Table Barchart 
A table bar chart is a chart or graph that displays the collection of related data in rectangular bars. 
TreeMap Chart 
A tree map is an arrangement of rectangles that shows the hierarchical structure of data. 
Aggregations
After selecting a visualization, you can enable one or multiple aggregations by using the toggle switches. You can also select an aggregation as default.
The following table of fields provides the basis for aggregation.
Aggregations 
Number of fields required 
Description 

Average 
One field 
Aggregate refers to the total sum of elements in a data set. 
Balance 
One field 
Balance is the sum of data, with cost expressed as a negative value and budget as a positive. 
Count 
No field 
Count is the total number of data points. 
Count as Fraction of Columns 
No field 
The fraction of the number of data points in respect of the number of data points for the entire column. 
Count as Fraction of Rows 
No field 
The fraction of the number of data points in respect of the number of data points for the entire column. 
Count as Fraction of Total 
No field 
The fraction of the number of data points in respect of the number of all data points. 
Count Unique Values 
No field 
The total number of unique data points. 
First 
One field 
First returns the first value of each column. 
Integer Sum 
One field 
The sum of the data points converted to integers. 
Last 
One field 
The last value of all data points. 
List Unique Values 
One field 
Lists all unique data points. 
80% Lower Bound 
One field 
80% lower bound value means a parameter value from a distribution of such values within the lowest 80% of that distribution. You must use 80% lower bound with another aggregation; otherwise, it returns an error. 
Maximum 
One field 
The maximum value of all data points. 
Median 
One field 
The middle value of all data points. 
Minimum 
One field 
The minimum value of all data points. 
Sample Standard Deviation 
One field 
A sample standard deviation indicates the spread of data points, calculated from the typical distance between each data point and the mean. 
Sample Variance 
One field 
A sample variance indicates the variation of all data points. 
Sum 
One field 
The sum of the data points. 
Sum as Fraction of Columns 
One field 
The sum of the data points in respect of the number of data points for the entire column. 
Sum as Fraction of Rows 
One field 
The sum of the data points in respect of the number of data points for the entire row. 
Sum as Fraction of Total 
One field 
The sum of the data points in respect of the total number of data points. 
Sum over Sum 
Two fields 
The sum of one set of data points divided by the sum of another set of data points. 
80% Upper Bound 
One field 
80% upper bound value means a parameter value from a distribution of such values, which is within the highest 80% of that distribution. You must use 80% upper bound with another aggregation; otherwise, it returns an error. 
For information on how to display a budget as a pivot table, see Display the budget as a pivot table.