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. |