2 of 2 people found this helpful
First of all wish you and your loved ones very Happy New Year...!
You can use the advance function property if you have the multiple metric fields of ticket counts as show in below example.
I pull closed tickets field twice and applied advance function on second closed tickets field. Within advance function, use the option 'Percentage against Column' and then select 'Number of Incidents' from the columns section.
See if it helps you.
1 of 1 people found this helpful
Alternatively, both dividend and divisor in your example are integers, thus result is cast as integer as well; this can be changed by converting at least one value into real number either by multiplying or dividing by 1.0 (e.g. (<value1> * 1.0) / <value 2>, or <value1> / (<value2> / 1.0)).
That works, Thanks Sinisa!