Average if multiple criteria

PaigeKucz

I am looking to see if there is a way to have multiple average ifs to show a visual for the current working project

So IF status = working, and assigned to Group 4, I am looking to show average # of days:

1.) Submitted to triage

2.) Triage to start

3.) Start to Root cause

4.) Root cause to council approval

5.) Council Approval to Pilot

Find more posts tagged with

Formulas

Dashboards

Accepted answers

Paul Newcome

It sounds like you actually need an AVG/COLLECT combo instead to be able to include multiple range/criteria sets.

=AVG(COLLECT([Number of Days]:[Number of Days], Status:Status, @cell = "Working", Group:Group, @cell = "Group 4"))

All comments

Paul Newcome

It sounds like you actually need an AVG/COLLECT combo instead to be able to include multiple range/criteria sets.

=AVG(COLLECT([Number of Days]:[Number of Days], Status:Status, @cell = "Working", Group:Group, @cell = "Group 4"))

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.