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

[klavan32]

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 · Accepted solution]

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

[J Siva · Accepted solution]

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

[Tanushree Maiti · Accepted solution]

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

[klavan32]

 Thank you @J Siva  and @Tanushree Maiti