Hi, I have a problem when I want to divide two of my own metrics. I want to get a result from this kind of formula : a/(b/c)
while a is a metric for each assignee name and b is sum of a and c is total of assignee name
I already have 2 metrics, lets call it metric 1 for a and metric 2 for (b/c)
And when I want to divide metric 1 with metric 2, the calculation can't be saved.
Heres the calculation for metric 1 :
IF ([Comment present]) AND ([Update ticket status - Unsorted]="Solved") THEN [Ticket ID] ENDIF
And for metric 2 :
D_COUNT(metric 1)/c while c is reffering as above
Then I create another calculation for metric 3 :
VALUE(metric 1)/VALUE(metric 2)
and it shown nothing
Kindly tell me, did I use a wrong function for metric 2 or 3, bcs for metric 1 is already correct and the result is valid.
Please sign in to leave a comment.