Trouble creating column chart based off 1 event

[sam_]

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?

[ITWhisperer · Accepted solution]

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

[sam_]

Thanks @ITWhisperer  - that did the trick perfectly!