Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Create Chart/Report for Average Requests Completed by Resource by Week and Month

Avatar

Level 2

How would I create a chart/report with the average requests completed by resource (Assigned To) by week and month?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 9
Level 9

Hi David, sorry I didn't see this the first time!

I think you want a matrix report. In your request report, switch to matrix grouping for a tabular view that shows record counts by month and week. You can export the matrix to Excel if you need to perform additional calculations.

In some cases (multiple users assigned to the same request, or wanting a combination of completed tasks and requests), you might consider doing this on an Assignment report instead of a Request report.

0694X00000EO8AqQAL.png0694X00000EO890QAD.png

View solution in original post

2 Replies

Avatar

Level 2

I'm looking to do something similar to this as well. I know @Doug Den Hoed‚ has suggested text mode calculations in other threads.

Avatar

Correct answer by
Level 9
Level 9

Hi David, sorry I didn't see this the first time!

I think you want a matrix report. In your request report, switch to matrix grouping for a tabular view that shows record counts by month and week. You can export the matrix to Excel if you need to perform additional calculations.

In some cases (multiple users assigned to the same request, or wanting a combination of completed tasks and requests), you might consider doing this on an Assignment report instead of a Request report.

0694X00000EO8AqQAL.png0694X00000EO890QAD.png