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.
Max() and sum() are both aggregation functions where SET could be used. Try adding your set {$< DATE = {"2018-01*}>} into your max expressions. Like: = MAX( {$< DATE = {"2018-01*}>} Data,2)
Max() and sum() are both aggregation functions where SET could be used. Try adding your set {$< DATE = {"2018-01*}>} into your max expressions. Like: = MAX( {$< DATE = {"2018-01*}>} Data,2)
