I want to create a single custom report per month,week, year

[rubesh_u]

I want to create number of incidents created per week,month and year in which i can be able to toggle yearly,monthly and weekly report like i have attached in a single report 

[AakashG2703]

Hi @Dr Atul G- LNG Sir,

Hope you are doing well and glad to see that my explanation seems interesting to you and marked my proposed solution as helpful. It would be my honor to let you know about it.

To make reports like this, you have to click on the top-right highlighted icon as displayed in the image down below.

If you find this information/knowledge/solution helpful, Please don't forget to mark my solution and reply as helpful and accepted.

Thanks ‌‌

Aakash Garg

ServiceNow Developer

[Dr Atul G- LNG]

Thanks mate, I tried this, but not getting way how per month will appear. 

Month and Test is still referring to Inc table without any filter. Do I need to create 2 new report and then add them in dril down?

[AakashG2703]

Hi @Dr Atul G- LNG Sir,

Hope you are doing well.

If you see my Drilldown under Report Structure - "Per Month and Per Week" are just the reports name. While adding Drilldown, you have to create reports as per your requirement like "If you want to create a report and show the data trend like "Incident Per Month", then you just have to click on the "Add Drilldown Option" and then you need to customize the report as per your requirement which is to show the data on a monthly basis. Similarly, For Week as well or whatever report, we want to make or show".

Hope you got it, Sir. If any help needed, we can setup a call via any medium to get it clear and resolved.

If you find this information/knowledge/solution helpful, please don't forget to mark my solution and reply as helpful and accepted.

Thanks ‌‌:)

Aakash Garg

ServiceNow Developer

[Sohail Khilji]

Hi @rubesh_u,

there are 2 ways.

1. Create seprate report.

2. if you need in a single report, make use of dataset and drilldown option on the top right corner of your report.

[AndersBGS]

Hi @rubesh_u 

1. Best solution is to create a report of the incident table with the needed conditions.
2. Add the new report to a dashboard
3. Add a date interactive filter to the dashboard where you can select specified date range. 

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

best regards

Anders