How to give Green, Orange and Red colors to the bobbles in Map Chart based on Percentages

[sarsukanth]

Hi All,

I got a requirement to give below colors to bobbles of US Map in Map chart based on below slabs, please someone give better solution for the same.

Please refer the below Map Chart for better understanding

Green     - 70% of total 50 states - Bottom 35 States (Least percentages like 1%, 2%)

Orange  - 20% of total 50 states - 36 to 45 States (Middle percentages like 10%, 11%)

Red         - 10% of total 50 states Top 5 States (High percentages like 70%, 95%)

in the below Map chart I have used "=Count(distinct [ITEM_ID])/Sum([KPI_VALUE])" formula in the Color property of Pointer layer and in the table STATE, COUNTRY columns also available

Please let me know if any confusion or any questions. Thank you.

[lironbaram · Accepted solution]

can you share a sample app or a sample data file with state and percentage.
In theory this should work for you 
IF(rank(Count(distinct [ITEM_ID])/Sum([KPI_VALUE])<=50*0.1,red(),

  if (rank(Count(distinct [ITEM_ID])/Sum([KPI_VALUE])>50*0.3,green(),orange()))

[sarsukanth]

Hi Lironbaram,

Thank you very much, it is working excellently👍.

You are always great.

Thank you again.