We’re struggling to figure out a solution to identify when one or more events are low or missing from a table.
Let’s say we want to confirm that these events all have 1,000+ records per day:
We filter eventname for events a through z with an event_count of less than 1000, but our alert will only trigger if there’s 1 to 999 events for a given eventname. If event_a has 0 events, it won’t trigger as an alert.
We can’t think of a dynamic solution short of setting up one alert per eventname, which is costly (bigquery) and inefficient, or one measure per eventname, which is just inefficient. We could create a “count of eventnames” and always confirm the result is the number of events we’re filtering for, but that won’t consider the number of events per eventname.
Any other ideas?