A calculated score chart is a type of data visualization that represents calculated scores or aggregated metrics in a numerical formant. The Calculated Score Chart for this example is below. We are looking at open Incidents for the example.

Now let's look at the Data and Chart Options for this example.

Conditions: Set conditions to specify how you would like to query your table. In this example we are querying the incident table. The first Condition is set to State is one of New, In Progress, On Hold. The second Condition is set to State is one of Resolved, Closed, or Canceled.

Operator: Use the Operator input to determine how the conditions will interact with each-other. Think of the first conditions as the numerator, and the second conditions as the denominator. For this example we want the total number of New, In Progress, or On Hold incidents so we will subtract the number of Resolved, Closed, or Canceled incidents.

Aggregate Type: Refers to a data aggregation method or function used to combine or summarize data from multiple records. They allow users to perform calculations on sets of records to derive meaningful insights. Some common aggregate types include:

Aggregate Field: refers to a field that displays an aggregated value based on the data from other fields. These fields are used to perform calculations or summarize data from related records.