question Can we merge 2 or more reports and display as 1 report ? in Platform Analytics forum

Can we merge 2 or more reports and display as 1 report ?

shaik_irfan — Mon, 10 Sep 2018 15:56:04 GMT

Hello,

Do we have any option to Merge mutiple reports & display one ?

Ex:

Report 1 : To display Closed Catalog Tasks

Report 2: To display Resolved Incidents

Report 3: To display Breached tickets.

I have these 3 reports saved daily basic i export all reports & send a count like below:

Closed Catalog Tasks: 20

Resolved Incidents: 30

Breached Tickets: 10

Total Tickets: 50

Can i display a count by merging all 3 reports or any other way to acheive this ?

Re: Can we merge 2 or more reports and display as 1 report ?

Adam Stout — Mon, 10 Sep 2018 16:24:30 GMT

Can you use a dashboard with 4 single scores? If not, I would look to set these up as 4 indicators in PA and use a list scorecard to display these (which would then include trend lines as well to help understand if this is getting better or worse).

Re: Can we merge 2 or more reports and display as 1 report ?

shaik_irfan — Mon, 10 Sep 2018 17:27:01 GMT

Unfortunately we don't have Licence for PA, REGARDING dashboard and single score we thought of the same but our client expecting as Pivot chart format. Any chances

Re: Can we merge 2 or more reports and display as 1 report ?

Adam Stout — Mon, 10 Sep 2018 17:35:39 GMT

You can't do it with single sores but you could do it with multiple data sets on a time series.

However, Performance Analytics does give you a lot more options. If this is important to see it in this way, perhaps you should look at adding Performance Analytics to your subscription.

Re: Can we merge 2 or more reports and display as 1 report ?

shaik_irfan — Mon, 10 Sep 2018 17:52:28 GMT

Whay do you mean Mutilple dataset? Can you share some example and os this available only Licensed OR Subscription of PA

Re: Can we merge 2 or more reports and display as 1 report ?

Adam Stout — Mon, 10 Sep 2018 19:06:38 GMT

Multiple data sets are supported in reporting without a Performance Analytics license. https://docs.servicenow.com/bundle/london-performance-analytics-and-reporting/page/use/reporting/concept/c_MultipleDataSets.html

Re: Can we merge 2 or more reports and display as 1 report ?

Tanmay15 — Mon, 17 Feb 2020 07:02:35 GMT

Thank You Adam, Irfan.

Thank You For your response.

I will verify the requirement again and get back to you.

- tanmay

Re: Can we merge 2 or more reports and display as 1 report ?

Tanmay15 — Mon, 17 Feb 2020 07:49:33 GMT

Hoe to export more than 1000 records?