Max(Aggr(Max(Temperature), Location, MAC, [Datetime.autoCalendar.Month], Comment))

[TomBond77]

Hi experts

I have the above expression.

This expression should calculate the maximum temperature value of the given dimenion combination. But it still shows the maximum of the whole result set. Where is the error?

Thanks

[lyr_com]

Hi,

I understand that you want to obtain the maximum temperature of the group formed by: Location, MAC, month and comment?

Try: Aggr(Max(Temperature), Location, MAC, [Datetime.autoCalendar.Month], Comment)

[TomBond77]

the above formula mentioned myself is correct. I misinterpreted the result. Thanks.