pivot table in report. how can i select the multiple fields in report row level.

guruvareddy · ‎06-29-2016

when i am creating a pivot table in report. how can i select the multiple fields in report row level.is it possible to create pivot table in performance analytics.

ramireddy · ‎06-29-2016

I don't think you can do it in the same format(Unless, you create a UI page and use your own aggregation queries, which is not recommended at all). Using Performance analytics, You can do like below.

1. Ensure for all these metrics, You have indicators with breakdown as "Application", if they aren't exists already and create indicators for them.

2. Then, you can create a new dashboard, add a tab in the dashboard, For the tab add content. While adding content, you can find all these indicators in "breakdown" section. Add them to dashboard.

In the end, you will have 10widgets in same window displaying, these detail.

View solution in original post

guruvareddy · ‎06-29-2016

Actually iam the new for this Servicenow

this is my Requirement Could you please Suggest me how to create a table

please find the attached Excel sheet.

L1 & L2 Summary
	Incidents						Service Requests
Application	Received	Resolved	Number of tickets met Resolution	Number of tickets breached resolution	Response SLA %	Resolution SLA %	Received	Resolved	Number of tickets met Resolution	Number of tickets breached resolution	Response SLA %	Resolution SLA %
Business Velocity	44	49	36	15	100%	71%	57	64	49	13	96%	79%
Talent Velocity	31	22	20	4	97%	83%	72	77	62	15	97%	81%
Chorus	26	25	20	5	96%	80%	57	64	53	9	98%	85%
Keystone	6	5	4	0	100%	100%	15	12	10	2	93%	83%
vPoint	5	8	3	0	100%	100%	4	9	8	1	75%	89%
vPlus	1	6	4	0	100%	100%	13	15	13	2	92%	87%
RFS	-	-	-	-	-	-	2	2	2	0	100%	100%
BI	2	4	1	0	100%	100%	6	2	2	0	96%	100%
PAT	-	-	-	-	-	-	4	2	2	0	100%	100%
PET	-	-	-	-	-	-	1	1	1	0	100%	100%
vHelp	1	1	1	0	100%	100%	3	1	1	0	100%	100%
Overall	116	120	89	24	93%	79%	234	249	203	42	93%	83%

ramireddy · ‎06-29-2016

I don't think you can do it in the same format(Unless, you create a UI page and use your own aggregation queries, which is not recommended at all). Using Performance analytics, You can do like below.

1. Ensure for all these metrics, You have indicators with breakdown as "Application", if they aren't exists already and create indicators for them.

2. Then, you can create a new dashboard, add a tab in the dashboard, For the tab add content. While adding content, you can find all these indicators in "breakdown" section. Add them to dashboard.

In the end, you will have 10widgets in same window displaying, these detail.

guruvareddy · ‎06-29-2016

Thanks for your valuable information.

ankit_sharma487 · ‎02-13-2017

hi Gaurv, now we have Multilevel Pivot option also and you can select up to 3 fields on row and column level

ankit_sharma487 · ‎02-13-2017

hi Gaurv, now we have Multilevel Pivot option also and you can select up to 3 fields on row and column level