So I have this point layer that has 2 columns that I need styled, one of which is owner_id and the other is size. Both are integer fields if it matters. The owner_id matches with an owner name in another table
The intended outcome is to have all 300 owners with names(instead of ids) to be listed by color, and for each owner a range of sizes to be styled by dot size. Essentially it would look like
**owner1name** green
size <5 green small
size 5-25 green medium
size >25 green big
**owner2name** blue
size <5 blue small
size 5-25 blue medium
size >25 blue big
Now I can do categorized style on the owner, switch to rule based and then add ranges but there are 2 problems with this approach
1 - Resulting ranges all take the same color instead of random ones
2 - If people toggle an owner on but untoggle one of the sizes, using the selection tool will also pick the untoggled combination
3 - Owners are listed by id, not name
What is the best way of tackling this?