Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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()))
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()))
Hi Lironbaram,
Thank you very much, it is working excellently👍.
You are always great.
Thank you again.