Hi,
I am attempting to create a simple column chart using JSON data from a single event.
The Rows{}.S03PERFC value represents a percent number... I have attempted to convert this but still can't seem to get it to display as a chart.
For some reason the fields are greyed out at the bottom.
Anything obvious I'm missing here?
The clue is in the title - you only have one event. You should try expanding the Rows{} collection before extracting the fields within it
| spath output=Rows path=Rows{}
| mvexpand Rows
| spath input=Rows
The clue is in the title - you only have one event. You should try expanding the Rows{} collection before extracting the fields within it
| spath output=Rows path=Rows{}
| mvexpand Rows
| spath input=Rows
Thanks @ITWhisperer - that did the trick perfectly!