Hi Team,
We have a requirement to implement a monitoring mechanism on the incident table to proactively detect potential eBonding issues with our integrated customers.
The goal is to calculate the average frequency of incident record creation per customer and automatically generate a monitoring incident if no records are received from a specific customer (e.g., Customer A) within the last hour. This will help the team identify and investigate possible integration issues.
Some customers have inconsistent incident creation patterns, and we want to avoid triggering alerts during natural dips in activity. I would like guidance on:
- How to calculate the average frequency effectively?
- Where to store the calculated averages?
- How to apply dynamic thresholds based on the data?
Please help me understand the best ways to achieve this.
