Report Builder β View and Export a Custom Report
After you open a custom report in Report Builder, you can adjust filters, compare performance across time periods, drill into breakdowns, and download the data as an Excel file. This article explains how each part of the report view works.
Audience: Organization owners, center managers, and administrators who analyze business performance using custom reports in Report Builder.
On this page
Before you begin
- Your organization must have Report Builder enabled.
- You need the Read permission under Reports KPI Builder in your security role to open reports from the Custom reports workspace.
- To use Export Excel, your organization must have exports enabled. Contact your Zenoti administrator if the button does not appear.
Permission: The View Report and View & Publish Report actions require Read under Reports KPI Builder.
How the report view opens
From the Custom reports workspace, locate the report card you want to review. Each card shows a View Report or View & Publish Report button depending on whether the report is published.
Select View Report or View & Publish Report to open the report and load its data.
If data fails to load, the message "Failed to load report" appears. Select Go to Dashboard to return to the Custom reports workspace and try again later.
The report opens on the time period that was saved with the report. You can change any filter without affecting the saved configuration β the report only updates when you select Refresh.
How it works
Time period
The Time period dropdown controls the date range for all KPIs in the report. The report opens on the saved time period.
Every preset ends yesterday, calculated in the center's time zone. Today's activity is never included.
The available options are:
| Option | Notes |
|---|---|
| This Year | From 1 January of the current year through yesterday |
| This Quarter | From the first day of the current quarter through yesterday |
| This Month | From the first day of the current month through yesterday |
| This Week | From the organization's configured first day of the week through yesterday |
| Yesterday | The single day before today |
| Last 7 Days | The seven days ending yesterday |
| Last 30 Days | The 30 days ending yesterday |
| Fiscal Week | Covers the organization's fiscal week; comparison uses the same fiscal weeks one year earlier |
| Custom | Choose a specific Start date and End date |
Custom date range rules:
- The latest selectable date is yesterday.
- The earliest selectable date is 1 January two years before the current year.
- The selected range cannot exceed 12 months. If you exceed the limit, the message "Date range cannot exceed 12 months" appears.
Fiscal Week date range:
When you select Fiscal Week, two additional fields appear: Start Week and End Week. The last-year comparison uses the same fiscal weeks one year earlier.
Note: Fiscal Week is not available for Guest Level or Campaign Level reports.
Filters
Changing any filter does not reload the report immediately. After you change a filter, Refresh becomes available. Select Refresh to reload the data with the new filter selections.
Center filter
The center filter is a searchable multi-select. Its label reads All Centers when all centers are selected, or shows the number of centers selected followed by "centers" (for example, "3 centers").
- When you are working at the organization level, the filter defaults to all centers.
- When you are working at your own center, the filter defaults to your center.
On Organization Level reports, the center filter also offers a Break down by center toggle and an Apply button. At least one center must remain selected; if you clear all centers, the message "Select at least 1 center" appears.
Employee filter
Employee Level reports include an employee filter. Its label reads All Employees when all employees are selected, or shows the number of employees selected.
Item-type filter
Category Level reports include an item-type filter with four options:
- Service
- Product
- Membership
- Package
Comparison columns and growth indicators
Every KPI row shows three columns:
| Column | What it shows |
|---|---|
| CURRENT PERIOD | The value for the selected time period |
| PREVIOUS PERIOD | The period of the same length immediately before the selected dates |
| CURRENT PERIOD LAST YEAR | The same date range one year earlier |
For PREVIOUS PERIOD and CURRENT PERIOD LAST YEAR, Zenoti displays the change from that earlier value to the current value, rounded to one decimal place:
- A green upward arrow with (+x.x%) when the current value is higher.
- A red downward arrow with (-x.x%) when the current value is lower.
- No indicator when there is no change or when the earlier value is zero.
Note: The CURRENT PERIOD LAST YEAR column is hidden only when a Custom date range spans exactly 12 months. Every preset β including This Year β shows all three columns.
Breakdown
Each KPI row has a Breakdown toggle. Only one KPI's Breakdown can be open at a time.
If every value in the Breakdown is zero, the toggle is disabled and shows "No breakdown data available."
How Breakdown drills down:
- When the selected date range spans more than one quarter, Breakdown starts at quarters. When the range spans more than one year, year rows appear above the quarter rows.
- When the selected date range is within a single quarter, Breakdown starts at months.
- From months, you can drill down into weeks, and from weeks into individual days.
Week labelling: Breakdown weeks are calendar weeks running Sunday through Saturday within each month. They are labelled Week 1, Week 2, and so on. A week that straddles a month boundary or the edge of the selected range is cut at that boundary.
Rows with all-zero values are hidden. The previous period for each Breakdown row is shifted back by the full length of the selected range.
Breakdown by entity:
| Report level | Breakdown by |
|---|---|
| Employee Level | Lists each employee; each employee drills into time periods |
| Organization Level with Break down by center | Lists each center; each center drills into time periods |
| Category Level | Lists each category; each category drills into time periods |
Note: Comparison columns and Breakdown are not available for Guest Level or Campaign Level reports, which use a table format instead.
Export Excel
Export Excel appears when exports are enabled for your organization. It downloads the report data directly as an Excel file named after the report. The download uses the current filter selections at the time you select the button.
The downloaded workbook contains a sheet named KPI Report with the following columns:
| Column | Description |
|---|---|
| Period / Entity | The time period or entity row (year, quarter, month, week, day, or employee / center / category name) |
| Current Period | The value for the current period |
| Previous Period | The value for the previous period |
| vs Previous Period % | The percentage change from the previous period to the current period |
| Current Period Last Year | The value for the same period one year earlier |
| vs Current Period Last Year % | The percentage change from the same period last year to the current period |
Rows are grouped from years down to days. Year rows show a dash in the last-year columns.
Error messages:
- If the export is too large, the message "Data has exceeded the export, reduce the number of KPIs selected or reduce the timeframe." appears. Reduce the number of KPIs in the report or shorten the date range, then try again.
- If the export fails for another reason, the message "Export failed. Please try again." appears.
Note: Report Builder exports download directly β they are not emailed.
Note: Guest Level and Campaign Level reports use Export CSV instead of Export Excel.