6 Replies Latest reply on Sep 18, 2012 1:45 PM by nickster

    Counting Upgrades in Tableau

    nickster

      Hello,

       

      I have a data set that lists customer transactions by user id. Each row of data contains user id, transaction datetime, plan (where plan is the ending plan/subscription type that  the transaction results in).

       

      I am trying to work out which transactions count as upgrades. An upgrade is defined as any user that starts with a free or day plan and ends with a monthly plan.

       

      I suspect that I need to use custom sql to change the structure of my source data to get to this number, as the starting plan and ending plan are currently recorded on separate rows.

       

      I am attaching a workbook with some sample data. I would be grateful for any guidance.

       

      Thanks

      Nick