HACKER Q&A
📣 terry_y_comb

Existing metrics trend alert solution?


I have been using excel + data from sql queries to spot upward or downward trends on business metrics (e.g. daily, week over week, month of month, actives, revenue, etc...) everyday.

It comes to a point that it's prone error, missed oversight, or not catching it fast enough.

While IT & Reporting team may eventually have an trend spotting / alert solution, I wonder whether there are quick and dirty solution with existing frameworks, R packages, or some form of automation that I can install on my mac that would raise alerts on metrics that are in trouble based on rules that I set.

Of course, any cs101 student can create such program. But I wonder whether such a solution already exists that one can run quickly on their own machine before running it on a broader IT infrastructure.

Any comment will be appreciated!

  👤 johnny35 Accepted Answer ✓
You can set conditional alerts on any query result with Redash. It’s easy to stand up and gives you decent very lightweight SQL-backed dashboards.

Superset can do it too but it’s a little more involved than Redash (but not much).