Hi,

With grafana & influxdb, i’m calculating a estimate of the cost of my heating house.

I’m calculating the percent of utilization via this kind of request :

SELECT ($Consigne - “Température” )/ $Ecart * 100 FROM “XXXX”

i want to limit the result value of this single stat to 100 (aka 100%)

I known i can use Set range mappings in single state but i also use this precent in a more complex query : cost of my heating :

SELECT ( $Consigne - “Température” )/ $Ecart * 2.5KWatt/Hour * 0.1272€/KWatt/Hour * $NbPoints / 8.57 (i have a point every 7mm exactly 8.57 == 60/7 ) FROM “XXXX”

On this, ( $Consigne - “Température” )/ $Ecart should never be > 100, Otherwise my calcul is wrong. Any idea how to make this ?

Thanks in advance