8 Replies Latest reply on Sep 28, 2018 7:25 AM by ShivaRam Chennapragada

    SQL query in Tableau

    Divya Sharma

      Hi All,

       

      Please help me to create the subset of data in Tableau.

      In my SQL database, I have one dimension, called Date. I want to create the subset of this Date table and want to perform the left join between this subset and Fact table.

       

      The SQL query to create the subset is :

       

       

      Select distinct LastDateOfMonth from [dimension].[Date]


      LastDateOfMonth between '2016-01-01' and '2018-01-01';

       

       

      How can I achieve this in Tableau.

       

       

      Thanks.

      Divya