Octibiz
Demo

Durchsucht Website und Dokumentation gemeinsam. Enter zeigt alle Treffer, Esc schließt.

Reports & dashboards

Reports & dashboards screen in Octibiz

Overview

This area answers questions about your own data. Four building blocks work together:

  • Reports are saved questions — metric, period, filters, grouping.
  • Dashboards place several reports side by side.
  • Targets put a target value next to the metric, so you see deviation rather than only level.
  • Time series record metric values per reporting date — the basis for trends.

Metrics come from the modules themselves; what is not installed delivers no metric.

Core tasks

Build a report. You choose the metric, set period and filters and group. The result can be saved and shared.

Assemble a dashboard. Tiles are arranged; a dashboard can be personal or shared for a role.

Set targets. A target applies to a period and is shown next to the actual value.

Schedule reports. A schedule sends a report regularly — to people or roles.

Fields in detail

The area has four masks: report, dashboard (with its widget dialog), schedule and KPI target. Each writes to a resource of its own.

Report

Creation asks for name, dataset, description and scope; everything else lives in the configuration on the report detail page.

FieldRequiredValues / formatWhat it does
Name nameyestext, max. 200 charactersWhat the report is called in the list, in schedules and in exports.
Dataset datasetno (defaults to custom)key from the dataset catalogue, max. 60 charactersThe source area of the report — finance, time & utilisation, sales. It determines which metrics are available at all.
Description descriptionnotext, max. 1000 charactersWhat the report is for.
Measures measuresyeslist of metric keysWhat is calculated — the columns of the report. Without at least one metric the report cannot be saved.
Dimension chain dimensionsnolist of dimension keysHow the result is split. The first dimension is the row axis, every further one a drill-down step. Empty means a single total row.
Filters filtersnokey/value pairsWhat is included. The report mask does not maintain them itself — they come from a template or are set through the interface and automation.
Sort field sortFieldnofield name, max. 60 charactersWhat the result is sorted by; empty = default order.
Sort direction sortDirnodesc or ascIn which direction.
Period dateRangenothis_month, last_month, this_quarter, this_year, ytd, last_12_months, customWhich period is reported on. Everything except custom is rolling and keeps the saved report current without anyone updating it.
From customFromnodateStart of the period — only with dateRange: custom; with any other period the entry is cleared on save.
To customTonodateEnd of the period, same condition.
Granularity periodnoday, week, month, quarter, yearIn which steps the period is broken down.
Comparison comparisonnonone, previous_period, previous_yearWhether a comparison column runs alongside, and against which period.
Scope scopenopersonal, role, sharedWho sees the report.
Brand brandFilternoone of your brandsWhich brand the report refers to. With scope: personal the field is cleared on save.

Start export creates a run in the background; the chosen format (csv, xlsx, pdf) is the only value of that dialog and belongs to the action, not to the report.

Dashboard

FieldRequiredValues / formatWhat it does
Name nameyestext, max. 200 charactersWhat the dashboard is called.
Scope scopenopersonal, role, shared (max. 10 characters)Who sees it. A role dashboard is the way to give every salesperson the same view without building it ten times.
Role roleIdnoan existing roleWhich role it applies to, where the scope calls for it.
Brand brandFilternoone of your brandsWhich brand the tiles refer to.
Default dashboard isDefaultnoyes/noWhether this dashboard opens first when the area is entered.
Tiles widgetsnolist of tile definitionsThe entire tile set. One write replaces it completely — which is why the interface sends all tiles with every change.
Grid layoutnogrid data (columns/positions)The free grid placement of the tiles on the start page. Maintained by the start page, not by this dialog.

The tile dialog writes no field of its own but an entry in widgets:

