Incident report

[eyal abu hamad]

I want to create a report that shows in bars for each day for the lase month for the incidents that were opened and closed in same day.

sorry for my bad drawing.
but like this more or less

[Pratiksha Kalam]

Hello,
Pls check,
https://www.servicenow.com/community/platform-analytics-forum/create-a-report-of-both-opened-and-clo... 

If answer is helpful mark it as helpful and correct !

Thank you.

br,

pratiksha.k

[Dr Atul G- LNG]

Hi @eyal abu hamad 

I tried in list view and it worked

Create the same in report and share feedback

[JaeggerLegane · Accepted solution]

I would personally recommend to do it in Performance Analytics if you want to trend by date.

Because when you want to trend by date in the standard report designer, you'll be limited in visualization since that does not allow you to stack 2 datasets, only group.

In the example below they will be grouped when using datasets:

In case you want to continue in reports and the above visualization is sufficient for you, then do:
1. Report settings:
- Time series column
- Group by none
- Trend by opened
- Per date
- Filter conditions = opened on last month

2. Add dataset (via the icon top right under run)
- Time series column
- Trend by closed
- Filter conditions = closed on last month