Hello!
I am quite new to Tableau and trying to calculate the difference in customer activity per week/month from 1st week/month of purchase made. Please find the files attached.
As shown in the worksheet, I would like to show the % of Customers for each week in comparison to the 1st week for each row.
Customer Activity should be displayed as follows
Purchase DateFirst Purchase DateWeek 28Week 29Week 30Week 31Week 32Week 33Week 28100%10%6%4%4%1%Week 29 100%10%5%5%1%Week 30 100%11%7%2%Week 31 100%12%2%Week 32 100%2%Week 33 100%
All assistance will be highly appreciated.
Thanks!!
Justus
Hi Justus,
Welcome to the Tableau Community forums. Table calculation is what you are going to need. Click on the little arrow on the pill on the marks card and do the following:
Click on the little arrow again and make sure table (across) is selected in the compute using menu. If you drag the calculation from the marks card to the measures pane on the bottom left, you can save this calculation and change the default formatting to display 0 decimals in the percentage.
Attached Version 9.0 WB.
Thanks,
Pooja.
