visual cues

[#1]

Hi,

Wondering if its possible, and if so, how to rank results in visual cues.

So we currently have quite a few staright tables that have 31 results (we have 31 neighbourhoods) and was wondeirng if these could be coloured based on position. So for example the first 10 results are green, 11-20 are amber and 21-31 are red. Obviously this has to be done in the script but is this possible?

Any help would be greatly appreciated.

Cheers

Chris

[Siva_Sankar]

If you just want to highlight the fields consistently by value, I think can use something like

=pick(FieldIndex('Item',Item),blue(), green(),yellow(),lightblue(),lightgreen(),lightyellow())

Regards.

siva

[jvishnuram]

Hi Chris,

Is there any intention to use visual cues for your requirement., if not use the text color in expression tab.

[sujeetsingh]

See this sample may it help you

[#5]

Hi,

The value may change depending on field selected but there will always be 31 results (neighbourhood).

sujeetsingh - tried copying expression but didnt seem to work...

Here is the table and data trying to get this to work on. So love the top 10 to be green, 11-20 yellow, 21-31 red.

Neighbourhood	Count(No_Repairs)
	4692
Barton Lane & Trafford   Road	567
Eccles & Weaste	326
Mountskip	314
Armitage	312
Clifton Green	312
Peel	260
New Lane	216
Kenyon	213
Brindley	203
Monton & Ellesmere Park	198
Westwood & Alder Park	196
Swinton South	189
Brookhouse & Newland	164
Manchester Road South	159
Moss Vale	151
Baronfold	112
Peel Green	107
Amblecote	89
Walkden South	80
Astley Area	76
The Glaze	72
Pendlebury	64
Grosvenor	61
The Vista	41
Higher Irlam	38
Wardley	36
Falmouth	35
Agecroft	33
Nelson	32
Moorside	22
Boothstown	14

[Clever_Anjos · Accepted solution]

Use this expression as BackGroundColor

if (rowno() < 11, lightgreen(), if(rowno()<21, yellow(), lightred()))