-
1. Re: How to provide filter for amount column with these options (Greater Than Equal, Between, Less Than Equal To)
Shinichiro MurakamiFeb 1, 2017 12:29 PM (in response to Zahid Shaikh)
Hi Zahid
Only the way I can think of is below.
Compared against the simplicity of the request, big construction is needed because of the Tableau's data handling feature.
Create three worksheet and combine on Dashboard with "worksheet filter" active.
Create parameter for user to select filter type.
Create calculated fields for worksheet filter.
[At least selected]
if [Select Filter Type] = "At least" then "Show" end
[At most selected]
if [Select Filter Type] = "At most" then "Show" end
[Between selected]
if [Select Filter Type] = "Between" then "Show" end
Create simple workbook with the value which you want to use as filter.
Then duplicate it twice to have total three worksheets.
Then put above calculated field to respective worksheet.
When you select "Between" from parameter, only [Between selected] filter has "Show"
so, pick "show" from the worksheet which has [Between selected] filter.
When you select "Between" from parameter, only [At most selected] filter has "Show"
so, pick "show" from the worksheet which has [At most selected] filter.
When you select "Between" from parameter, only [At least selected] filter has "Show"
so, pick "show" from the worksheet which has [At least selected] filter.
create dashboard.
and put container.
And put three worksheets into that container.
Hide title for each
Now only selected parameter's filter work to hide other two worksheets and gray out filters.
Thanks,
Shin
-
worksheetfilter_SM_10.1.twbx 23.9 KB
-