Friday, July 17, 2020

Tableau Software Information 0.1 [ IT ]

Disclaimer: Pardon me for the typos or any grammatical errors. Also let me know for any finer technicalities if I have missed.


Dual Axis Chart in Tableau

1 It is also called as combination charts. It involves two axes which are independent of each other            & are used to compare two measures which have different scales.

2 For creating dual axes you need continuous data fields,                                                                              For example Sales , revenue ,profit and date fields .

3 In the explanation I will use sample store data set which I have found free on google, you can                  use any data you want.


Dual Axis chart with two measures

1 We have Sales, Profit, and Sub-Category fields in our sample data set. We will use sales and                    profit for making dual axis chart.

2 For Creating Dual Axis chart first Drag Sub-Category into Columns.

3 And Drag Sales and profit into Rows.

4 Right Click on Second measure on rows sum(Profit) in our case and select Dual Axis .

 

5 Now you can see Dual Axis chart of Sales and Profit but if you notice both the measures have              different marks cards & you can format two measures differently.

6 If we want to have a bar chart for Sales, click on the SUM(Sales) section on the Marks card                    and choose Bar from the drop down menu.

 

7 Also you can select Line Chart for Profit from Sum(Profit) section of marks card.

8 You can decide whether or not two axes should be synchronized.To do so, right click on the                    Profit axis and select Synchronize Axis.

 

9 And here our Bar & Line Dual Axis chart or Combination Chart is ready.


Dual Axis Map with two measures

1 To Create Dual Axis map select States into data pane .

2 Now select profit into colors ,and change chart to Map. This is a map for Profit.

 

3 Press control “ctr” and drag latitude next to latitude and we get two maps.

 

4 Now in the marks card of second map remove profit and drag sales into size and select circle                  from drop down also adjust the size ,color, border  if you want . 

 

5 Once you get two separate maps for Sales & Profit respectively, to make dual axis map we                       simply click on second latitude from rows and select Dual Axis.

 

6 And our Dual axis map for Sales & Profit is ready.

 

I hope that this helps you to understand how to create Dual Axis Chart & Map in Tableau. 

You can also visit my channel to watch video of how I created Dual Axis Chart & Map on sample data set.

"https://www.youtube.com/watch?v=9XdCWY-YUOg"

Please comment below if you need information on any other topic in tableau.







No comments:

Post a Comment