Create Trend Chart with both Bar and Trend Line

Debbi L
Tera Expert

This may be an odd request, but I've been tasked with making it happen, if it's possible. Currently, one of our departments is using a trend chart showing number of tickets opened per week. It looks like this:

find_real_file.png

I can find one that looks like this:

find_real_file.png

But what they want is a report that looks like this (it includes both the bar AND the line):

find_real_file.png

Is this possible in ServiceNow? (They're sample report is from another system entirely.)

7 REPLIES 7

Tara Romero
ServiceNow Employee
ServiceNow Employee

Yes!   In reporting, after you have create your first data set, you have to save your report.   Once you have saved your report you can choose Multi Dataset option from the menu.   This will allow you add a different data point and a different chart type.   Available from Helsinki.


This worked, thank you very much.


Hi Tara Romero,

 

I have the same requirement. Could you please help me where can I find Multi Dataset option with the screenshot.

 

Regards,

Deepak K

Hi Deepak,

This link articulates the process for adding multiple datasets:

https://docs.servicenow.com/bundle/paris-performance-analytics-and-reporting/page/use/reporting/conc...

Thanks,

DJL