How do you create a single report that shows incidents opened and closed for yesterday?

[e_wilber]

I am looking to create a bar chart that shows a graph of all the incidents that were opened vs closed yesterday.

I can create a report that has a condition of CREATED or CLOSED on YESTERDAY but I don't have anything to "group by". Ideally the text below each column would say "Created" and "Closed".

I can't group by state because I don't care what state it's in, I just really need to know if it was created yesterday and/or closed yesterday. How can I do this with reporting?

[Giles Lewis]

This is a report with two datasets. 

First you create a bar chart for Incidents opened yesterday. Group by some field that you are not using (which always has the same value) so that you will get a single bar.

Save your report. Then click the icon in the upper right beneath the "Run" button that looks like this:

Add a second dataset which is a bar chart for Incidents closed yesterday. Group by the same field that you used before.

Name the first dataset "Opened Yesterday".

Name the second dataset "Closed Yesterday".

[AndersBGS]

Hi @e_wilber ,

think you need to look into to have an additional dataset added to your report. You can find the documentation here for how to do it: https://docs.servicenow.com/bundle/vancouver-now-intelligence/page/use/reporting/task/t_AddAnAdditio...

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders