Report Help - Custom Report - Request ID field
Hello,
I'm creating a custom report and need the option of "Request ID" in the Group ID field:
Here’s the settings I have:
I'm creating a custom report and need the option of "Request ID" in the Group ID field:
Advanced Matrix Report
- Column Grouping
o Columns: Executed Time
o Date Formate: Day
- Group By
o Technician
o Group
o Request ID
- Summarize Column By
o Sum
o Time Elapsed
- Date Filter
o Executed Time During Last week
- Advanced Filtering
o Technician is <List of selected Tech Names>
What I need is the next Group By option of Request ID that’s highlighted above. I
I’d like to get a report that basically will show a day by day break down of each Technician’s time, for the week prior, and a sum for each task. Grouped By Technician/Group/RequestID. This would show the total time they entered in the work logs on each ticket.