Reports answer questions like “How many deals did we close this quarter?” or “Who has the most open tickets?” without scrolling through lists.
Opening Reports
Click the Reports icon in the top bar. Reports are organised in folders, and Favourites and Recently run keep the ones you use close at hand.
Ways to look at a report
Every report can be shown three ways, using the switch above the results:
| View | Best for |
|---|---|
| Table | A list of records, like a spreadsheet, with groups you can expand and collapse and totals. |
| Summary | Counts and totals per group — for example deals by stage. |
| Pivot | Two dimensions at once — for example stage by salesperson. |
A chart sits under the results and follows the view you choose. Click a bar or slice to see the records behind it.
Running a report
- 1Find the report in its folder, or search for it.
- 2Click its name: the results appear straight away.
- 3Use the search box and the column headers to narrow and sort the results. To limit the dates, add a condition on the Filters tab.
- 4Export what you see with the Excel, CSV or PDF buttons.
Creating a report
- 1Click New report.
- 2Give it a name, choose a folder and the module it is about (for example Opportunities), then click Next.
- 3Build it in the report editor’s tabs — the preview updates as you go:
- Filters — which records, e.g. stage is Closed Won and close date is this quarter
- Columns — which fields to show
- Calculations — sums, averages, lowest and highest
- Group & sort — group by up to three fields
- Sharing & schedule — who can see it, and emailing it on a schedule
- 4Click Save & Generate Report (on a report you are changing, Save report).
Useful reports for each role
Reports worth building for each role:
| Role | Report | Why |
|---|---|---|
| Sales | My open opportunities | Your active deals — review weekly. |
| Sales | My activities this week | Calls and meetings you logged. |
| Sales manager | Pipeline by stage | All deals grouped by stage. |
| Sales manager | Revenue by salesperson | Deals won this quarter, by person. |
| Support | My open tickets | Everything assigned to you. |
| Support | Tickets by priority | What is urgent. |
| Marketing | Leads by source | Which channels bring the most leads. |
| Management | Revenue by month | Revenue closed each month. |
| Management | Lead conversion | How many leads become opportunities. |
Adding a report to your dashboard
Open the report and click Add to dashboard on its chart. The chart appears as a widget on your dashboard.
Tip:The most useful reports are the ones you check every week. Pick three to five that answer your key questions and put them on your dashboard.
Still stuck? Ask your administrator, or email support@omnir.com. All guides