Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Help with report

Community Alums
Not applicable

Hi,

I need to create a line report in ServiceNow, similar to the one shown in the attached image (created in Excel).

I have selected the table I need data from, but I am currently unable to display the trend by year. I know I can create separate reports for each year, but the goal is to combine them into a single report. To summarize, I want to show (as in the image):

  1. Months along the bottom.
  2. Years in the legend.
  3. A coloured line for each year.

 

Dev86_0-1716990573217.png

 

 

Additionally, for a different report (bar chart), I would like to include the same dropdown box highlighted in the image below, enabling the selection between "months/years/weeks" to display the data accordingly.

Dev86_1-1716990573174.png

 

Can anyone help?

Thank you 

0 REPLIES 0