Tile keyValues / formatMeaning
Widget typekey from the widget catalogueWhich kind of tile. Operational tiles bring content and size themselves; there only the title can be chosen.
Metricmetric keyWhat the tile shows. Mandatory for non-operational tiles.
TitletextHeading of the tile; empty = name of the metric.
Dimensionglobal, brand, customer, project, employee, teamHow it is split. Only for tile types that need a dimension — mandatory there. team splits by the team set on the employee; a role limited to "own team only" sees just the rows of its own teams — likewise for employee (the employee's home team) and owner (the user's teams); people without a team stay visible.
Periodlike dateRange, but without customWhich period. A custom period is not offered on a tile.
Granularityday, week, month, quarter, yearIn which steps.
Comparisonnone, previous_period, previous_yearWhether a comparison figure runs alongside.
Width / height1 or 2Size in the dialog grid. For operational tiles the start-page grid size stays untouched.

Schedule

FieldRequiredValues / formatWhat it does
Report reportDefinitionUlidyesa saved reportWhich report is sent.
Name namenotext, max. 200 charactersWhat the schedule is called; empty = name of the report.
Frequency frequencyyesdaily, weekly, monthlyHow often a run falls due.
Format formatyescsv, xlsx, pdfIn which format it is exported.
Recipients recipientsyeslist of email addresses or user ULIDsWho receives the file. Without a recipient the mask does not accept the schedule.
Active activenoyes/noOff pauses the schedule without deleting it.

KPI target

FieldRequiredValues / formatWhat it does
Metric metricKeyyesmetric key, max. 60 charactersWhat the target applies to.
Dimension dimensionKeyno (defaults to global)global, brand, customer, project, employee, team, owner, channel, stage (max. 30 characters)At which level the target applies; team makes it a team target. If your role is limited to "own team only", you see and maintain team and person targets only for your teams — such a target "for all" (empty value) only as a cross-team manager.
Dimension value dimensionValuenotext, max. 60 charactersFor which concrete value of the dimension — empty means: for all. With global the field is disabled.
Period periodno (defaults to month)day, week, month, quarter, yearWhich time slice the target value refers to.
Target value targetValueyeswhole number in the metric's canonical unitThe target. The unit follows the metric: money in cents (150000 = 1,500.00), duration in minutes, percentages in basis points (8500 = 85.00 %), otherwise days or a count. The mask shows the matching input and names the unit in its hint.
Comparison comparisonno (defaults to gte)gte = reach or exceed · lte = stay belowIn which direction the target applies. lte is the case for metrics where small is good — days sales outstanding, for instance.
Valid from validFromnodateFrom when the target applies; empty = no start.
Valid to validTonodateUntil when; empty = no end.
Brand brandIdnoone of your brandsWhich brand the target applies to; empty = all brands.

You see only what you may see. The permission cut sits inside the report — the same saved report can return different figures for two people without anything being broken. An export outputs exactly what was on screen; it is not a way around permissions.

Settings & permissions

  • Dashboards: reporting.dashboard.view / reporting.dashboard.manage
  • Reports and targets: reporting.report.view / reporting.report.manage
  • Financial metrics (revenue, margin, DSO, MRR): reporting.kpi.financial
  • People metrics (utilisation, cost rates): reporting.kpi.hr
  • Export and schedule: reporting.export · Cross-brand: reporting.brand.all

The two metric permissions stand on their own because their content does: being allowed to analyse projects does not imply being allowed to see salary cost rates.

Roles with the "own team only" option see only their team on team and person axes — and the overall total and the total per brand are also built only from the people they can see (own team, people without a team). This applies to metrics, time series, saved reports and dashboard tiles; otherwise another team could be worked out as the total minus one's own team. Metrics without any person or team reference stay unchanged.

Module flag: module.reporting.

FAQ & troubleshooting

A metric is missing from the selection. Then the module supplying it is not active, or you lack the metric permission.

Two people see different numbers. That is correct: reports run within the viewer's permission and brand scope.

A scheduled report did not arrive. Check schedule and recipients. Scheduled reports run on behalf of and with the permissions of the report owner: if there is no owner, the owner is deactivated or lacks the export or view permission, no export is created — the run shows the reason among the export runs.

reporting.reporting · Available from version 0.5.6