Performance Analytics - average count and trend line in one chart?

[Sandy7]

Hello - I would like to know if someone has any tips on how to do this type of chart/graph in Performance Analytics:

I want the average number of catalog tasks closed per month shown as a bar chart. (I already have this calculation) then in the same chart, i would like the mean time to resolve for catalog tasks above the bar chart as a trend line (I already have this calculation, too).. I am just not sure how to get this data into one chart. 

Any suggestions?

thanks,

[Adam Stout]

For Reporting, you can add multiple data sets - https://docs.servicenow.com/csh?version=latest&topicname=c_MultipleDataSets

For Performance Analytics, you just add additional indicators to the widget - https://docs.servicenow.com/csh?version=latest&topicname=add-indicators-to-widget

[Slava Savitsky · Accepted solution]

For Time Series widgets, there is a related list Widget Indicators at the bottom of the page where you can add further indicators.

[Sandy7]

Hi Slava, thanks that helps a lot!

I was wondering if there was a way to force the line (which is time in hours), to be above the bar -- as you can see from the screenshot, it's hard in Sept and Oct to see the time value. I'd like to force the line to always be above the bar.. any ideas? thanks!

[Slava Savitsky]

Not sure if it is going to make a difference but could still be worth giving a try. What if you swap the primary and the secondary indicator, i.e. use the one you've added to the related list as the main one and add the other one to the related list?

What you could also try is experiment with "from" and "to" values on the Axis Settings tab. This way you should be able to get the line displayed higher than the top edge of the bars.

Besides that, you could use "Show data labels" option to have the exact scores displayed on the chart, so that the users don't have to guess.