We provide online trainings on data warehousing, data visualization and analytical tools like Cognos BI series, Cognos TM1, Informatica, Qlikview, Tableau. Please feel to contact us - firstname.lastname@example.org or cell # +1-562-646-6746 (Whatsapp enabled).
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.
Subscribe to: Post Comments (Atom)
Post a Comment