Tableau - Do it Yourself Tutorial - Histograms using Bins - DIY -6-of-50

Tableau - Do it Yourself(DIY) Tutorial - Histograms using Bins - DIY -6-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 - Histograms using Bins - DIY -6-of-50

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



Histogram is a graph which consists of columns, whose area is proportional to the frequency of a variable or values of a column and whose width is equal to the class interval.



For creating Histograms, we will see how to create bins.



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.

4- Create bins for Sales cost; right click on the Sales Cost measure, and select Create bins.

5- Now set the bin-size as 50. You can set it to per the requirement.

6- Drag and drop the bin, created in the previous step, to the columns shelf.

7- Drag and drop the Sales cost measure to the rows shelf.

Also, change the aggregation property of Sales cost to Count, right in the rows shelf.

8- Drag and drop the Country dimension to color.

9- Drag the sales cost in the label too.

10- Do the following Hands on exercises.





Hands on - DIY #11

1- Add a new sheet.

2- Create bins for Sales amount - size 100, and then drag these bins to the columns shelf.

3- Add Sales Amount in the row shelf, and change the aggregation property to count.

4- Add Channel Type in the rows shelf Marks.

5- Add the Department to the color area.



Hands on - DIY #12

1- Add a new sheet.

2- Create bins for Sales Quantity - size 10, and then drag these bins to the columns shelf.

3- Add Sales Quantity in the row shelf, and change the aggregation property to count.

4- Add Item Category in the rows shelf Marks.

5- Add the Pay Type to the color area.

6- Add Sales Quantity to the label area.