1 Reply Latest reply on Jun 8, 2015 12:06 AM by Cyril Belmehdi

    Joining Fact with Dimensions

    Himanshu Jaggi


      I'm new to Tableau and wondering if anyone could help me out with the below query.

      I have created a data warehouse that has one fact table and multiple dimensions. Almost all the dimension could be joined easily except the date and time dimension. I require your help in guiding me how to do so in Tableau. Essentially, we're creating a dashboard that would be requiring user inputs for displaying the insights.

      • Fact table has DateTime field and is of the format: "2015-01-31 23:10:49.4020000"
      • Date Dimension has Date field and is of the format: "2015-01-01 00:00:00.000"
      • Time Dimension has Time field and is of the format: "00:01:43 AM"

      I need to join all these tables, but I'm not too sure how to join this in tableau. Or, if there is any other alternative, please feel free to put across.