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;
