I am looking for some help on how to build a dash board that can give our development team some metrics about their in production bots.
We currently have a table that holds all data about how many tickets are in the queue for each bot and what we essentially want to do is to set alerts based on the percentage difference between each instance of ticket count for each both
(for example if the queue has raised over the last 3 hours than something must be wrong because it indicates the bot is down).
Our table is in MS sql and I’ve been fighting grafana, time series, and various queries for the last week or so. I’d appreciate any help or any ideas you guys have.