Fixed
Percentage thresholds on No-Code and Custom SQL condition monitors
about 4 hours ago by Pierre Courgeon
No-Code condition monitors and Custom SQL condition monitors can now evaluate their threshold as a percentage of rows, not only as a number of rows.
This makes thresholds independent of table size. For example, alert when more than 5% of rows have status = 'inactive', whether the table holds a thousand rows or a hundred million.
Two value modes are available:
- Percentage: the monitor compares the share of rows matching your condition to the threshold. The threshold must be between 0% and 100%.
- Count: the monitor compares the number of rows matching your condition to the threshold. This is the default, so existing count monitors don't change.
If you already selected Percentage on one of these monitors, it applies starting with the next run. Past results aren't recomputed.