Aggregate by avg

[ndeeleysww]

Hi,

I have some alarm counts joined to rainfall data. I need to count my alarm instances if the average rainfall for the day is greater than 0.

I have this but it's not working - any ideas on a fix?

count(Aggr(If(avg(RainfallValue)>0),[Alarm ID]))

Kind Regards

ND

[hic]

Try

Sum(Aggr(If(Avg(RainfallValue)>0,1),[Alarm ID], Date))

This will count over all combinations of [Alarm ID] and Date, so you probably want either [Alarm ID] or Date as dimension.

[ndeeleysww]

Brilliant - thank you!