Hello,
Database used: InfluxDB
I have three simple queries in flux language, with a one-day aggregation window.
These three requests are then summed with Grafana with an expression: $A + $B + $C / $D.
$D is a meteorological variable. $A to $C are consumption data.
The problem is that, when it comes to consumption, one of these three data items is not a load consuming in summer.
Despite a “fill (value: 0.0)” in the request for the load that doesn’t consume in summer, when I look in summer (from June to August, for example) the calculation can’t be performed (error message drop) because a piece of data is missing.
My $D variable is subject to a dashboard variable called “Season”. If I select summer, the summer weather data is taken into account, and the same for winter.
I could reuse this dashboard variable to condition the calculation by not taking into account the load that doesn’t consume in summer when “Season” is selected in summer.
But for the moment I’m a bit stuck on how to set it up.
Thank you in advance.