Report Trend by Day-of-Week and Hour-of-Day

[APJ]

Hello,

I am trying to produce a very specific report on requests (catalog tasks) and incidents that trends by day-of-week in the X-axis and hour-of-day in the Y-axis.

It appears that the options to trend by are only available for the X-axis.

I can only group by the entire date field or other fields such as Assigned to.

The business context is that I want to see a trend graph of our requests and incidents in a certain time window by both the day of the week and the hour of the day within each day of the week.

Is such a report possible?

Thanks!

[James Chun · Accepted solution]

Hi @APJ,

I am not sure if you can achieve the requirement in a single report, but you can use the drilldown functionality.

https://docs.servicenow.com/bundle/washingtondc-now-intelligence/page/use/reporting/task/t_DefineARe...

For example, we can create a report on an Incident date that is trended by the created_on field.

Next, create a drilldown to display the subset of data to show hour of the day.

Hope that helps, cheers

[APJ]

Thank you for the reply and the suggestion.

How do you see a drilldown on a dashboard containing the report?

[James Chun]

Sorry, not really sure what you are asking here.

The report will look like other ordinary reports, and if a user clicks on a bar, the report will be refreshed into the drilldown report.

[APJ]

Thank you for replying - I think that I understand the drilldown functionality now.  It starts from the report data set and then drills down into reports based upon subsets of of the report data set as you navigate the report (i.e., clicking on a bar in a time series column type report).  If your main report trends by year, you can create drilldowns for month, and week from month, day from week, etc.