Forum Discussion
Unique count data based on values with pre-filtering
My raw data table contains customer data including: Customer ID, Countries, Date, Categories, Sales, etc.
Examples:
#123, US, Jan, Apple, $100
#123, UK, Jan, Orange, $200
#234, US, Feb, Apple, $100
#345, UK, Feb, Grape, $300
Is there any chance in one table, displaying the categories in the rows:
Calculating the percentage of customers (unique count) who buy any other Fruits from the group of customers (unique count) who buy Apple?
And then the same go for Orange, Grape, etc. on the same table.
I would like the table to be able to work with the slicer filter on the page so that I can filter things like Country, Date, etc.
Thank you very much for the help!
Hi m156
Ii sounds like basket analysis please refer to the linked tutorials:https://www.youtube.com/watch?v=3OlZuXH9Y_g
https://www.youtube.com/watch?v=Wc08K6IWgIM
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
2 Replies
Hi m156
Ii sounds like basket analysis please refer to the linked tutorials:https://www.youtube.com/watch?v=3OlZuXH9Y_g
https://www.youtube.com/watch?v=Wc08K6IWgIM
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Before analyzing data, it's crucial to ensure accuracy by pre-filtering and removing duplicates. Unique count data based on values offers insights into distinct occurrences, aiding decision-making processes. verizon business internet Through systematic pre-filtering, redundant entries are eliminated, enabling precise data analysis. This approach enhances data quality and integrity, facilitating more informed conclusions and strategic actions.
