I am trying to get the 3 filter on my dashboard where the fields are 4 different types from the Oracle data source.
Filter 1: Type (Close/Open) (coming from same field), Filter 2 : Year (FY-2017/FY-2018) (2 different year field for open and close)
Filter 3: (FY-Q1\Q2\Q3\Q4) (2 different quarter field for open and close) , and other values should display accordingly.
I am not sure whether I have use parameter..if yes..How?
I have attached the sample data source and the dashboard Filter display how do I want to present...
Please let me know the steps...
The simplest way is use Union with maybe custom SQL.
I don't use Oracle, but Oracle is listed in Union available list.
Union Your Data
Connect to a Custom SQL Query
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...