Calculate percentage of cells complying to one criteria

Hi,

I need to calculate the percentage of cells within a certain time frame that comply to a certain criteria.

More specifically, I need to calculate the % of complaints closed in the past 28 days (Date of closure = TODAY -28) that have a complaint investigation duration of less than 15 days.

Please find an example of the sheet I need to use for the calculation.

Help would be highly appreciated.

Margherita

Find more posts tagged with

Formulas

Accepted answers

Sing C

Hi @Margherita Falavigna,

I hope you are well. You could capture the % in a Sheet Summary Field, using the following formula:

=COUNTIF([Date of Closure]:[Date of Closure], >TODAY(-28)) / COUNT([Date of Closure]:[Date of Closure])

Remember to set the formatting of the Sheet Summary Field to 'Percentage'.

Let me know if this will work for you.

I hope this helps.

Have a wonderful day!

Thanks,

Sing

All comments

Sing C

Hi @Margherita Falavigna,

I hope you are well. You could capture the % in a Sheet Summary Field, using the following formula:

=COUNTIF([Date of Closure]:[Date of Closure], >TODAY(-28)) / COUNT([Date of Closure]:[Date of Closure])

Remember to set the formatting of the Sheet Summary Field to 'Percentage'.

Let me know if this will work for you.

I hope this helps.

Have a wonderful day!

Thanks,

Sing

Margherita Falavigna

Super! It works! Thanks a lot for the feedback :)

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.