Dashboard creation using Two Tables data

[Siva V]

Hi,
I have a scenario where we need to create a Dashboard based on the data comparison between two tables. Dashboard should be showing matched & unmatched data from two tables. How can I achieve this.

[Community Alums]

Hi @Siva V ,

For your Requirement you can Create a Database view to join two tables such that you can compare it.

[Sebas Di Loreto]

@Siva V 

I recommend you to type "database views" on your instance and take a look at the out of the box examples.

Good ones are the ones that combine tickets with the metrics table. For example, change_request with metric_instance tables. There are reports that are impossible to create if you don't have the DB view that combines information from both tables. If you want to report on certain metrics (assignment_groups for example) and then you want to cut the information by change type you couldn't if you were using just the metric_instance table. That is why for that report you should use change_request_metric, which is a DB view.