Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to output incident report grouped by days/dates

JPK1
Kilo Contributor

I'm having trouble creating a report that details incidents by day (or date) since a particular time.

Example: I need to run a report showing all "email" related incidents since 10/15/2019 @ 5:00 AM.

In the attached screenshots, you can see exactly what's been selected, the conditions and the output. The arrows are my wtf moment as I'm not sure how to make that be a day or date. I've tried selecting a trend report as well and that gives me day of the week/2019 which still isn't right.

How do I make the day of the week, or better, the date appear on the Y axis here so that it makes sense to the people viewing it?

 

1 ACCEPTED SOLUTION

Ryan S
Kilo Sage

You need to change to a time-series chart. Then you'll see an option to "Trend By" instead of "Group By"

View solution in original post

2 REPLIES 2

Ryan S
Kilo Sage

You need to change to a time-series chart. Then you'll see an option to "Trend By" instead of "Group By"

JPK1
Kilo Contributor

Thanks! That worked and makes a lot more sense to those consuming the report now.