Hi Guys,
I'm working with a dataset that contains the following columns:
Country
Online/Offline
Product
Total purchases
I want to see the top purchased product as a highlight in my viz. The top purchased product sheet will be added to a dashboard and will be filtered by clicking on a separate bar chart, which that shows the total amount of products purchased, split by country and online/offline.
I've tried a couple of things (Index) which doesn't seem to work as it adds a rank without any clear logic. How can I achieve the above?
Cheers,
Alex
Hi Alex,
So you have a bar chart by country and online/ offline and when you click on the country bar you need to see the top purchased product for that country ?
If that's the case, you can use fixed to calculate top purchased product for that country, bring that field and your country on to your sheet. Now, you will have top purchased product for each company in your sheet . Now you can add a dashboard action which filters just the country you selected from the bar chart.
