Reporting on Cases Opened Weekly

[yjko2jk]

Hello, 

I would like to create a report that displays the number of cases opened for each week including the weeks that have 0 cases opened. I currently have a report that only display weeks that have the cases opened.

Could anyone help with creating a report on the above case? 

Thank you.

[Bhavya11]

hi @yjko2jk 

the only thing that comes into my mind is to use Type column and aggregate per Week, but what you will see will be the data on the first day of the week.

If my response proves useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful."

Thanks,

BK

[yjko2jk]

Hi, thank you for your reply. I currently have it as Type column, Trend by = Opened, aggregating the data by per week. But, this chart only shows the weeks that the cases were opened and does not know show for the weeks that had 0 cases opened. Would you know an alternative solution to show all weeks including the weeks that 0 cases were opened?

[Bhavya11]

Hi @yjko2jk 

please refer the link

https://www.servicenow.com/community/platform-analytics-forum/report-quot-trend-quot-how-to-show-emp... 

If my response proves useful, please indicate its helpfulness by  " Helpful."

Thanks,

BK