Hi I have Grid chart as shown below where the average temperature of a process is being recorded for every layer (1 to 6) and every 10m (0 to 130m). To achieve this the average value (Avg($(vFieldChart1Ring1)) is calculated by Layer (Y) and distance (X) , in this case the distance is every 10m, but I also group the data into 250mm, 500mm & 1m.
What I would like to do is show the total percentages as highlighted in Yellow above both both Layers and distance.
To achieve the Red and Green Colours I have an expression under the background colours where the average value is compared to variables representing upper and lower limits.
vGridR1LCL = Lower Limit
vGridR1UCL = Upper Limit
=if(avg($(vFieldChart1Ring1))>= vGridR1LCL, if(avg($(vFieldChart1Ring1))<= vGridR1UCL, RGB(128,255,0),RGB(255,0,0)),RGB(255,0,0)) // Green Red, Red
I Have then used the same expression on a Straight Table but replaced the Green with 1 and the Red with 0 to display 100% or 0% against every dot.