Little hard to explain but as we speak I’m working on the graph’s for my washing machine.
Therefore I’m using the following query (Left Y)
SELECT mean(“value”) FROM “Instant” WHERE (“idx” = ‘334’) AND timeFilter GROUP BY time(__interval) fill(null)
And because I’m also measuring my water usage the following query (Right Y)
SELECT mean(“value”) FROM “Percentage” WHERE (“idx” = ‘23’) AND timeFilter GROUP BY time(__interval) fill(previous)
I want to hide the data on the right Y (water) when my energy usage on the left Y is below 1.
It’s not possible to put a minimum on the right Y because I’m also using water when the washing machine is off.