I am trying to add a heatmap to my grid. In my DB I created a view that has a calculated column that is the percentage of the value column as compared to the rest of the rows… example:
name: player1, score: 300, score_heatmap: .20
name: player2, score: 200, score_heatmap: .13
name: player3, score: 500, score_heatmap: .33
name: player4, score: 500, score_heatmap: .33
so my grid is rows of name and columns of score and I want to format my score column as:
score_heatmap < .10 then red else
score_heatmap < .20 then yellow else
score_heatmap < .30 then green else
score_heatmap = blue
but I cannot figure out how I know the value in a column (I was adding score_heatmap as a hidden column to my grid to make it part of my row) when in the cellsrenderer function.
thanks