Custom Calculation in Operations Dashboard

Idea created by ihandleyesriaustralia-com-au-esridist Employee on Dec 18, 2018
    New
    Score0

    I've been trying to perform a custom calculation on a single field and display the result as a gauge or indicator that can be filtered - the field I'm trying to calculate has values between 1 & 10 and the calculation I'm trying to perform is:

     

    Percent of values between 9-10 (minus) percent of values between 1-6

     

    I'd like to be able to use a formula along the lines of ( (countif(field >= 9) / countif(field >0)) - (countif(field <= 6) / countif(field >0)) )*100 and just display the result as the value for a gauge or indicator

     

    Ian