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 

[Mark Manders]

You can with Performance Analytics, or put it on a dashboard and add an interactive filter.
It's not something you can select on the reports as your screenshot shows.

[Dr Atul G- LNG]

Hi @rubesh_u 

You cant create a single report with all parameters.  Either create 1 report and put the interactive filter or create separate reports.

[AakashG2703 · Accepted solution]

Hi @rubesh_u,

Hope you are doing well

Proposed Solution

In order to achieve this task, you can have a look into "Add Dataset and Add Drilldown" feature in reports of ServiceNow. To offer the best approach and solution and get the solution as soon as possible, I tried to make it on my Personal Developer Instance and attached the screenshots of the outputs for the reference that will give you better insights of how the report seems to be visible and the best thing will be to follow the solution and try to create the same on your instance.

For the perspective of guidance, I attached the screenshot of the Dataset and Drilldown feature as a view that help you to create it on your instance.

How it works?

1. You need to click on the datapoints for which you want to see the incidents created per month and then per week, if record exists.
2. Displays data or details like Incidents Per Year > Per Month > Per Year after each and every click.

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]

Hi @AakashG2703 

Nice explanation ., Could you please help me

How you get this .. I am trying but not seeing like this.