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


Video

Description

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:

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.

LEAVE A REPLY

Please enter your comment!
Please enter your name here