Dynamically Changing Color Scheme Using a Property Control

Hello,

I would like to map two Property Controls to my color scheme. Currently, I have values in columns colored by their percentiles within their specific rows as can be seen in the screenshot below. If a row's amount is above the 95th percentile for its row, then it's cell is colored dark green. If a row's amount is between the 75th percentile and the 95th percentile for its row, then it's cell is colored light green to green. If a row's amount is between the 25th percentile and the 75th percentile for its row, then it's cell is colored white. If a row's amount is between the 5th percentile and the 25th percentile for its row, then it's cell is colored light red to red. If a row's amount is below the 5th percentile for its row, then it's cell is colored dark red.

Instead of having these static values, I want to have the top and bottom percentiles dynamically changeable with my property controls. For example if I typed "99" in the Input Field below "Upper Percentile," then if a row's amount is now above the 99th percentile for its row, then it's cell is colored dark green. Additionally if a row's amount is between the 75th percentile and the 95th percentile for its row, then it's cell is colored light green to green. I would want the same logic for the lower percentile as well.  If I typed "1" in the Input Field below "Lower Percentile," then if a row's amount is now below the 1st percentile for its row, then it's cell is colored dark red. Additionally if a row's amount is between the 25th percentile and the 1st percentile for its row, then it's cell is colored light red to red.

Clyde

(1) Answer

Login