Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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-1716974972976.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-1716975113056.png

Can anyone help?

Thank you 

0 REPLIES 0