Report rules
The settings every report on a dashboard is written against, and how a change reaches reports that already have SQL.
Last updated on
Every report on a dashboard is written against the same settings, so the figures agree with each other. They live in the side panel under Report rules, which shows a one-line summary until you open it. They are locked while the SQL is being written, so no report is written against different rules from the rest.
- Agent
- Customer
What the dashboard is for
The dashboard's brief: who reads it and what it should help them do. The planner wrote it from your description; you can sharpen it at any time. A change applies to SQL written from then on.
Filters
Columns every report returns under exactly this name, such as Agent or Customer, so one filter in Halo narrows every widget on the dashboard. Use a plain column name. Remove one with its cross.
Reporting period
What the period means in plain words, for example "when the ticket was opened". With a period set, reports of events (tickets logged, closed, invoiced) follow it, and reports of a state (open tickets, outstanding invoices) count what is in that state today. Leave it empty for a dashboard with no period.
Date column
The Halo column the period filters on. Pick one, or leave none picked and the AI chooses once for the whole dashboard, so every report uses the same date. Click a picked column again to clear it.
Opens on
The report period the dashboard opens on in Halo. It starts at This Month when the dashboard has a reporting period or date column, and at No period otherwise. Changing it never rewrites SQL. The periods, as Halo groups them:
Past
- Yesterday
- Last Week
- Last 2 Weeks
- Last Month
Current
- Today
- This Week
- This Month
Future
- Tomorrow
- Next Week
- Next Month
All Data
- All
Updating reports that already have SQL
Changing the filters, reporting period or date column on a dashboard with SQL offers Update for its existing reports. Each report is checked against the new settings and each change waits in the list of changes to review: open it to see the SQL before and after, then Accept or Reject it, or use Accept all. Nothing is replaced until you accept it.
Extra rules
Rules every report must follow, such as "exclude opportunities". A rule is saved on the dashboard and used for every report written later. On a dashboard with SQL, Apply checks each existing report and leaves its changes to review.
For a one-off change that is not saved, use Improve this dashboard: describe what should change across the reports, such as converting every amount to one currency, and click Check every report.