In a report built with ItemPath, the section that performs calculations is called "Snapshots." Snapshots are used to measure the performance of a report's data over time, and to display KPIs on your custom dashboard.
Snapshots can perform calculations on any numeric field in the report's data. The following calculations are available:
- Count
- Sum
- Average
- Maximum
- Minimum
The "Count" calculation counts the number of rows in the report. This count can be grouped by any field in the report's data. For example, a report of "Orders" could be grouped by "Direction Type" to count the number of picks, puts, counts, etc. This could even be grouped further by a secondary field, such as "Priority" to divide each order type into level 1, 2, 3, and 4 priority orders.
The rest of of the calculations need to be applied to a column containing numeric fields.
At this time, a snapshot cannot perform successive calculations, such as the average of a sum over time.
Read more about setting up snapshots and how to add these charts and values to your dashboard here.
