Report Structures - Combine reports from other tables

[Andrew_TND]

I often receive questions on how to combine 2 reports of give extra visual layers to a report and the answer is always "Have you tried configuring the report structure?"

This little button here...

This handy little feature allows you to,

Add a drilldown, it adds a second layer to your report so when you click on a bar, part of the pie or link on your chart and it will guide you to how this is all broken down based on the conditions you set.

Add dataset. have you ever wondered how you can put 2 tables data side by side or add a trend line into your instance based off another table? This is how. You can click the link and add multiple table data against your current dataset by simply creating a report.

A number of other seasoned ServiceNow veterans will already know about this however if you don't then I'm glad you found it useful and if so please mark as helpful.

[JosephW1]

Yeah, great point! Here are some sample visuals of reports that are using multiple datasets to go with your blurb.

[Andrew_TND]

Thanks for adding some examples! Its a handy tool. I've used it for all sorts in the past, a good example of this is when I worked for a consultancy a customer had a set number of purchased hours.

So I added a new table called purchased hours which had the number of hours the company had that month and had this as a dataset against time cards table so we had real time data on how many hours said client had remaining.

[Karun S]

It's helpful when you are comparing b/w 2 datasets. For example - Incidents opened/week v/s Incidents resolved/week.

[JReynolds]

I am just getting started on using multiple datasets. I love what you did here. What I need to do is this:

I have 3 technicians working tickets. I want a bar graph to display the number of incidents, requests, and tasks completed per technician in the past 7 days. I have 3 separate bar graph reports. I don't need to track each day.. just the total of each kind of ticket closed for each tech over the past 7 day period. I want to show all 3 columns for each tech in one bar graph. 

I can easily download the data and produce this in a spreadsheet but I want to add this to a dashboard if it is possible. 

[KevinC23]

Is it possible to edit an existing Report that is based on one data set, to include an additional data set? I had problems with not having the the ability in modifying the Reporting structure to allow me to reference the 2nd data set. The datasets in question where the original Incident Table data, and adding in Request data table, so we could report on the Incident vs Request during post go live period

[rohitkathur]

Hi thanks , but  I only see the add drilldown within same table and no additional drill down to add additional dataset, am i doing something wrong

[rohitkathur]

 I am trying to create a report using two tables , essentially a time sheet record , one table Time-Worked and  other table customer service  for the account name , this is to capture various project timesheets a single resource worked on, is there a out of the box report for the same

[David Hepburn]

@rohitkathuryou'll need to create a database view to join [time_card] or [time_sheet] to the [task] table (or child table) ; then build your report off the database view.