The progress score chart is a great chart to use if you are wanting to track a count against a set benchmark.
The chart options for the progress score chart function similar to a simple score chart, after selecting a data source and entering any conditions, you will have the option to choose an Aggregate type, aggregate field, and (most importantly for this chart) a threshold. The threshold is the value that the count will be compared against. For example, if the threshold is set to 100, and the value returned by your conditions is 73, the bar will be almost 3 quarters filled.
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:
Count: Calculates the number of records in a set.
Count Distinct: counts the number of unique, non-duplicated values in a field.
Sum: Adds up the values of a specified field for a set of records.
Average: Computes the average value of a specified field for a set of records.
Minimum: Finds the minimum value of a specified field in a set of records.
Maximum: Determines the maximum value of a specified field in a set of records.
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.