🛠️ Exception list queries

💡 Use Case

Six saved queries, each with a comment at the top saying what question it answers, written for 📌 Measure how long Kestrel's exception list really is: open exceptions per dispatcher at 09:00, the same by type, age of the oldest, how many are closed untouched, the list by weekday, and one that shows me Tuesday. They produced the number that framed 📂 Exceptions Inbox general availability: a median of 214.

⚖️ Pros & Cons

Pros

• I stopped asking for every number. This is most of what ♦️ SQL for product questions means in practice.

Cons

• the first versions were written the way I think, in one long line. They were rewritten in February to follow SQL style notes for saved queries.

🔄 Alternatives

• The analytics dashboard, which shows the average and hides the dispatcher with 600.