Wednesday, June 1, 2016

Tableau - Do it Yourself Tutorial - Reference Lines, Bands,

Tableau - Do it Yourself Tutorial - Reference Lines, Bands, & Box - DIY -12-of-50

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(DIY) Tutorial - Reference Lines, Bands, & Box - DIY -12-of-50



In this video, we will see how to create Reference Lines, Bands, & Boxes.

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

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

3- Goto a new Sheet - DIY - Vid - 12

4- Drag and drop the Sale Date and department to the columns shelf area, and set the detail @Year.

5- Next, drag and drop the Sales Amount to the rows shelf.

6- From the show menu set the chart type to bar chart.

7- To add a reference line, right click on the Y-axis on the left side, and then select Add Reference Line.

8- Add a reference line to show the average of Sales Amount.

9- Add reference bands.

10- Do the following Hands on excercises.





Hands on - DIY #20

1- Add a new sheet.

2- Drag and drop the Department, and item Category dimensions to the columns shelf area.

3- Now, Drag and drop the Profit/Loss measure to the row shelf area.

4- Add a Reference Band.

5- Add Profit/Loss measure to Mark-color area.



Hands on - DIY #21

1- Add a new sheet.

2- Drag and drop the Channel Type, and Employee Country dimensions to the columns shelf area.

3- Now, Drag and drop the Sales Cost measure to the row shelf area.

4- Add a Reference Box.

No comments:

Post a Comment