Need help on Using multiple datasets in a report -

[shaik_irfan]

Hello,

I am trying to use Multiple dataset to join 2 reports within a single report. As per docs i see the below image i need the same thing but unable to get that 😞

https://docs.servicenow.com/bundle/kingston-performance-analytics-and-reporting/page/use/reporting/concept/c_MultipleDataSets.html

Above image shows it combined Bar & Line report but i unable to get that. Can anyone help me out to acheive above report ????

[shaik_irfan]

Agree can you please show the report how to did that ?

With screenshots pleaseeeeeeeeeeeeeeee

[shaik_irfan]

I am trying to pull all the tickets closed / resolved within last 1 week below is my condition:

I am able to get the bar report here with this we need to the line type graph that displays how much time the user has taken for that i unable to create Line report

[Slawek_Radziewi]

I am not sure you can do there time based report.

They should have at least the same X axis grouping. 

In order to do it you would need to somehow count avg or sum for these time scopes (months, weeks) in order to display data on the report. 

You can also try to switch to PA where it is more flexible.

1st for incident counts

2nd for incident duration

You need to have good field which you will be able to use for time calculation (avg etc)

In PA you can add scripts to calculate times (minutes, hours based on start and close time of tickets).

[shaik_irfan]

Thanks for the help. I am able to get this but only problem is i unable to get a Line type along with Column report.

With both Columns i am able to acheive my report but i want to display one as Column & other report as Line thats where i am not able to get i dont know how you are able to select Line type multi dataset with parent report as Column. 😞 😞 😞

[Slawek_Radziewi · Accepted solution]

Try to make main report not Bar but rather Line and then I was able to add second dataset with more options.