1 Reply Latest reply on Aug 16, 2016 9:07 AM by Yuriy Fal

    Use common field from multiple tables to filter one dashboard

    Peter Ludlow

      I have a MySQL database with several tables that all have one column in common and a table has this column as its primary key; I'd like to pull data from all of these tables into a 'summary' dashboard that can be filtered by the common column. The relationship between the primary key and the other tables is one-to-many. I can't seem to get this to work without seeing asterisks in my data because of the one-to-many issue... can anyone tell me a good way to do this? The simplified example below might help explain.

       

      Main Table:

      ClassGradeLocation
      Math5Classroom 1
      English5Classroom 2
      Physics6Classroom 1

       

      Other tables:

      Books:

      BookClass
      Intro to MathMath
      Advanced MathMath
      Romeo and JulietEnglish
      Of Mice and MenEnglish
      Quantum MechanicsPhysics
      RelativityPhysics

       

      Students:

      StudentClass
      FrankMath
      FrankEnglish
      JanePhysics
      JaneMath
      AliceMath
      AliceEnglish
      AlicePhysics

       

      Sessions:

      Session DateSession LengthClass
      6/1/1630 minutesMath
      6/8/1645 minutesMath
      6/2/1660 minutesEnglish
      ...

       

      (you get the idea!).

       

      In reality I have ≈10 tables. I'd like to make a single dashboard that can draw together all the relevant information for one class. (e.g, show the list of students, list of textbooks, average class length) - then as you select the classes the data would change as appropriate. With there being so many tables with different information, I have not been able to join them in a satisfactory way to have Tableau consider it a single data source.

       

      I appreciate any help!