Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Help with report

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