Using Database view in the performance analytics not displaying all the table fields in the Show Records in Analytics Hub

[sri86]

I have created a Indicator Source by using Database Views which name as Incident_SLA (Joining Incident and Task SLA). I have created a scorecard widget and display the values in dashboards, When I click on the count of the widget and clicked on "Show Records" options in the Overview tab of analytics hub, I am able to see the field values only from the Task SLA table and not seeing any fields from incident table.

I like to add assignment group and assigned to field from the incident table in the Personalized list for the customers to see detailed report.

Attached screen shot for reference. Is there any way to sort out this.

[Maik Skoddow]

Hi

see the following similar Community question with the answer: https://community.servicenow.com/community?id=community_question&sys_id=d00e9fd01b6e0110be4955fa234b...

Maik

[sri86]

Hi Maik, 

My question was related to Performance Analytics. I don't have any issues with the Database view fields and the List layout. 

When I click on the widget score and Show Records options in the Analytics Hub I am able to see only the Task SLA columns. I noticed that, In the indicator source under the View Table tab by default "Task SLA" table was selected. When I change in to Incident table then I am getting to see all the columns which related to incident. 

But I like to add columns from both the table. Is there any other options?. 

[Mohith Devatte · Accepted solution]

@sri86 ,

hello ,if you are talking about this 

i am afraid that there is no way to add both the view tables as PA allows only one view to be selected to show in analytics hub

what i can suggest is if you want both the field i guess create a new view on the task  sla table and pull all the fields in the form layout using dot walking to the task sla form from incident form using target field .

I cant see any other way than this .

In short bring the required fields from incident form to task sla form and use task sla table as view table in indicator source.

PLEASE MARK MY ANSWER CORRECT IF THIS HELPS YOU

[sri86]

Thanks Mohith, 

I created a new list view in task sla table and added the same in the indicator source List view which works for me.