Need help on Using multiple datasets in a report -

shaik_irfan
Tera Guru

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

find_real_file.png

 

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

 

 

 

1 ACCEPTED SOLUTION

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

 

find_real_file.png

View solution in original post

10 REPLIES 10

Slawek_Radziewi
Kilo Sage

You add one report and then in new view you add second dataset.

find_real_file.png

 

After that you can see both reports.

 

 

 

I created Line Type report later i click on Multiple Dataset i see only Line, Step Line, Column but i cant see Bar.

 

find_real_file.png

 

Can you please send me the screenshot of you got that ?

I see this error:

 

WARNING: The main report and multiple series are not compatible (Types must be compatible: Line/Area/Column/Spline or Bar/Bar or Horizontal Bar/Horizontal Bar).The incompatible datasets will not apply when it runs the report
 

Check Types of data displayed. 

Not all can be used.

Try to change them for your datasets and verify which one will work.

find_real_file.png