Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
Hi,
Use this expression
if(sum(Value) < avg(total Value),Red(),Yellow())
Regards,
Kaushik Solanki