In Report Can we toggle month selection?

[chilanka1]

Hello,

I want a report which help to toggle between month (January, February......dec). That means If I select January, it should display all the ticket created based on the categories in the month January.  I tried the below link and grouped based on category. But I want to toggle between months.

 https://www.servicenow.com/community/platform-analytics-forum/how-to-create-trend-line-report-over-...

Any idea is appreciated. Thanks in Advance.

[Hemanth M1]

Hi @chilanka1 ,

Create a trend type report , trend by month , group by category and apply condition to show this year - would do the job for you:

Ex: Incident created per month and Category wise in one report:

[chilanka1]

Hi Hemanth,

Thanks for the response,

Actually, I did same in my instance as per the above link. But client want to select per month. There should be a toggle option if I am selecting January then need to display records created in January based on category means category in x axis and count in y axis. I didn't find any filter or dropdown to select January, February etc. (instead of created on this year --> created in January) that kind of option they are expecting. Please suggest me is it possible or not.

[Hemanth M1]

Hi @chilanka1 ,

Ther is no OOB configuration to have toggle option to select month in basic reporting, you can achive by creating some custom and functional fields on the table.