One advanced Alert option is to to trigger Alerts in response to Aggregation Queries.
An Aggregation Query is one which evaluates an Expression based on a given set of data (as opposed to a normal Expression which works on a single row).
The Aggregation Query can additionally have a WHERE clause which will limit the number of rows which are aggregated.
Currently the only function available in the parser for Aggregation Queries is SUM (which sums) the value in the given column, but more will be added in the future.
In this demo we have provided the Aggregation Expression:
SUM([ItemCount]) > '2K' WHERE [Employee]='Margaret Peacock'
Try it yourself: Click the 'Increment' button which updates 'Item Count' value by 150; once all the rows that match the 'WHERE' clause exceeds 2000, the Alert is triggered.