Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Apex Maps: How to set a color scheme based on threshholds?

satishpMay 1 2022

On 21.2.5.. i'm using a Map region with a "polygon" layer that shows US state polygons.
The query behind the layer retrieves a percentage value.
I want to color code the percentage value... high percentage is redder.. lower percentage is greener.
Trouble is.. the values aren't very sequential / divergent. For example, they will all start with 100% and slowly reduce towards 0%.
Because there isn't a huge variance in the range, everything is color coded the same way, which is unfortunately green..
As soon as i fake the data to make one state be a very low percentage, then that one is green, and everything else at super high percentages is red.
How do i define a color coding threshhold? greater than 90% = red. Less than 10% = green. Instead of the relative variance being used right now?

This post has been answered by Carsten Czarski-Oracle on May 3 2022
Jump to Answer
Comments
Post Details
Added on May 1 2022
15 comments
1,284 views