How to find average for two different items?
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?
Best Answer
-
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.
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
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.
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thanks, Jeff! worked like a charm. Also, thanks for the explanation
-
Glad I could help.
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!