Visual cue to highlight values compared to average of column

[#1]

Hi all,

Any one have a solution to highlighting values of a given column based on this same column's average? If I would like to highlight all values below average for a column which expression do I have to use?

G.

[kaushiknsolanki]

Hi,

   You can change the background of the cells which satisfy your condition.

    This setting can be done at Properties -> Expression ->Click on + sign ->Click on Background color -> Type your condition at Definition

     Have a look at the attched example.

Regards,

Kaushik Solanki

[#3]

Hi,

I believe I missed something in the explanation of the problem. Please see data below.

Item	Value	Average
1	75	53
1	11
1	41
1	81
1	94
1	77
1	10
1	69
1	38
1	27
1	73
1	51

The average of the column value is 53. I would like to use the visual cue to highlight the numbers below the column average of 53. Note that this value will change with different selections.

Thanks,

G

[#4]

Hi,

This setting can be done at Properties -> Expression ->Click on + sign ->Click on Background color -> Type your condition at Definition

In the same definition you can write

if(Value < Average, red(),black())

Also, your average is coming in only one row? (You may need to write the expression for Average here)

is there any reason for that?

..

Ashutosh

[kaushiknsolanki]

Hi,

   Use this expression

   if(sum(Value) < avg(total Value),Red(),Yellow())

Regards,

Kaushik Solanki