Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

two tables fields to display in a one report for Dashboard

Kri
Kilo Sage

I have 2 tables which contains different fields but I want to merge them in a single report and display it as a dashboard

 

table1 - field1, field2

table2 - field3, field4

5 REPLIES 5

Renat Akhmedov
Kilo Sage

I see two solutions here:

1. Do it with System Definition -> Database Views, here is a good tutorial for this. 
2. Add two reference fields from one table to another, in conclusion, you will have 4 fields available in one table, and use this table for the report, gauge, and dashboard. (doggy solution, please don't do this).


I would solve it with a database view, obviously.

If it helped you somehow, please don't forget to mark it as help, if not - sorry, I tried.