I'm working on a column chart visualization that show income ranges: "$24,999 and under" "$25,000 - $99,999" "$100,000 and up" The problem is that when the column chart orders them, it puts ...
See more...
I'm working on a column chart visualization that show income ranges: "$24,999 and under" "$25,000 - $99,999" "$100,000 and up" The problem is that when the column chart orders them, it puts "$100,000 and up" first instead of last. I've created an eval that assigns a sort_order value based on the field value that orders them correctly. However, I can't figure out how to get the column chart to sort according to that field. This is what I'm currently trying: | eval sort_order=case(income=="$24,000 and under",1,income=="$25,000 - $39,999",2,income=="$40,000 - $79,999",3,income=="$80,000 - $119,999",4,income=="$120,000 - $199,999",5,income=="$200,000 or more",6)
| sort sort_order
| chart count by income Here's the visualization: Is there some other way to accomplish this?