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.