In Sparkflows, we can use the ‘Windows Ranking’ processor to rank stores based on their sales value within a location. Dataset can be partitioned by location and sorted by sales values. Using this configuration we can get a ranking of stores within a location based on sales value.
To use the ‘Windows Ranking’ Processor:
-
Select a set of columns to partition the dataset in the ‘Partition By’ field.
-
Select a set of columns to Order dataset in the ‘Order By’ field.
-
Select ‘Windows Function’ to be used to perform analysis. We can select ‘Ranking’ for this scenario. Output dataset would contain a new column listing ranking information.
For more information read the Sparkflows Documentation here: