Working with Values

From Explore Analytics: The Wiki
Jump to navigation Jump to search

Overview

Values are a core component of Pivot and Chart views. Values are aggregations or calculations based on the underlying data that you want to display in your views.

For example, the following pivot view shows sales per quarter (in the rows), comparing year over year (in the columns). In the pivot, the values are displayed in each cell of the pivot. In this case, the values are a sum, adding together all of the sales for the row and column:

Samplepivot.png

In this example, the following donut view shows a count of incidents, grouped by priority. In the chart, the sections of the pie are proportional to the values (count of incidents):

Samplepie.png

Selecting a Value

The process for selecting values is similar for both Pivot and Chart views.

To select values, navigate to the view, and click the Select Fields button to reveal the field selection pane.

In the selection pane, there is a field that displays all the fields available on the view's table, labelled with an instruction:

Selectfields1.png

Any reference fields will be marked with a right-facing arrow. Click on them to select fields from related tables:

Referencefields.png

To add the value to the chart, simply drag the desired field onto the Value fields field.

Selectfields2.png

When the fields is dropped onto the Value fields field, a Field Settings dialog will appear to give further options on how to display and calculate the values.