Forum Discussion

ScottAllison's avatar
ScottAllison
Iron Contributor
Oct 05, 2018

Last 3 values for multiple categories

All, I'm trying to get the last three values of a dataset by a particular category, and I am having trouble figuring out the best way to do this.   I have the following columns: TimeGenerated Mo...
Azure Log Analytics
azure monitor
Meir_Mendelovich's avatar
Meir_Mendelovich
Icon for Microsoft rankMicrosoft
Oct 07, 2018

Hi Scott,

 

We have the arg_max() function but it returns only a single raw per each aggregation value.

 

For example:

 

… | summarize arg_max(TimeGenerated, *) by SiteName, MonitorName

 

Hope it helps,

Meir :->

Resources