two tables fields to display in a one report for Dashboard
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-15-2024 11:08 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-15-2024 12:27 PM
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.