Enable Dataset in Report UI

[VLee1]

How can I enable the "Dataset name" in Report UI (like Figure-1)?

In my environment, I cannot see the "Dataset name" field in Figure-2. Why?  Pls advise. Thank you. 

Figure-1

Figure-2

[Priyanka Chandr]

Hi,

Refer the below link that will give you idea about how to add dataset in report

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/reporting/ta...

Kindly mark it correct and helpful if it is applicable.

Thanks,

Priyanka

[Tushar Hirpurk1]

HI Vlee,

            Dataset name field is only enable when you are dealing with multiple datasouce in single report,

for ex:-  if you want number of open incident and number of open problem and you want it on single bar(column) chart, then only you can create multiple data.

 to find how to create report with multiple datasource please find below link:-

https://docs.servicenow.com/bundle/geneva-performance-analytics-and-reporting/page/use/advanced_repo...

https://community.servicenow.com/community?id=community_blog&sys_id=b1c20e1adb926380fb115583ca96195d

Please mark reply as Correct/Helpful, if applicable. Thanks!

Thanks

Tushar

[Nikhil Phalke · Accepted solution]

Hi,

First you need to create a report and the save it.Then follow the below steps.

1. Navigate to Reports > View / Run.
2. Select a report with a type that supports multiple datasets.

   You can add additional sets to bar, horizontal bar, line, column, area, and spline reports.

3. Click the Show report structure icon ().
4. Click Add dataset.
5. On the Data tab, provide a custom name for the additional data set to appear in the legend of the report, select a data source, and click the Configure tab.
6. On the Configure tab, specify applicable fields the same way that you would configure a standalone report. Note attention to the following fields on applicable report types.
   Note: The Display data table option is not available from the Add dataset module, but is only available from the Configure tab of the main Report Designer. If the Display data table option is selected, only the first dataset will display on the data table.
7. On the Style tab, specify the following fields the same way that you would configure a standalone report.
8. Click Save dataset.

Please mark Correct and Helpful based on the impact.

Regards

Nikhil