Report - multiple lines/trends?

Sandy7
Tera Expert

Hi, is it possible to create this type of report in ServiceNow? (I think my screenshot is from Power BI).

I have 3 separate years (the lines), and then want to show #s per month each year...

 

find_real_file.png

2 REPLIES 2

ProcessMatters
Tera Guru

Yes, Out of Box you can have aggregate charts.

If you want time based/trend based data, you would require Performance Analytics for whichever module you are looking at. In this case, I assume PA for HRSD, which is a separate paid subscription.

More info for PA can be found at https://www.servicenow.com/products/performance-analytics.html

Ripu Daman1
Tera Expert

It is indeed possible to get trend lines(even if you dont have perf analytics). All you have to do is use a dataset and you can add multiple trend lines to the same report. 

Note: you will need to create a dataset per report.

Adding Dataset to a report.PNG

Final Report:Incident Opened vs Closed over time.PNG

 

here is a video by Goran which explains the process of adding a dataset and multiple trends in a report. You can start from the 8 min marker:

https://youtu.be/SQACTGJJoTE?t=495

Please let me know if you have any questions. Mark this helpful if found this helpful so that others can also find it useful.