Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Morning all,
I have created an aggr that give me a average time to complete a task:
avg(aggr((max(DTT) - min(DTT))*1440, [Alarm ID], DT))
How can I now count the number of records where this average figure is greater than 45?
Cheers
Ned
Where did you use aggr? Can you show anything more?
Hi there,
Currently the aggr is taking the average of the time taken between two dates and is returning a number. I need count of numbers greater than 45 but aren't quite sure where to add it to the aggr - there's quite a lot going on there!
Any help on where to put the count if value is greater than 45 would be appreciated!
It's hard to help if I can't see what it looks like. Is it in the table?
Maybe create an extra column:
IF(...>45,1,0)
Total will count values greater than 45.
But for something more, you need to show this model.