I have a field in my data named severity that can be one of five values: 1, 2, 3, 4, and 5. I want to chart on the following: 1-3, 4, and 5. Anything with a severity value of 3 or lower can be lump...
See more...
I have a field in my data named severity that can be one of five values: 1, 2, 3, 4, and 5. I want to chart on the following: 1-3, 4, and 5. Anything with a severity value of 3 or lower can be lumped together, but severity 4 and 5 need to be charted separately. The coalesce command is close but in my case the key is the same, it's the value that changes. None of the mv commands look like they do quite what I need, nor does nomv. The workaround I've considered doing is an eval command with an if statement to say if the severity is 1, 2, or 3, set a new field value to 3, then chart off of this new field. It feels janky, but I think it would give me what I want. Is it possible to do what I want in a more elegant manner?