I know how to do this in Excel with pivots but not in Tableau - any help appreciated.
I have detailed log data that logs unqiue consumers' visits to different destinations. What I want to do is show is how many customers have visited different locations. here's what my data looks like:
|Unique user ID||visit time||Store visited|
|Unique I||1-Sep||Store A|
|Unique 2||1-Apr||Store A|
|Unique 3||1-Jul||Store B|
|Unique 4||13-Apr||Store D|
|Unique 3||14-May||Store B|
|Unique I||1-May||Store C|
|Unique 2||2-Jun||Store A|
In Tableau easy to view it like so (where the cells are the number of visits from a unique customer):
|Unique user ID||Store A||Store B||Store C||Store D||Store E||etc|
But what I want is to aggregate it like so:
|Unique stores visited||Uniques||Frequency|
|3||1||14%||of all customers visited 3 different stores|
|2||2||25%||of all customers visited 2 different stores|
|1||5||63%||of all customers visited only 1 store|
How would you create this calculation?
Thanks again for any help.
Could you post some mocked up or sample data?