max expression

[runesson]

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.

[Vegar · Accepted solution]

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)

[runesson]

Worked, thanks!