The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Manually Enter Y and X Axis for a report

John Knopick
Tera Contributor

‎11-14-2022 11:43 AM

Hi!

I created a crude drawing below.  I have 2 data points that I'm wanting to combine into 1 report in ServiceNow.  I'd like the "Weeks" over the last 3 months to be the Y-Axis, and the "Hours" over that same period to be the X-Axis.  I am not wanting to use a Drilldown for this report, and we would like it to all be on the same report so essentially it ends up looking like a massive EKG Machine LOL.  Does anyone know where to go in ServiceNow to MANUALLY put in the Y and X Axis information?  Thanks in advance!

 

JohnKnopick_0-1668454898722.png

 

0 Helpfuls
  • 1,244 Views
1 REPLY 1

olgaredkina
ServiceNow Employee
ServiceNow Employee

‎11-23-2022 05:40 AM

Hi John,

 

To enter manually data there are several way:

 

If you are using classic reporting:

  1. You can use excel import as a data source. The downside of this is that it lasts typically up to 3 month, after that you would need to recreate report
  2. If you have admin rights - you can create a table where this manual data will be stored and use it for reporting

In both of those cases you need to have one field  with date  and time - where you can use same date, but use accurate hour on what you want in X axis, and second field where you will store number of weeks as a number.

Then you can use timeseries line report with aggregation hour of the day.

 

If you use next experience analytics - in data visualisation you can pass data manually in json format (if you are comfortable with json) or use custom table similar to above example.

 

(if there is any existing table where you can add record and that has date and numeric input - you can use that too. just filter)

 

Regards,

Olga

0 Helpfuls