The fields I am interested in are: action (100+ values), customer (6 values), timeTaken (~continuous)
I would like to plot a bunch of graphs, but only from entries of the 10 most common actions across all customers.
For example, a column chart with each of these 10 actions along the x-axis, the 95th percentile of timeTaken on y, with stacking columns for each customer. So far I have tried:
top 10 action | chart perc95(timeTaken) by action, customer
This returns no results found, so I tried to create my own top 10 using sort and head:
stats count by action | sort -count | head 10 | chart perc96(timeTaken) by action,customer
I get what I expect after head 10, but then cannot plot the graph I need after that - it returns no results found.
Help would be very much appreciated! Thank you.
... View more