Tableau - Do it Yourself Tutorial - Parameters - DIY -4a-of-50

Tableau - Do it Yourself Tutorial - Handling Parameters - DIY -4a-of-50

Tableau Training for Beginners

by

Bharati DW Consultancy

cell: +1-562-646-6746 (Cell & Whatsapp)

email:  info@bharaticonsultancy.in

bharati.dwconsultancy@gmail.com

website: http://bharaticonsultancy.in/







Tableau - Do it Yourself Tutorial - Handling Parameters - DIY -4-of-50

Use the data connection from the Video-1 of the Tableau DIY series



1- Open the saved TWB file - Tableau BDCS DIY.

2- Create a new Sheet, and rename it to DIY - Vid -4

3- Right Click Customer Country, and create a parameter --  "Pick Dimension"

4- Click on "Clear All" button to clear out all values.

5- Add two values - Country and Department.

6- Create a new calculated field "Show Dimension", and then use the if statement as shown.

if([Pick Dimension] = 'Country') then ([Customer Country])

else([Department])

end

7- Right click the parameter - and Show parameter control.

8- Add the calculated field "Show Dimension", and a measure Sales Amt.

9- Change the parameter, in the Show param control.





Hands on - DIY #8

1- Create a new Sheet, and rename it to DIY #8

2- Right Click Channel Type, and create a parameter.

3- Click on "Clear All" button to clear out all values.

4- Add three values - Channel Type, Sales Type and Department.

5- Create a new calculated field "Show Dimension-3", and then use the if statement as shown.

6- Right click the parameter - and Show parameter control.

7- Add the calculated field "Show Dimension-3", and a measure Sales Cost

8- Change the parameter, in the Show param control.



Now Challenge Yourself......

Hands on - DIY #9

Do the exact same exercise as above, but for measures - Sales Amount and Sales Cost.

Create a parameter to Pick Measures.