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:
Hey Chris,
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:
https://docs.sparkflows.io/en/latest/user-guide/data-preparation/others.html?highlight=windows%20ranking#windows-ranking