9 Replies Latest reply on Mar 20, 2017 3:47 PM by Lillian Aj

    Retrieving values between dates

    Lillian Aj

      Hi,

      I am a new Tableau user. I am trying to retrieve values between two date periods and I am having challenges doing so. I only have one date field (Transaction Date) and every transaction has a transaction id.

       

      The idea is to count the number of transactions between two periods. The periods are

      Selected Date (This is a user selected date from a calendar / date picker)

      Start Date (This is a derived date. Its value should be 6 months before the selected date i.e. if Selected Date is 31-01-2017, Start Date should be 31-07-2016)

       

      Can anyone help on how to get this done?

      Thanks