Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Using a straight chart with the dimension of meter number.
The expression is =NUM(SUM({$< DATE = {"2018-01*}>}Data),'# ##0') which gives me the sum of consumption for the month of january, data is hourly values.
I would like to add three more expressions to show me the top three values for current month.
To get the max I use =max(Data), =max(Data,2), =max(Data,3) but cant figure out how to add month to the max expression.
The final result is to see a twelve months with top 3 three hourly consumptions and the total of the month.