Lookup and calculate based on group name

Greetings!

I need to generate a daily report as we launch our new service desk that shows the following items tracked on a daily basis ignoring weekends:

1. Number of Incidents Opened
2. Number of Incidents Resolved
3. Current Backlog
4. Average Time to Resolution

I can easily get all this info from a picot table and do so overall. Now the individual resolver groups want versions of just their group. Can a code wizard automate this for me so I can update the raw data tab and have it easily generate the needed data by group? If I did it one by one it will quickly become my whole day.

Here's the actual file:
try1 (Autosaved).xlsx

The opened time is A1, Resolved is A2, Time To Resolve is in AD1 & Assigned Group is J1

I'm getting backlog by adding previous day's backlog to today's new incidents and then subtracting today's resolved.

Thanks for any help!

~Conan

Hello Conan,

Did you try Pivot table for getting this data?

Regards,
Humac