I can answer part of your question, because I just solved it for a different context. Let's say "count" is the variable you're mapping. You can use the case command (through eval) to group your "count" into categories and give them any names you want.
Example:
| eval count=case(count<3, "Red: 1 to 2", (count<=3 AND count<5), "Yellow: 3 to 4", count>=5, "Green: 5 to 6")
I recognize you originally said you wanted "1-2", "2-4" and "4-5" as your ranges, but I would suggest not having the same number be the top of one range and the bottom of the next.
... View more