I have been trying to write a query which will allow me to filter on tickets which were created OR solved in the year. The key here is that I want to includes tickets that were created OR solved in the timeframe.
Further, I want to include month columns (Jan-Dec) for when the ticket was created or solved.
I achieved this using the Ticket Updates dataset and filtering on Update - Year. By adding Update - Month to the rows, everything was good.
However, the dataset is quite restrictive, so when I wanted to change the query from COUNT(Tickets Solved) to count of tickets solved within 30 days, I hit a problem.
I need the Tickets dataset - but now I cannot filter for Update - Year. Nor can I include Update - Month.
To summarise, what I want is:
Monthly count of tickets solved within 30 days of creation and that were solved in the year 2020
along with the count of tickets created in the same month. There does not have to be any relationship between the closed and resolved tickets, that is, the created count may include tickets resolved over 30 days or not yet resolved, and likewise the resolved within 30 days count may include tickets created in previous months or even years.
Has anyone had anything similar to this and knows how to solve it?
Please sign in to leave a comment.