Combining multiple reports into a single one for a dashboard

Dan114
Kilo Contributor

Hey everyone,

I am struggling with is (what I assume) a simple issue. I would like to create a report that visually combines the results of three other reports.  For instance - I would like this report to show escalated incidents, breached SLAs, and reassignments.  I have setup the conditions for each of these reports to show what I need but I cannot figure out how to group them to show in a single report that I can use to drill down into each category. I'm not looking to do anything fancy and am using OOTB reporting tools. I am still very new to how reporting works with ServiceNow, but I have not found much related to what I am trying to accomplish here or anywhere else. In essence, here is what I would like to accomplish:

find_real_file.png

12 REPLIES 12

Hi Eric,

 

no, you can't combine list reports using this method since it could mean mixing apples and oranges. However, can you provide more details on what you're specifically trying to achieve? Perhaps we can figure out another way to do it. 🙂

 

cheers  /Tommy 

Hi Tommy,

Even I want to show some different conditional data in form of pie chart as I want to show the percentage. I am reporting on Interaction table. 

Basically i want to combine different condition reports in one and show the statistics in there.

Can you help.

Hi Tommy.  Thanks for your quick response!  We have recently upgraded to a newer SNOW, and tried these steps.  When trying to create a report - now it creates a visualization. 

Quite simply put, I'm trying to do a list view union of Modules and Systems.  All the columns I want are exactly the same for both.  I want the union to exclude duplicates similarly to the SQL UNION operator.  I'd also like to add an additional column to be either M or S to signify if it comes from the modules or systems data source. 

I am not a SNOW admin, so if the option is just not available for me, how would I request it to our admins?  Any help would be greatly appreciated!