Tableau multiple charts with calculated field

Tableau Beginner

I have below raw data table

Table Name: A
Mode Country Month Visitor Air Switzerland Sep-16 Rob Air Switzerland Oct-16 Bob Air Switzerland Nov-16 Ben Air Rome Sep-16 Zen Air Rome Sep-16 Jen Air Rome Oct-16 Todd Air Rome Nov-16 Ron Air Italy Sep-16 John Air Italy Sep-16 Scott Air Italy Sep-16 Jeff Air Italy Oct-16 Audrey Air Italy Nov-16 Steve Ground Switzerland Sep-16 Rob Ground Switzerland Oct-16 Russel Ground Switzerland Oct-16 Zen Ground Rome Nov-16 Ron Ground Italy Sep-16 Dan Ground Italy Oct-16 Timmy Ground Italy Oct-16 Auidrey Water Switzerland Sep-16 Peter Water Switzerland Sep-16 Josh Water Switzerland Nov-16 Rob Water Rome Oct-16 Ben Water Rome Nov-16 Stuart Water Rome Nov-16 Jen Water Rome Nov-16 Todd Water Italy Sep-16 Scott Water Italy Sep-16 Jeff Water Italy Sep-16 LOLO Water Italy Sep-16 Dabbu Water Italy Nov-16 Danu Water Italy Oct-16 Randy Water Italy Oct-16 Demi

Table Name: B
Mode Month TotalVisitorCount Air Sep-16 2500 Ground Sep-16 30 Water Sep-16 100 Air Oct-16 1200 Ground Oct-16 10 Water Oct-16 3500 Air Nov-16 5000 Ground Nov-16 600 Water Nov-16 800

After inner joining these two tables on Mode and Month I want to achieve "Final Table" (below) for Nov-16.

  1. How do I have multiple measures/dimension on secondary vertical axis?
  2. How do I calculate "VisitorRate", because "DIV(countd[Visitors]/[Total Visitor Count])" formula says, I need aggregation on both sides.

Final Table
Mode/Country Switzerland Rome Italy VisitorRate Goal Air 3 4 5 (3+4+5)/5000 0.06 Ground 3 2 3 (3+2+3)/600 0.06 Water 3 4 7 (3+4+7)/800 0.06

So basically, I am trying to plot above "Final Table" from "TableA" and "TableB". Need below sample chart.

enter image description here

Any guidance would be appreciated.

Thanks

Tableau Beginner

I could get Visitor Rate = COUNTD(Visitor Name)/Sum(TotalVisitorCount)

For plotting multiple dimensions on secondary vertical axis, Just used Measure Values on the Row section.

How do I have multiple measures/dimension on secondary vertical axis? --Simple "A/B"

How do I calculate "VisitorRate", because "DIV(countd[Visitors]/[Total Visitor Count])" formula says, I need aggregation on both sides. -- Use Measure Values in row part.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

Tableau Calculated Field - across multiple measures

Tableau Calculated Field error

Tableau calculated field dates

Tableau calculated field

Error in Tableau calculated field formula

Second Max in Tableau Calculated Field

Tableau/SQL Calculated Field With Grouping

Tableau Calculated Field using FIXED

Using filtered results as field for calculated field in Tableau

Tableau: How to create a calculated field that has multiple conditions and only works against other values in the same pane

Tableau calculated field summing up the values

Implementing a calculated field within my Tableau Viz

calculated field in tableau dependent on values in column

Tableau Calculated Field COUNTD Single Value

IF part in tableau calculated field is not getting executed

Create a calculated field to count dimension on a condition in Tableau

calculated field combining multiple fields into one

Tableau: Create a newline between text using a calculated field

Calculated field in tableau to find if the first row is Success or Failure

Get Total Value of Bill Number - Tableau calculated field

Is it possible to count the number of occurrences of a calculated field's result in Tableau?

Regular Expresion in Tableau returns only Null's in Calculated Field

Calculated Field based on an Relation Aggregate with Filter Conditions in Tableau

Tableau calculated field distinct sum of metric base on selected dimensions

Group by calculated field within multiple inner joins / subselects

Tableau. How to get access to a field value of other record in calculated field?

SQL - Calculated field base on calculated field?

Way to hide blank columns in Table Calc in same sheet as field being calculated? (Tableau)

How to pass each row as an argument to R script from Tableau calculated field