Dynamic colour ranges as you drill down and filter
It would be great if there was a switch that allowed the numerical colour ranges to dynamically change as you filter/drill down into the data. Perhaps you could just define 'number of buckets' and then as the data is filtered/drilled down it would automatically create the new colour ranges based on the no. buckets.
E.g. Say you have data that aggregates to 200 for the entire column in a table - where 200 equals the total hours worked by an individual for ALL tasks.
Therefore, presently, the color buckets for this data set may initially be automatically (or manually) set to something like 0-40, 40-80, 80-120, 120-160, 160-200. However, as you start drilling into the data (hours worked individual tasks for example) you'd currently see the data displaying incorrectly - the filter reduces the total hours on a task and therefore the original colour bucket ranges become meaningless (any split of this data would always fall into the same range).
Obviously you can get around this by creating a % or proportional based measure. But it would be great if there was a tick box that would allow automatic colour bucket adjustment.
Sorry if that wasn't clear!