Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to put colors in place of the values in the crosstab but some how its not working for me
Very High red
High orange
Moderate yellow
Low green
N/A grey
My current expression is
= if (isnull(sum(rank)/(count(DISTINCT(UniqueID)))),'N\A',
if(sum(rank)/(count(DISTINCT(UniqueID)))<3.00,'Low',
if(sum(rank)/(count(DISTINCT(UniqueID)))<6.00,'Moderate',
if(sum(rank)/(count(DISTINCT(UniqueID)))<12.00,'High',
if(sum(rank)/(count(DISTINCT(UniqueID)))<16.00,'Very High')))))
And my script is
Test:
LOAD * INLINE [
Region, Country, Organization, rank, owner
1, A, East, 2, peter
2, B, West, 4, Sam
3, C, NorthEast, 8, Alex
4, D, WestCost, 12, Wallen
5, E, North, 8, Dona
6, F, South, 2, Ben
7, G, SouthWest, 2, Tina
8, H, South, 4, Ben
9, I, West, 8, Sid
10, J, WestCost, 8, Wallen
];
Test2:
NoConcatenate
load * ,
Region&'-'&Country as UniqueID
Resident Test;
drop Table Test;
see attached
see attached
Thanks,
It worked perfectly for my application.
Regards
Saurabh