How to get day wise case opened and closed reports

[Prashanth Ranga]

Hi All , 

I want to have a dashboard which gives the day wise case information on opened and closed records . some thing like below 

Can i achieve this without database views ? 

Thanks,

Prashanth 

[AndersBGS]

Hi @Prashanth Ranga ,

Push the button in right top corner after you have saved the initial report:

Afterwards, click data set:

In the new dataset, chose again incident table:

In the time series chose column once again:

Next, chose your condition e.g. resolved last week

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

Best regards

Anders

[Guido Bernuetz]

That's a typical use case for Performance Analytics.

Make your customer/user happy with PA!  🙂 

https://docs.servicenow.com/bundle/utah-now-intelligence/page/use/performance-analytics/concept/pa-o...