How to find average for two different items?

SIS

Finding average.PNG

Hi all,

I'm trying to find the average day to process two different types of material. 1. raw material, 2. non-testing material (Material Type Column). In the release timeframe column, I have counted the days between the created and release date. But what I'm trying to do is to get an average time to release raw material and non-testing material separately. Eventually, I will pull into a dashboard to show how long it takes on an average to release the Raw material and non-testing material.

Can you suggest any way to do it?

Jeff Reisman

https://community.smartsheet.com/discussion/87171/how-to-find-average-for-two-different-items

You could create two summary fields, one for each of your two material types, using AVG(COLLECT functions:

=AVG(COLLECT([Release Timeframe]:[Release Timeframe], [Material Type]:[Material Type], "Raw Material"))

=AVG(COLLECT([Release Timeframe]:[Release Timeframe], [Material Type]:[Material Type], "Non-testing Material"))

In English, collect the timeframe values where the Material type is "Raw Materials" and give me the average value.

Jeff Reisman

https://community.smartsheet.com/discussion/87171/how-to-find-average-for-two-different-items

You could create two summary fields, one for each of your two material types, using AVG(COLLECT functions:

=AVG(COLLECT([Release Timeframe]:[Release Timeframe], [Material Type]:[Material Type], "Raw Material"))

=AVG(COLLECT([Release Timeframe]:[Release Timeframe], [Material Type]:[Material Type], "Non-testing Material"))

In English, collect the timeframe values where the Material type is "Raw Materials" and give me the average value.

SIS

Thanks, Jeff! worked like a charm. Also, thanks for the explanation

Jeff Reisman

@SIS

Glad I could help.