Extract Data for Highest Sale Country
Extract data from the country with the highest number of sold items. It is easy to find the country with the highest number of sold items with: - a GroupBy node to calculate the number of sold items as sum(Quantity) by country; - then a Sorter node to sort the countries by decreasing number of sold items; - and finally a Row Filter node to extract only the first row (country) from the sorted list. Such country name now needs to be converted into the Value of a Flow Variable to overwrite the setting in the Row Filter node that extracts the data fro a given country.