Hi Guys,
In the Metric Definition table of HRSD, I want to calculate and display time data from the HR Case (sn_hr_core_case) table with specific conditions on state transitions.
The requirement is to capture only the transition timestamps between selected states, rather than calculating full duration across all intermediate states.
Expected Behavior:
Ready → Awaiting Acceptance
- Capture:
- End time of Ready state
- Start time of Awaiting Acceptance state
- Ignore:
- Any duration or intermediate state changes between these two states
Awaiting Acceptance → Work in Progress
- Capture only:
- End time of Awaiting Acceptance
- Start time of Work in Progress
Awaiting Acceptance → Closed Complete
- Capture only:
- End time of Awaiting Acceptance
- Start time of Closed Complete
Could any one please help me to figure out the solution.
