Thank you Anthony for this. I've used this demo to great effect to create workbook views at two different companies. I found converting this to a scatterplot a bit more useful than the bar graph for a quicker vis when displaying a large number of products and to easily Identify positive outliers. The x-axis is the customer count of each product id filtered by the parameter as you expertly demonstrate. The y-axis uses total count of customers who've purchased the product id, set by a calculation that fixes it at the total number and is not filtered by the parameter. Add in a power trend line, and the further to the left, away from the trend line, the higher the correlation. Can easily look through a basket match of 1000s of products in seconds to find the outliers. Also very compact for dashboards.
@@sandrahu7122 Unfortunately, I can't share the dashboard in a public forum. Here is screenshot of the dashboardphotos.google.com/photo/AF1QipMEl63OYi_8kUgwDHyJgM_PBgDvIOIyIGOoOl5G The bottom grid is full of contact data for customers to create call lists based on results.
@@less_likely thank you so much for your quick response. i can't open the google photo. but i read your description repeatedly. Understand that all the rest is the same as the video. but X is COUNTD(CustomerID), and Y is {fixed(subcategory):countd(customerID}. i hope my understanding is correct. i had a screenshot too, but can't post it here.
Hi Anthony, the setting in User Selection Orders, always by itself change to By Formula as SUM ([Matches Selection]) >= 1. After it drag to Filters pane, the chart disappeared. If possible for you, would appreciate if you could enlighten. Thanks
This is what I was looking for. However, can you tell me how to get the top 10 cross selling items as a bar graph. Like accessories and binders together sell the highest as compared to other combinations. Here we are checking manually in your videos. I want to create a sheet which checks all combinations and gives the top 10 results as a bar graph.
Hii I have a question, does the visualization of the market analysis can be on a dashboard? I could do the calculations but when I put it on a dashboard it doesn't seem to work . Help please. Thanks in advance.
