Forum Discussion

PabloGiraldo's avatar
PabloGiraldo
Helper IV
5 years ago
Solved

Apply 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 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    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.