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?