Forum Discussion
Needing Help With a Quarterly Report
Hi!
So i've been struggling with this the last 24 hours and I wanted to see if any of you out in this amazing community might be able to help me finally get it figured out.
I've got a quarterly report that was generated via ServiceNow and it breaks down the Average Response Time as well as the Average Resolution Time for the previous quarter, but my boss is wanting to ALSO show the Monthly trend as well, and I'm just not seeing how to do it, when the reports don't have actual dates that the month can be pulled from.
If anyone might have any idea how to get this report to display correctly I would be forever in your debt. I'm enclosing a screenshot of what I'm running into. The table below shows everything I need BUT the Monthly trend. Thanks in advance!!
4 Replies
davehusMemorable Member
Hi @, Is there a month number or anything else in the report that isolates it to a month?
Hi Dave!
Unfortunately that's where I'm running into the issue. These reports in particular don't have any data that distinguish when the tickets were created, so it's not allowing me to break them down by month. if I go into the raw data itself, and add that "Opened/Created" option, where it does create the date field, it throws my existing table completely off. Not sure how to get this unraveled.
- davehus
Hi Anonymous , without any date context then it wouldn't be possible.