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
You can do a summary report type summarized by Type. You can sort it by highest number of hits for that type.
As for an Notification, after 10 to that you will need to create a self maintaining table of Types where the Key field is Types.
Start off by copying that summary report to this new table. That will initialize the table and then you will be able to create a summary of the number of Alerts for each type.
You can then have a Subscription report of Types with > 10 Alerts. I imagine you will need to app,l some kind of time frame limitation on those summary counts. Note that this will be a Subscription report and not a Notification.
As for self maintaining the table, create a field on the Types table called [Type exists?] as a formula checkbox and with a formula of
True
Then look that up down to Alerts.
Then fire an Automation to create the missing Type when an Alert is created but the is no Type in the Master Type Table.
As for an Notification, after 10 to that you will need to create a self maintaining table of Types where the Key field is Types.
Start off by copying that summary report to this new table. That will initialize the table and then you will be able to create a summary of the number of Alerts for each type.
You can then have a Subscription report of Types with > 10 Alerts. I imagine you will need to app,l some kind of time frame limitation on those summary counts. Note that this will be a Subscription report and not a Notification.
As for self maintaining the table, create a field on the Types table called [Type exists?] as a formula checkbox and with a formula of
True
Then look that up down to Alerts.
Then fire an Automation to create the missing Type when an Alert is created but the is no Type in the Master Type Table.