How much revenue contributed annually by each customer cohort?

revenue contributed annually by each customer cohort

How much revenue contributed annually by each customer cohort?
Ans:
1. Drag Order Date into Columns.
2. Drag sales into rows.
3. Create a calculation for the Customer First Purchase Date as shown below.
{FIXED [Customer Name] : [Order Date]}
4. Now drag that Customer First Purchase Date calculation into color then it will give the following visualization.
customer first purchase
5. Now duplicate the above sheet.
6. Right click on the sales at row level and select Add Table Calculation option, in that select Percent of total and Compute Using Table (Down). As shown below.

table calculation

7. Then it is showing the Percent of total .as shown below.

percent of total

8. Now create the Dashboard for showing the two sheets side by side.
9. The dashboard looks like below.
revenue contributed annually by each customer cohort

Leave a Reply

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