Tableau charts with calculated field

0 votes

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

Jul 19, 2018 in Tableau by ffdfd
• 5,550 points
701 views

1 answer to this question.

0 votes
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.

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.
answered Jul 19, 2018 by Atul
• 10,240 points

Related Questions In Tableau

0 votes
0 answers

Creating a multiple charts with calculated field

Sample data: Table Name: A Mode Country Month Visitor ...READ MORE

Aug 17, 2018 in Tableau by ffdfd
• 5,550 points
617 views
0 votes
1 answer

Creating a calculated field with LOD expression

Go ahead and try the following three ...READ MORE

answered Apr 20, 2018 in Tableau by ffdfd
• 5,550 points
1,143 views
0 votes
1 answer

Is it possible to join tables on the basis of some calculated field in Tableau?

@Ammy999, You can not perform join in the ...READ MORE

answered May 17, 2018 in Tableau by Mathew1810
1,384 views
0 votes
1 answer

Tableau Trend Line with Date Field Calculation

Try This: if Date= today() then 1 elseif dateadd('day',- day(DATEADD('month',1,Date)),DATEADD('month',1,Date))=Date ...READ MORE

answered Aug 25, 2018 in Tableau by ffdfd
• 5,550 points
1,449 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
9,842 views
+2 votes
1 answer
+2 votes
1 answer
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 30, 2018 in Tableau by QueenBee
• 1,820 points
4,001 views
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,564 views
0 votes
1 answer

How to combine rows with same information in Tableau

@Ghost, Tableau has a function RANK_UNIQUE which you ...READ MORE

answered May 25, 2018 in Tableau by Atul
• 10,240 points
7,622 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP