Count if an average aggregated value is greater than 45

[ndeeleysww]

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

[qlikeers]

Where did you use aggr? Can you show anything more?

[ndeeleysww]

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!

[qlikeers]

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.