Create Trend Chart with both Bar and Trend Line

[Debbi L]

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:

I can find one that looks like this:

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

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

[Sindhu3]

Hi,

Select Report type is Pareto, That is similar to Trend Line chart. Try it once.

[Debbi L]

Thanks. The only problem with the Pareto chart is that it's displayed in a numerical order, trending downward. The chart that I need is by date.

[Debbi L]

This is what I'm trying to achieve. I created this with static data in Excel. Does ServiceNow offer a similar report? The issue here is that the trend line in this case requires an average of a count. I can't find a way to do that.