Hi everyone!
“New-Looker” here.
I have the following data: Month, Country, Amount of sales (generated per month)
I want a view that will have x = Date, Y = Amount of Sales, and I want to plot lines that represent the different countries.
As you can imagine, not all countries are important. Hence, I want to filter for the top 10 countries that sold the most and I want to do it dynamically.
I built the view using the Pivot option on date. but for the life of me, I cannot make a dynamic top selection!!!
I can filter out certain values, but I dont seem to pick the countries with the most sales.
My question is: How can I filter a view to return only the top 10 countries with most sales?
I hope I was clear!
Best regards