Building a dashboard on a joined table report

Bumsefar
Tera Contributor

Hello All.

 

I wish to build a dashboard containing a bunch of report widgets (all single score reports)

What i wish for, is that when you click the single score widget, you will enter a list view of all the tickets that matches my filter in the actual report.

This is normally quite easy, but i want the report to contain columns from both the TASK table and TASK_SLA table

 

I have managed do create such a report, that helds all the columns i wish for, but when i change it to a single score, i'm no longer able to control which columns are shown!

 

I tried with with the drilldown function, which semi worked, but a few problems occured

1. People who will click on the single score widget via dashboard, is no longer in control over which columns is to be shown, they are now fixed by my report, i want them to be able to choose freely between all columns from both the task table and task_sla table.

2. When clicking the single score widget, they are no longer taken to a new page containing all the tickets, rather the tickets load up inside the widget, which is no good as there might be 10 widgets on the dashboard so each widget is quite small and surely can't give a proper view of all the tickets inside each widget.

 

 

 

Btw. i am not an admin so creating a database view is out of the question.

Also, is it possible to both have columns from TASK, TASK_SLA & Incident table ? (again without database view)

 

I feel i'm so close to my goal yet so far away, any help is much appreciated.

1 REPLY 1

Allen Andreas
Administrator
Administrator

Duplicate post: https://www.servicenow.com/community/itom-forum/building-a-dashboard-on-a-joined-table-report/td-p/2... 


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!