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

    Joining Fact with Dimensions

    Himanshu Jaggi

      Hi,

      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.


      Thanks

      HJ