What's the best way to get a total count and also categorize the results?
I'm creating a dashboard for our team on submitted tickets but the requestor wants this data to show total ticket amount per team member and also have it broke down into completion dates.
Total Tickets 100
Completed 1 day or less - 50
Completed in 2 days - 25
Completed in 3 or more - 50
I'm pulling this data from another sheet from 2 separate columns; I'm still somewhat new to formulas and I'm just not sure what my best approach would be. I've been pulling form the "Task For" column for who it's assigned too and the Days to Complete/Column24 for the completion date range.
Help Article Resources
Check out the Formula Handbook template!