Can you please attach workbook or dummy view similar to it?
Here is an mock up with only the relevant fields and some fake data. I tried including some type of calculated field that scores based on a combination of each raw value but I am trying to figure out how to get someone with high percent / high count group to be most red but if someone is in lower percent the color gets "greener" and possibly a yellow coloring in the middle?
Not sure if this makes sense.
Thanks for any help you can provide.
BadSearchvsOPR_Grid.twbx 27.2 KB