Create a new report on Problems Count query

[Shantharao]

Hi All,
How to show created problems count breached problems count and resolved problems count per month in a single report like the below screenshot 

[Dr Atul - LNG]

Hi @Shantharao 

I tried some initial stuff at my end, to do this, you need to create a Database view of task_sla and problem table and then we can create some reports, but I am still not sure if we will get the exact report or not.

DB view like thsi

[AndersBGS]

Hi @Shantharao ,

Based on your requirement, you can create a time series report and add multiple datasets into it: https://docs.servicenow.com/bundle/washingtondc-now-intelligence/page/use/reporting/task/t_AddAnAddi...

Problem count should be created based on the problem table.

SLAs should be created based on task_sla table. 

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

Best regards

Anders