Conditional Formatting - improve usability

[#1]

Description - Allow options to improve usability of conditional formatting so outliers don't skew the coloring, especially when breaking out by dimensions such as page.

Why is this feature important to you - When all the standard values have the same or very similar shading, conditional formatting loses its power.  Setting up manually means that future adjustments won't update the color scheme.

How would you like the feature to work - I'd like option to be able to use the mean, for example, as the midpoint shade.  Or perhaps quartiles.

Current Behaviour -  Currently the color scheme sets the color midpoint to (max - min) / 2.  In the example below, an outlier page has time spent per visitor with extremely high time.  Thus the midpoint for the color scheme is above way above average and only a few pages would be green or yellow.  This means all pages with even close to normal level of page views, will be varying shades of red.

Instead, if we could use the mean (288 seconds in this example), quartiles, or an option to exclude outliers in setting color scheme, we'd have more insight.

[#2]

Hey @Josh__Stephens could we just keep the one outlier side and calculate the mid point for the rest and proceed, cause if any one function is way more ahead the we would be facing many issues just like in the case of mid point and similarly for others For ex :- average