Challenge:-
What type of customers is most likely to make repeat purchases – small first purchase or large first purchase?.
Solution:-
Create following 3 Calculated Fields:
1.
1.
2.
3.
Build the View:
1. First purchase bins on rows.
2. Multiple purchase? On columns.
3. Count distinct of customer name on columns.
4. Right click count distinct of customer name -> quick table
calculation -> percent of total
a.Make sure the compute using is table across.
Thanks Guru's,
Prazval.ks