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

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!

Find more posts tagged with

Formulas

functionality

Accepted answers

Jason Duryea

Try using =AVG(COLLECT())

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.