How to create a report to display the data with respect to the year and the months.

klavan32 · 3 weeks ago

Hi Team, I have the requirement where customer wants to have the report that displays the data on yearly basis and also when we the year is selected, it should allow users to select months too to be able to view the data dedicated to that particular month. Please confirm if this is possible in ServiceNow? if yes, kindly provide the way to achieve this. Thanks, you in advance.

J Siva · 3 weeks ago

Hi @klavan32
Yes, it's doable using Trend type report & drilldown option. Please find the sample below.

1. Main report

2. Drill down

Result:

Regards,
Siva

View solution in original post

Tanushree Maiti · 3 weeks ago

Hi @klavan32

Check these posts. similar to your requirement.

1. https://www.servicenow.com/community/service-portal-forum/reports-using-date-as-dynamic-today-this-m....

2. https://www.servicenow.com/community/developer-forum/how-to-create-report-on-monthly-or-yearly-time-....

3. https://www.youtube.com/watch?v=tYsXf3dNdSI&t=1s

Please mark this response as Helpful & Accept it as solution if it assisted you with your question.
Regards
Tanushree Maiti
ServiceNow Technical Architect
Linkedin:

View solution in original post

J Siva · 3 weeks ago

Hi @klavan32
Yes, you can build the same in PA data visualisation.

klavan32 · 3 weeks ago

@J Siva could you please share the steps

J Siva · 3 weeks ago

@klavan32 Updated my prev comments with pics..