Standard formulas repository
Here is a repository of common standard formulas used in Analytics:
| Formula | What it measures |
|---|---|
| Count(distinct(caseid)) | Number of processes within the full period of analysis. |
| Avg(casedistinct(leadtime())) | Average Process Lead Time, i.e. Average time to complete a process. |
| Avg(casedistinct(casecost())) | Average Process Cost, i.e. Average cost to complete a process. |
| Sum(eventcost) | Total Cost within the full period of analysis (all the cases). |
| Count(distinct(resource)) | Number of distinct resources involved |
| Count(distinct(role)) | Number of distinct roles involved. |
| Avg(servicetime + waittime) | Average throughput time, i.e. waiting time plus execution time of an activity. - MUST have at least one dimension selected (recommended: “Activity” dimension). |
| Avg(pathtime) | Average time between 2 selected activities. – MUST have “Activity interval” selected. |