Could you share a sample of your data? It's difficult to make a prognosis without seeing the patient
If you're looking for row-level data, I'm thinking one or two LOD calculations are needed.
When it comes to outliers that throw everything off, normalizing those excessive values is needed. You can do this quite a few ways:
- You can format the color, adding an End Value. Your huge values won't stretch the continuous color range.
- You can modify the color value by taking the log, or the square root, etc. While this may not work seamlessly with negative numbers and 0, it will keep your highlight color as a function of the difference.
- You can manually evaluate the color value and reset any above a certain point.
- You can manually evaluate the color value and place them into discrete categories. This method works okay if you have just a handful of "steps" you want to show.
Hope there may be a glimmer of an idea in there for you! Good luck! --Michael