Adjusting the x-axis on chart count

[dannyzen]

I'm using | chart count over severity by technique to display events by level of severity
Currently I am not getting severity in order from Highest to Lowest on the x-axis where the order is off in the column chart visualization
I've also tried
| stats count by severity technique

What would be an effective way to have these order correctly?
Thanks in advance!

[woodcock · Accepted solution]

Like this:

index=_* sourcetype!=audittrail
| stats count BY log_level
| eval _log_level = case(
   log_level=="INFO", 0,
   log_level=="WARN", 1,
   log_level=="ERROR", 2,
   log_level=="MAJOR", 3,
   log_level=="MINOR", 4,
   log_level=="CRITICAL", 5)
| sort 0 _log_level

[dannyzen]

Thank you! this is great