Create scoring (1 to 10) based on value for different cities

[sophievanluin]

Hi,

I'd like to add a calculation to a workflow that scores cities based on their population distribution. I want to assign a score from 1 to 10 to each city, where 1 is the lowest population group and 10 is the highest. The groups should have an equal percentage of the total population, so I'd like to see roughly the same number of 10's as 7's or 6's or 5's, etc.

Additionally, I need a sustainable solution, as the population values are updated from time to time. Can anyone help me with this?

dummy data 

ID	City	Population
1	Amsterdam	728180
2	Amsterdam	803415
3	Amsterdam	961880
4	Amsterdam	578640
5	Amsterdam	587370
6	Amsterdam	980870
7	Amsterdam	1059035
8	Amsterdam	737195
9	Amsterdam	980345
10	Amsterdam	657840
11	Amsterdam	478930
12	Amsterdam	885250
13	Amsterdam	536740
14	Amsterdam	659525
15	Amsterdam	783575
16	Utrecht	394445
17	Utrecht	344610
18	Utrecht	244475
19	Utrecht	1045450
20	Utrecht	510315
21	Utrecht	254300
22	Utrecht	486205
23	Utrecht	411660
24	Utrecht	859500
25	Utrecht	278280
26	Utrecht	568305
27	Utrecht	679285
28	Utrecht	341095
29	Utrecht	334145
30	Utrecht	821690
31	Utrecht	441785
32	Utrecht	716990
33	Utrecht	272255
34	Utrecht	317990
35	Utrecht	254025

[alexnajm]

Sounds like the Tile tool with the Equal Sum option! You can even group by the city if you need scoring for Amsterdam vs Utrecht - see attched

otherwise we may need more clarity on your expected output

[Raj]

@sophievanluin find the workflow attached

mark done if solved.