How to create and line in same chart bar

[Alessa]

Hello dear community, I need help:

How can I recreate the yellow line (see the picture) so that the yellow line shows, for example, the average number of tasks for a given user?

I hope you can help me. Thanks in advance

[Praveen V R]

Create dataset option can be used to get the line in the graph. (add an additional data set to a report)

You can follow the steps listed in this

https://docs.servicenow.com/bundle/sandiego-now-intelligence/page/use/reporting/task/t_AddAnAddition...

[Alessa]

Thank you very much!

[AndersBGS · Accepted solution]

Hi Alessa,

You can create your first report on the sc_task table utilizing the filter:

Assigned_to is firstname_lastname

Then add an additional dataset from the report builder top right cornor:

and press "Add dataset:

if my answer have helped you in achieving your goal, please mark my answer as helpful or correct answer.

Best regards

Anders

[MBarrott]

I know this post is old but this guide was extremely helpful, thank you!