How to report daily inflow and outflow in SNOW

Ven2
Kilo Explorer

Hi all, I am new to ServiceNow. I am trying to generate a report that shows the inflow of incidents to a particular group and outflow of incidents from that particular day on a daily basis. I am fine if these reports are separate as well. This must be basic, but I am struggling to develop this. Please help 

Thanks much in advance  

3 REPLIES 3

Tracy Davis
Giga Guru

for the first part -

report on Incident table with a filter for assignment group = x

I'd start with a list view to make sure you're getting the right data. Then I'd switch to a trend chart and use the following settings.

You'll get a chart view with a count of incidents created by day assigned to that group. You could also add a Group by State so you could see the state of the incidents.

(you may want to add a filter to only show active incidents OR show only ones created in last 12 months, otherwise you'll have too much data to display)

For the second part I'm not sure what you're trying to display. what do you mean by outflow?

 

find_real_file.png

ChamkaurS
Kilo Contributor

Outflow means resolved/closed. Is it possible to have 2 columns representing inflow and outflow in single report. Basically we want to show trend of opened and closed tickets by month in single report