Y-Axis Based on Field Values

[PaintItParker]

I have a field, SecondsSpentExecuting. A logged event will have that field. I want to visualize my data with a line chart, so the x-axis is _time, and the y-axis is SecondsSpentExecuting, so for a given event, at a given time on the x-axis, you see on the y-axis visually how long it took compared to other events in that line chart.

The current command I am using is:

timechart count by SecondsSpentExecuting

But in this case, the y-axis is the quantity of events that spent x seconds executing, so it does not work for my purposes.

How could I write a command which considers the actual value of the SecondsSpentExecuting field rather than charting by quantity of events?

[ITWhisperer · Accepted solution]

| gentimes start=-1 increment=10m 
| eval SecondsSpentExecuting=random() % 50
| rename starttime as _time 
| fields - endhuman endtime starthuman


| table _time SecondsSpentExecuting