We have a field called Service center (eg. EMEA, LATAM etc) and we want to create a weekly report of number of incidents opened from each region and resolved from each region every week.
I tried creating a list report, a pivot table etc, but all the report types consider the actual timestamp when I put in the "created" field of the incident as the time measure. I want it to be aggregated, eg. Incident created today at 6 pm, today at 7 pm and yesterday at 6pm, should be aggregated and counted as 3 incidents in the week 16th august to 29th August. I tried creating a line chart with the trend field, but the grid cannot be exported as an excel file.
I am attaching a screenshot as a reference of the type of report we want to create as an example. Currently we are doing it manually through excel, but we would like to know if we can leverage the power of SNOW in this.
Hi Apoorv Mehta
This is an easy report when using Performance Analytics. Most of what you need to create a report that displays all opened and closed incidents per service center are out of the box.
The only thing you need to do is create a breakdown on the field service center and create the widgets to show on the report.
And the best part is you do not need to export the data to excel and create a manual report every week! Furthermore the reports are actionable, meaning you can click on the report and access the tickets on which the report is based.
Here is a screenshot as an example:
This example is by Assignment Group, but that's easily changed to your custom service center field.
Cheers,
Vincent
