Standard formulas repository
The following table presents the formulas you can use in Analytics:
| From clause | Formula | Description |
|---|---|---|
| eventlog or case_stats | count(distinct caseid) |
Number of processes within the full period of analysis. |
| eventlog | count(distinct resource) |
Number of distinct resources involved |
| eventlog | count(distinct role) |
Number of distinct roles involved. |
| case_stats | Avg(leadtime) |
Average Process Lead Time, i.e. Average time to complete a process. |
| case_stats | Avg(cost) or Avg(casecost) |
Average Process Cost, i.e. Average cost to complete a process. |
| eventlog | Sum(cost) or Sum(eventcost) |
Total Cost within the full period of analysis (all the cases). For a single case, sum(eventlog.cost) = case_stats.cost. |
| eventlog | Avg(servicetime + waittime) |
Average throughput time, i.e. waiting time plus execution time of an activity. |
| eventlog | Avg(pathtime) |
Average time between 2 selected activities. Must have “Activity interval” selected. |