Custom metric

Like (0) Share

Report

Posted on 27 Nov 2024 10:10:56 by MinerofEmAll

I am trying to create a custom metric that returns the difference in %casecount of cases where case duration is below 1d1hr and cases where case duration is above the case duration median.

I can't seem to find a way.

Here is my initial attempt:

(CASECOUNT(CaseDuration< 1.20:05:39.000) - CASECOUNT(CaseDuration>1.20:05:39.000)) * 100

It doesn't work and I don't know if I should refer to the activity anywhere?

Categories:

Recommendations

2.JPG

All responses (1)

Answers (0)

Suggested answer

LukasCervenan 16 on 07 Jan 2025 at 17:38:11

Like (0)

Report

Custom metric

I recommend to proceed as follows:

1. Create a custom metric to identify cases with a duration greater than 1 day and 1 hour. Its following metric:

IF(Duration()>=Totime(1,1,0,0),1,0)

Thus with value 1, we have cases with greater duration than my target value.

2. Calculate the ratio. Relevant for cases in a particular view (this could be changed, based on required context). Then, the overall ratio in % should be:

100*
Countif(ViewCases,IF(Duration()>=Totime(1,1,0,0),1,0)==1)
/
Countif(ViewCases,IF(Duration()>=Totime(1,1,0,0),1,0)==0)

I am sure there are more efficient ways how to calculate this. If you find out, please share, looking forward to hear from you.