| base query with some eval commands
| table a_snake, a_cat, a_dog, b_snake, b_cat, b_dog, c_snake, c_cat, c_dog
However, I want the values to be arranged like this with the column header as SNAKE, CAT, DOG
SNAKE CAT DOG
a_snake a_cat a_dog
b_snake b_cat b_dog
c_snake c_cat c_dog
Using what you provided this is what I have
| makeresults
| eval animal = "a_cat a_snake a_dog b_cat b_snake b_dog c_cat c_snake c_dog"
| makemv animal
| mvexpand animal
| rex field=animal "^(?<Letter>.*?)_(?<Type>.*?)$"
| eval Type = upper(Type)
| chart values(animal) over Letter by Type
| fields - Letter
Using what you provided this is what I have
| makeresults
| eval animal = "a_cat a_snake a_dog b_cat b_snake b_dog c_cat c_snake c_dog"
| makemv animal
| mvexpand animal
| rex field=animal "^(?<Letter>.*?)_(?<Type>.*?)$"
| eval Type = upper(Type)
| chart values(animal) over Letter by Type
| fields - Letter
What do your events actually look like?
And what output does your existing table
command show?
(It might actually be useful to know what those eval commands are, but they may not be important)
The existing output is,
There is One row and Nine columns
And the column headers are left to right specified as a_snake a_cat a_dog b_snake b_cat b_dog .....
are a_snake a_cat, etc field names or values? I feel like you may be generalizing too much and something is getting lost. Your table command treats them like fields but then your example table has them like values.