Forum Discussion
Limit series in Log Analytics histogram
If this is the thing you wanted to achieve:
I would have pointed you earlier but I didn't understand exactly the request I guess. Reply yes if the logic in that blog post matches what you've wanted to achieve. That way I can mark this reply as answer for future people to see it.
What about using the distinct operator to filter prior to showing the 'top 5 by Value', or 'top 5 by Computer'
https://docs.loganalytics.io/docs/Language-Reference/Tabular-operators/distinct-operator
Thanks for your response Orion.
I couldn't get distinct to work because it didn't have the effect of filtering that I wanted. I did get one solution to work. I basically performed an initial search to find the top 5 machines by average value, then inner joined that with the time-series search I originally used. That way, only the time series for the top 5 machines (based on their overall average) were shown.