4 Replies Latest reply on Nov 27, 2012 12:08 PM by Nelly Snarskaya

    Can't build a pie chart

    Nelly Snarskaya

      Hello,

      There is next dimensions : user id and dates of purchases.

      I want to divide users into two groups: those who made a purchase in the next 15 days and those who have not made. After that I want to count the number of users in each group and build a pie chart.

      Firstly, I use the following calculation called "absence": from the current time subtract the date of the last purchase. Secondly, I take a minimum value of it. Then, I use the following function: IIF ([absence] <15, 'Active', 'Inactive'). So for each user there is label "Active" or "Inactive". But I don't understand how to count number of users in this groups.


      I'm a novice at Tableau and will be very grateful