DAYS_SPENT_IN_STATE

Description

DAYS_SPENT_IN_STATE returns the total number of days a case has spent (or has so far spent) in a given state, based on the case's transition history.

You can pass the state positionally or using the named argument state.

Example

DAYS_SPENT_IN_STATE('in_review')

This returns the number of days the current case has spent in the in_review state.

Example with named argument

DAYS_SPENT_IN_STATE(state: 'in_review')