Forum Discussion
PabloGiraldo
Helper IV
Helper IVApply filter from two columns
Hi - I have two tables each containing a "Status" column. I created a pie chart with data from both tables. Now I want to create one filter with the "Status" of both tables - Open or Closed. I ...
Hi,
You should create a third table with only 1 column which should list all unique status entries. Then create a many to one relationship from the Status column of both tables to the status column of the third table. To your visual, drag the Status column from the third table.
Hope this helps.
Ashish_Mathur
Super User
Super UserHi,
You should create a third table with only 1 column which should list all unique status entries. Then create a many to one relationship from the Status column of both tables to the status column of the third table. To your visual, drag the Status column from the third table.
Hope this helps.
PabloGiraldoWorked like charm! Thank you!
- Ashish_Mathur
You are welcome.