Embiro BI

Documentation › Alerts and reports

Alerts and reports

Email a dashboard or chart on a schedule as a PDF, image or CSV, or get an email alert when a number crosses a threshold.

Reports email a dashboard or chart on a schedule, such as every Monday at 8:00. Alerts run a SQL check on a schedule and email only when the result crosses a threshold, such as "stock below 100" or "no sales recorded today".

Who can do this: Super Admin, Admin and Analysts. It is a plan feature ("Alerts & reports"). Recipients don't need an Embiro BI account to receive the email, but need one to open the links in it.

Schedule a report from a dashboard

  1. Open the dashboard → ⋯ → Email report → Set up an email report.
  2. Fill in:
    • Report name, such as Weekly sales;
    • Description (optional, shown in the email);
    • Schedule: every day, week or month at a time, or a custom schedule. Times are in the time zone you choose: pick Africa/Kampala for East African Time;
    • Content format: Image (PNG) embedded in email, PDF attached, or just a link;
    • the recipients' email addresses, separated by commas.
  3. Click Add.

The email comes from no-reply@embirobi.com with the dashboard (or its PDF), and an Explore in Embiro BI button.

From a chart: ⋯ → Manage email report works the same, and can also send the chart's data as CSV or as a text table.

Manage reports and alerts

Settings → Alerts & Reports lists every report and alert in your organization, with the Last run status. From there you can:

  • switch one off and on with Active;
  • edit it (pencil) or delete it;
  • open its Execution log to see each run, when it was sent and any error.

The Reports tab of Alerts & reports, listing a weekly sales report with its schedule in Africa/Kampala time

Create an alert

  1. Settings → Alerts & Reports → Alerts tab → + Alert.
  2. Alert name, and the Owners who can edit it.
  3. Alert condition:

    • Database: the connection to check;
    • SQL Query: a query that returns one number, for example:

      sql SELECT COUNT(*) FROM orders WHERE order_date = CURRENT_DATE

    • Trigger Alert If...: a comparison such as < 1, > 1000, not null, or == 0. 4. Alert contents: the dashboard or chart to attach when the alert fires, and its format. 5. Schedule: how often to check, for example every hour from 9:00 to 18:00. Working timeout stops a slow query, and Grace period stops repeat emails for a while after an alert has fired. 6. Notification method: Email and the recipients. 7. Click Add.

The Alerts tab listing an alert that checks every afternoon whether any sales were recorded

Alert ideas:

Alert Query Trigger
No sales today by 14:00 SELECT COUNT(*) FROM orders WHERE order_date = CURRENT_DATE < 1
Low stock SELECT MIN(quantity) FROM stock < 100
Big refund SELECT MAX(amount_ugx) FROM refunds WHERE created_at > NOW() - INTERVAL '1 hour' > 5000000
Overdue loans grew SELECT COUNT(*) FROM loans WHERE days_overdue > 30 > 50

Good to know

  • Reports always run fresh queries, ignoring the cache.
  • Report screenshots are taken as the report's owner sees the dashboard, with its default filters.
  • Google Sheets dashboards work in reports, as long as the connection has been authorized.
  • If an email doesn't arrive, check spam first, then the report's Execution log.

Something unclear or missing? Tell us and we'll improve this page.