Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My requirement is to fade the color of Bars in a Bar-Chart gradually. Each bar represent a represent revenue by country. We have only 10 bars (as we select only top 10 countries by revenue, so I used RANK).
I am using the expression in "Background-Color" of the chart as:
if(aggr(rank(sum({<[Country Name]-={"Wor*","OECD*","South*","High*","*Sahara*","Low*","Latin*","Heavily*","Least*","Fragile*","European*","East *","Euro*","Arab*", "*iddle*","North A*"
}>}Population)),[Country Name])<=1,RGB(33,52,73))
In the above expression we are excluding certain countries.
I have to write this expression again and again in "if-else" format means if Rank<2 then "Color Code-2"...if Rank ❤️ then "Color-Code-3",
So is there a way where I can use the entire RANK operation inside a variable and use that variable instead?
Hi,
like
Pick(YourExpression,RGB(assign_rgb_value_for_1_rank),RGB(assign_rgb_value_for_2_rank),RGB(assign_rgb_value_for_3_rank), and so on)
Regards
Hi,
try with pick()
See in help menu for detail.
Regards
Hi,
like
Pick(YourExpression,RGB(assign_rgb_value_for_1_rank),RGB(assign_rgb_value_for_2_rank),RGB(assign_rgb_value_for_3_rank), and so on)
Regards
That worked like a charm!!! Thank you so much!