Report - Pivot table closed tickets per week for each tech

[joconnor]

I am trying to create a pivot table report that shows me how many tickets each of my techs closed per week.  It would include RITM (sc_req_item), INC (incident), and CHG *change_request)

Any advice?

Thank you, James

[VikMach]

Hi @joconnor,
You can take following example and create one yourself. The Data Source where tables names are mentioned has 3 vertical dots. Click on it to create your filter. Closed on Last Week for each table and add your assignment group or assigned to not empty. Whatever fits right.

Let me know if it helped.

Regards,
Vikas K

[joconnor]

trying to set it up so displays closed tickets for each technician, broken down by week over a three-month period. Each column represents a single week, and each row corresponds to a technician. This format allows you to quickly see the number of incidents, RITMs, and change requests each technician has closed per week.