I am very new to Splunk and trying to learn manipulation like I would in Excel. My current task is to get an average of a result, and then display it by a device type. Let's assume the CSV looks like this:
I want to get the average of the Ratios, by Device Type. And then Chart them side by side.
your search |stats avg(RATIO) by DEVICE
your search |eventstats avg(RATIO) by DEVICE
If you want to repeat the values in each row
@jasoholt, please accept as 'answer' if it resolves your issue so that the thread will be closed