Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
How to accumulate numbers from largest to smallest
Added on January 6, 2025 5:57AM
Likes: 0
Replies: 2
Junichi
Registered Posts: 18 ✭✭✭
As sample data shows, the data has customer ID column and revenue by customer column, and I would like to accumulate the revenue from largest revenue to smallest revenue to identify which customers are in top80% market and which customers are in bottom 20%. How can I calculate like orange-colored column in DSS?
Answers
-
In addition, I cannot use physon, so I would like to know how to do it with reciepe function.
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,253 DataikerHi @Junichi ,
You should be able to use a Window recipe to accumulate and sort the revenue:
https://knowledge.dataiku.com/latest/data-preparation/visual-recipes/concept-window-recipe.html
Then you would have the sum and rank and based on the rank you can determine your top %
