Wednesday, June 1, 2016

Tableau - Do it Yourself Tutorial - Dual Axis & Multiple measures render...



Tableau - Do it Yourself(DIY) Tutorial - Dual Axis & Multiple measures rendering - DIY -13-of-50



In this video, we will see how to create a chart with multiple measures.

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 - 13

4- Drag and drop the Sale Date, and set the detail @Month.

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

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

7- Next, drag and drop the Sales Cost measure to the rows shelf.

8- Click the Sales Cost, on the rows shelf, and select Dual Axis.

9- You can see that both the measures are displayed, as a part of one single chart.



Alright, now to some advance concepts.

10- Right click on the sheet name at the bottom, and select duplicate sheet.

11- Rename the new sheet as DIY - Vid - 13(b)

12- Remove Sales Cost measure.

13- Then click on Sales Amount, and Add Table Calculation.

14- Calculate the moving average of Sales Amount across the table, smoothed with 3 months before and after the date, and also including current value.

15- Let's do the following Hands on exercises.





Hands on - DIY #22

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 Sales Cost and Profit/Loss measure to the row shelf area.

4- Select Dual Axis.

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



Hands on - DIY #23

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- Then click on Sales Cost, and Add Table Calculation.

5- Calculate the moving average of Sales Cost across the table, smoothed with 1 month before and after the date, and also including current value.

No comments:

Post a Comment