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.
