Return Purchase by Cohort Chart using LOD Functions.

Return Purchase by Cohort Chart using LOD Functions.

Return Purchase by Cohort Chart using LOD Functions.

Explanation

1. We have to find the First purchase made by customer by using the calculation field.

2. Calculation name is : 1st Purchase

Calculation is :

{FIXED [Customer ID] : MIN([Order Date])}

3. And find out the second calculation, before that we have to find out the repeat Purchases,

Calculation name is: Repeat Purchase,

Calculation is: if([Order Date]>[1st Purchase],[Order Date],null)

Name the calculation as : 2nd Purchase,

Calculation is: {FIXED [Customer ID] : MIN([Repeat Purchase])}

4. Now find out Quarters to Repeat Purchase, create a calculation and name it as Quarters to Repeat Purchase,

Calculation is : date diff(‘quarter’,[1st Purchase],[2nd Purchase]).

5. Now drag the Quarters to Repeat Purchase into Columns.

6. Drag 1st Purchase into Rows and select the date part as Quarter Discreet.

7. And select the chart type as Square.

8. Drag customer Id into color shelf at marks card level. And select the Count distinct.

9. The visualization look like below,

Return Purchase by Cohort Chart using LOD Functions.

Leave a Reply

Your email address will not be published. Required fields are marked *