How to add the group by field filter in the dashboard in ServiceNow?

[PratikK098]

Hi Everyone,

                   I have one requirement to filter the end date field of the hardware asset table using a group by along with a filter as this year and last year with it in the dashboard list widget. If anyone knows how to group by field in the dashboard please help me with it. Thanks in advance!

[AJ-TechTrek · Accepted solution]

Hi @PratikK098 ,

Group by date is not possible in dashboard or reports or you need to create a customer attribute in that you need to store the Year of end date then you can group based on year.

Also the filter you can use below get the end date for this year and last year.

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

Ajay Kumar

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

ServiceNow Community Rising Star 2024

[PratikK098]

Thanks @AJ-TechTrek for your help.