How can I get a top 10 statistic with pivot? Currently I'm doing something like
| pivot MyModel MyObject count(MyObject) AS count SPLITROW myseries | sort 10 - count
I'd like to avoid the sort somehow.
Try this search:
| pivot MyModel MyObject count(MyObject) AS count SPLITROW myseries | sort - count | head 10
I downvoted this post because doesn't answer the question at all.
This is the same as my search does.
I asked if there's a way to get the top10 statistics directly with the pivot command.
@simon what in the world are you trying to get at? Both solution seems to work when handling pivot