I have an analysis that in the columns has a date hierarchy (Year,month,day) and in the rows has a couple of other hierarchies (Devicetype, device) and then (Metricname and Instance), see the first image for a better idea of how my data is structured.
I also have a threshold value that I need to compare the analysis values against, in the first image it is the last column in the row headers (blank),(blank),(blank),10,1024 etc. I have created a new attribute that returns either 1 or 0 depending upon whether the analysisvalue is above or below the threshold and I’m using this to colour my values. So far so good, see the second image.
My problem comes when I roll up one of the hierarchies, see the third image. where the underlying data have values both above and below the threshold the analysis shows both values in the cell. I want the colour to be applied to the summarised value not to the underlying values.
I think this is a bug, or I’m missing some other step, can you provide some assistance please.