Charting problem

[simonattardGO]

Hi all,

I have serveral log lines which have the following format:

TIMESTAMP | CLIENT-TYPE | CLIENT-NAME | PROFIT |

CLIENT-TYPE and PROFIT are both extracted fields.

I would like to obtain a plot with the following axes: Y-axis = Average Profit and X-Axis = Client Type, i.e. the search should calculate the average profit for each client-type and then plot the results.

Can this be obtained using 'chart'?

Thanks

[okrabbe_splunk]

Yes, this will be very easy using the chart command.
... | chart avg(profit) by client-type