You may read/view the following articles/videos for the guide on parameter.
- https://interworks.com/blog/interworks/2012/03/26/how-to-create-and-use-parameters-in-tableau
- https://help.tableau.com/current/pro/desktop/en-us/parameters_create.htm
- https://help.tableau.com/current/pro/desktop/en-us/changing-views-using-parameters.htm
- https://www.youtube.com/watch?v=CrfEJ24FWpQ
- https://www.youtube.com/watch?v=rJsaezoTVAE
- https://www.youtube.com/watch?v=opfVV1maNVw
The only problem I faced was to have an 'All' data if the user did not select any or wishes to see all data. None of them help. I tried using Action and Filters, yet it only shows based on selection and all show nothing.
That is until I found this solution.
IFNULL([FilterField],’Null’) = IF [Paramter] != ‘All’ THEN [Parameter] ELSE IFNULL([FilterField],’Null’) END
In a more readable, it will be like this
IFNULL([FilterField],’Null’) = (
IF [Parameter] != ‘All’ THEN
[Parameter]
ELSE
IFNULL([FilterField],’Null’)
END
)
Step to:
- Create your parameter - In this case, you use any Dimension as the Parameter by choosing a List and choose the list by changing the Fixed section and click on Add Values From.
- Don't forget to add 'All' as one additional list
- Drag the Dimension that you used as the parameter from the Dimensions Card into Filters Card.
- In the Filter option, choose Condition and choose by Formula, and insert the above solution into the formula.
- Don't forget to change the [FilterField] to the Dimension used for the filter and the [Parameter] to your created parameter.
- Do ensure that 'All' is the same as your definition in the parameter (the character case and spelling is equal)
- And that shall do it. You are ready to go.
Thanks to the person posted here: https://tarsolutions.co.uk/blog/tableau-add-an-all-to-a-parameter/
There are also an alternative solution to this and posted here: http://www.vizwiz.com/2012/09/tableau-tip-adding-all-filter-option-to.html
0 comments:
Post a Comment