How to calculate total of a grouped field
I have a table called Alerts. Each Alert has a 'type'. I'd like to calculate the # of Alerts by Type and when the # of any one alert type is greater than 10 trigger a notification. As a first s...
Forum Discussion
I should add that there is an indefinite number of possible 'types'...so I can't just create a summary to total for each 'type'. The type values are dynamic for each Alert (e.g I don't know the 'type' until the alert record is created)