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

LarsSommer · 10 hours ago

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

Dr Atul G- LNG · 9 hours ago

Hi @LarsSommer

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

*************************************************************************************************************
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 · 9 hours ago

Hello @LarsSommer,

It is not possible in reporting due to certain limitations.

Thanks
Santosh.p