I am trying to create a formula for a SVG map. I have a list of three companies I am comparing. I need to have the map color the different states (USA) depending on which company has the most sales in that state.
Company A =Blue
Company B = Green
Company C = Orange
So if Company A has the highest sales in Georgia, then the entire state of Georgia will be Blue.
I have the basis for the equation, I just need the piece that defines the max for each state.
Example of formula
If( *code to find Max Company by sales* = CompanyA, RBG(Blue)
If(*code to find Max Company by sales* = CompanyB, RBG(Green)
If( *code to find Max Company by sales* = CompanyC, RBG(Orange) ))
Any ideas or suggestions would be greatly appreciated! Thanks!
I thought it was working, but now the entire map is black? I don't have the disabled or the Base color as black so this has to be something the color expression is doing? I'm wondering if it is trying to color each state as each of the 3 three colors at the same time and it's turning them black? I've never had this error before?