Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Is it possible to add "filter by year" as indicated in the screenshot for a report? If so, how?

LarsSommer
Tera Contributor

Hi everyone,

 

I am quite new when it come to SNow Reporting. I recently created the below report where I combined the number of closed vs. the number of created incidents per month in a single report.

 

Now I am wondering if and how it is possible to add in the overview a filter like the purple one I indicated? Being able in the report "dynamically" to filter by year as the report become with every month smaller and smaller. For sure I could create by default for every year a report, but this feels like unnecessary duplication.

 

So far I as well not find a video where this is described, but may be I am not looking for the right key words.

Any help would be highly appreciated?

 

Thanks

Lars

LarsSommer_0-1758198119507.png

 

2 ACCEPTED SOLUTIONS

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @LarsSommer 

 

No, but if you add a parameter like "Group By," then you can bring in this limit to some extent.

DrAtulGLNG_0-1758202062365.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

SP22
Giga Sage

Hello @LarsSommer,

It is not possible in reporting due to certain limitations.

Thanks
Santosh.p

View solution in original post

2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @LarsSommer 

 

No, but if you add a parameter like "Group By," then you can bring in this limit to some extent.

DrAtulGLNG_0-1758202062365.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

SP22
Giga Sage

Hello @LarsSommer,

It is not possible in reporting due to certain limitations.

Thanks
Santosh.p