1 Reply Latest reply on Aug 16, 2016 6:01 AM by Yuriy Fal

    HELP!!! Count Of Transactions Within a Date Range That is in a different Data Source

    Johnny Mackle

      Hi there,

       

      I am having some trouble trying to come up with a solution for a problem I am trying to solve, I have looked at many different sources on the web and lots of videos over the last 2 days but seem to be going around in circles as I can’t seem to find anyone who has used tableau to solve this particular problem, it would be a massive help if you are able to assist, basically the problem is as follows:

       

       

      I have a 2 DataSources Called “Period”  and “Transactions”

       

       

      “Period” Data Source has the following dimensions: “PeriodNo”, “Date”,

       

      e.g.

       

       

      PeriodNo

      Date

      1

      01/04/2016

      2

      01/05/2016

      3

      01/06/2016

      4

      01/07/2016

       

       

       

       

       

      “Transactions” DataSource has the following dimensions: “TransactionID”, “TransactionDate”

       

      e.g.

       

       

      TransactionID

      TransactionDate

      1

      01/12/2015

      2

      07/12/2015

      3

      01/05/2016

      4

      01/06/2016

       

       

       

       

       

      I want to create a data grid that gives me a count of all Distinct “TransactionID”s  within the last 6 Months of each “Period”

       

      i.e.

       

       

      PeriodNo

      1

      2

      3

      4

      Count Distinct TransactionIDs

      2

      3

      4

      2

       

       

      I don’t want to have to hardcode in any date values to define date ranges, I want the date ranges to be dynamic based on the “Date” dimension in the “Period” Data Source.

       

       

      Can anyone help please?

       

       

      Many thanks,

      Johnny