I have a question regarding a query using an If() statement.
Query:
fetch logs, scanLimitGBytes: -1
| filter matchesPhrase(content,“*******”) OR matchesPhrase(content,“******”)
| filter matchesPhrase(content,“*ACCESS”)
| parse content, “************-'”
| filter channel != “null”
| summarize count=count(),by:{channel}
Result is screenshot. My question is, my customer wants to add another field such as “isLive” that has the value TRUE, if and only if the count() value is the greatest amount all records. In the example shown, a value of true would appear next to the blue channel because the count() is the maximum among both records. I’ve been trying this with an if() statement with no results because they cannot contain aggregations. Any ideas of how to accomplish this? Thank you!
