Hi @PReynoldsBitsIO, if income field has fixed values (how it seems) you could use something like this: <your_search>
| eval
income=case(income="$24,000 and under","1$24,000 and under",
inco...
See more...
Hi @PReynoldsBitsIO, if income field has fixed values (how it seems) you could use something like this: <your_search>
| eval
income=case(income="$24,000 and under","1$24,000 and under",
income="$25,000 - $39,999","2$25,000 - $39,999",
income="$40,000 - $79,999","3$40,000 - $79,999",
income="$80,000 - $119,999","4$80,000 - $119,999",
income="$120,000 - $199,999","5$120,000 - $199,999",
income="$200,000 or more","6$200,000 or more")
| chart count by income
| rename
"1$24,000 and under" AS "$24,000 and under"
"2$25,000 - $39,999" AS "$25,000 - $39,999"
"3$40,000 - $79,999" AS "$40,000 - $79,999"
"4$80,000 - $119,999" AS "$80,000 - $119,999"
"5$120,000 - $199,999" AS "$120,000 - $199,999"
"6$200,000 or more" AS "$200,000 or more" Ciao. Giuseppe