How to use a value in AVG that is selected from criteria

Edward Nadareski

Hello!

Would like to ask a question regarding AVG and the ability to only pick up a value if a certain condition is meet.

Here is what I'm using. =IF({Call Center_Help Desk Data Priority} = "Level 1 - Critical", AVG({Call Center_Help Desk Data Value TTFA}))

Objective: To pull in a value to be averaged for all Level 1 Critical tickets taken in, so I can report / show on a dashboard my Level 1 Critical data.

Any suggestions / recommendations would be greatly appreciated!

Thank you!

Jason Duryea

Try using =AVG(COLLECT())

Jason Duryea

Try using =AVG(COLLECT())

Edward Nadareski

Hello @Jason Duryea ,

Thank you very much for the suggestion. This worked for the calc I needed to get for the report.

Thanks again! -Edward