Zum Inhalt springen
Search the hub

← All suppliers

BPM

Pega

Case management & BPM: case/assignment/operator meta — Case API load; no attachment or correspondence bodies.

Templates only — grain, filters, custom fields and ownership are firm-specific.

Copy formulas into the KPI Definition Card, then adapt grain and filters.

Example

Cases created

How many cases were created in the period?

COUNT(*) FROM case WHERE pxCreateDateTime IN period
Grain
Created case
Fields
Case.pyID, Case.pxCreateDateTime, Case.pyClass
Dimensions
case_type, operator

Count sub-cases separately from top-level cases.

Adapt: Segment by channel (portal/API/manual create).

Example

Cases resolved

How many cases were resolved in the period?

COUNT(*) FROM case WHERE pyStatusWork LIKE 'Resolved-%' AND pxResolvedTimestamp IN period
Grain
Resolved case
Fields
Case.pyStatusWork, Case.pxResolvedTimestamp, Case.pyClass
Dimensions
case_type, operator

Handle resolved-completed vs resolved-rejected separately.

Adapt: Exclude rejected/withdrawn cases from a positive resolution count.

Average cycle time

What is the average case cycle time?

AVG(pxResolvedTimestamp - pxCreateDateTime) FROM case WHERE pyStatusWork LIKE 'Resolved-%'
Grain
Case (aggregated)
Fields
Case.pxCreateDateTime, Case.pxResolvedTimestamp, Case.pyClass
Dimensions
case_type, urgency

Account for a business-hours calendar where the SLA requires it.

Adapt: Break down by stage transitions for bottleneck analysis.

SLA breaches

How many SLA deadlines were breached in the period?

COUNT(*) FROM sla_event WHERE deadlinePassed = true AND created_at IN period
Grain
SLA event (breached)
Fields
SLAEvent.deadlinePassed, SLAEvent.goalPassed, Case.pyClass
Dimensions
case_type, urgency, operator

Track goal-passed vs deadline-passed separately for early warning vs breach.

Adapt: Breach rate = breaches / cases per case type.

Assignments open

How many assignments are currently open (snapshot)?

COUNT(*) FROM assignment WHERE status = 'Open'
Grain
Open assignment
Fields
Assignment.ID, Assignment.pyCaseID, Assignment.pyAssignedOperatorID
Dimensions
case_type, operator

Count worklist vs workbasket assignments separately.

Adapt: Only overdue assignments (urgentIn < 0) as a backlog-risk KPI.

Formula overview

Same formulas as a table — copy into KPI cards or SQL drafts.

Label Formula Grain Fields
Cases created COUNT(*) FROM case WHERE pxCreateDateTime IN period Created case Case.pyID, Case.pxCreateDateTime, Case.pyClass
Cases resolved COUNT(*) FROM case WHERE pyStatusWork LIKE 'Resolved-%' AND pxResolvedTimestamp IN period Resolved case Case.pyStatusWork, Case.pxResolvedTimestamp, Case.pyClass
Average cycle time AVG(pxResolvedTimestamp - pxCreateDateTime) FROM case WHERE pyStatusWork LIKE 'Resolved-%' Case (aggregated) Case.pxCreateDateTime, Case.pxResolvedTimestamp, Case.pyClass
SLA breaches COUNT(*) FROM sla_event WHERE deadlinePassed = true AND created_at IN period SLA event (breached) SLAEvent.deadlinePassed, SLAEvent.goalPassed, Case.pyClass
Assignments open COUNT(*) FROM assignment WHERE status = 'Open' Open assignment Assignment.ID, Assignment.pyCaseID, Assignment.pyAssignedOperatorID

Tour