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.