Create report showing last weeks tickets closed by day

[NickR2]

Hello,

I am trying to create a report that shows updated or closed tickets from last week, but I need the format to show Monday, Tuesday, Wednesay, Thursday, Friday on the bottom of the report graph. Please see attached. On the bottom it shows Same Day, 2 Days, 2-5 Days etc. I need that to show the week days Monday-Friday and how many tickets were closed per those days. 

[Kevin Paul]

Hi Nick,

"Group by" gives you ranges, what you ask cannot be achieved by ranges.

Here is what you need to do,

While selecting the type of report, select a time series report.

By which you get the option to create a report that trends by a time/date field.

Select "updated" in "Trend by".

Select per "Day".

Take a look at my example,

Hope this helps. Please mark correct / helpful if this solves your query 🙂

[Kevin Paul]

Hi @NickR 

Hope I have helped you. Please mark helpful/correct if you think this has helped you:)

[GB14]

Hello,

There is one report available OOB "Incidents Closed per Week" and you can adjust that per your needs.

https://YOURINSTANCE.service-now.com/nav_to.do?uri=%2Fsys_report_template.do%3Fjvar_report_id%3Dec8245d1d7030200eaae68150e610339%26jvar_selected_tab%3DallReports%26jvar_list_order_by%3D%26jvar_list_sort_direction%3D%26sysparm_reportquery%3Dclosed%26jvar_search_created_by%3D%26jvar_search_table%3D%26jvar_search_report_sys_id%3D%26jvar_report_home_query%3D

Thanks