when i saw the result first , it seem ok , the cell that have a high value are red and the lower balue are whitem,
but are wrong.
i have attached the example, in the first row, for example the september 2014 cell have a value of 22, (lower than the others cell of the same row) but the the color is RED .
it seem that with the expresion generated with the wizard the background color is calculated with the value of the complete colum instead of the complete row.
if i pivot the table and put the month in the rows and the id in the columns the colors are calculated right but this visualization is very confused for the user, the user need see id in the rows and the month in the colums.
anybody know how to use colormix to do this, and calculate the brightness of the color depending of the value of the cell in each row??