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
Giga 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.

In this video I'm going through some of the report functionality and how you can use datasets, drilldown and make conditions on related list records. All recorded in the Madrid Release