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

sri86 · ‎08-01-2022

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.

Mohith Devatte · ‎08-02-2022

@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

View solution in original post

Raja keerthana · ‎02-24-2023

Hi,

As this recently discussed, I would like to know about data collector jobs for indicators developed on database view.

so the database view is created on incident and problem. Should I add jobs related to both tables to it?