Recent searches
No recent searches
Measuring tickets by workday in te month
Answered
Posted Aug 04, 2022
Morning folks,
I need to create a report that compares the tickets created on the last month versus the tickets on the current month by working day. My report should me something like this:
I'm using Weekdays as Workdays, so any ticket created on Saturdays and Sundays shouldn't be considered.
Is there a way for me to do this?
0
3
3 comments
CJ Johnson
Hi Pedro,
Very buildable!
Filters:
Ticket Solved - Day of Week -- Set this to exclude Sunday/Saturday.
Ticket Solved - Month -- I set this filter to the last 2 months.
Add a row attribute for "Ticket Solved - Day of Month"
Set the top metric as D_Count metrics, and you should get something like this:
The blank days are the Sat/Suns.
0
Pedro Farias
Hi CJ!
Thanks for replying!
I managed to get to the point you mentioned, now I need to remove the blanks (Weenkends) and insert a count on the "Day of month" column to show which business day it was.
I'm not sure if it is possible.
0
Dainne Kiara Lucena-Laxamana
Hi Pedro Farias
You can just move the attribute "Ticket Solved-Day of the month" to the Columns so that it would looks something like this:
Before:
After:
It would also remove the blank filters since there are no more rows.
0