Customer purchase frequency

Identify how often on average  customers shop. How many customers shop once a month, shop once every 2 months, etc.?

Step 1:

 Find the first and last purchase dates of every customer 

     

Step 2:

 Count how many times the customer has purchased in between the first and last purchase

    Step 2.1: 

    Find how many months passed between the customer's    first     and last purchase. 

     Step 2.2: 
     Find the total number of purchases per customer. 

   Step 2.3: 

   Find the purchase frequency by dividing the amount of time      he/she has been a customer by the number of purchases.

Step 3: 

Create a histogram

      Step 3.1:

      Convert Purchase Frequency to Dimension so we can bin our customers by these numbers

      Step 3.2:

      Drag Purchase Frequency to Columns. 

       Step 3.3: 

       Bring a distinct count of Customers to the Rows shelf. 

Step 4: 

Change to percent of total,

Finally It Displays % of Customers Over Purchase Duration,desired Solution.

Thanks Guru's,

Prazval.ks