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