Find Average for days of completion based on category

Angela Wright

Hello

I have created date submitted, dated completed and the total business days for completion. I would now like to take a category within the sheet and find the average days for completion for a category. I would also like to find average days of completion for assigned to.

Any help is appreciated

Thank you

Angela

Mark Cronk

Hi @Angela Wright ,

Your formulas will be along the lines of:

=AVG(COLLECT([business days for completion]:[business days for completion], [category]:[category], [Category]@row))

=AVG(COLLECT([business days for completion]:[business days for completion], [assigned]:[assigned], [assigned]@row))

You'll need to replace the column names I used with your actual names.

Help?

Mark

Angela Wright

Thank you Mark

This is my first Dashboard, so I am a beginner. Please bear with me. I attempted the formula but still getting an error, "#unparseable". This is what I am attempting, referencing another sheet

It seems that it guiding me to populate like this, but same error message

Your help is much appreciated.

Angela