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...