Custom reports let you answer a question the dashboards don't, without waiting for anyone to build it. You pick what the report is about, choose its columns, and the report updates as you go. Find them under Insights → Custom reports.
Every report runs for the person looking at it. You only ever see rows and figures you're allowed to see, and so does everyone you share a report with — see What each person sees.
Build a report#
- Click New report and pick what the report is about — for example Time entries. You can change this later from the Report on button at the top.
- Give the report a name by typing over Untitled report at the top of the page.
- Use the settings on the left (on a phone, tap Report settings). The report on the right updates a moment after each change.
- Click Save report in the bar at the bottom. Nothing is saved until you do, and leaving the page with unsaved changes asks first.
Columns#
Add column opens a searchable list, grouped by where each column comes from (the time entry, the client, the person…). Each column has a choice for how it is shown:
- Each value shows the plain value on every row.
- Sum, Average, Count, Count of unique, Smallest, Largest or Median add up or measure the column across rows. Only the choices that make sense for a column are offered.
- For a date, By day, By week, By month, By quarter, By year, By day of week (or By hour for a time of day) groups rows into those periods.
Drag a column by its handle to change the order. The × removes it.
Once any column is a summary (like Sum of hours), the report is grouped: every plain column becomes a group. The Group by section shows them; with two, drag to change which comes first — the first group is the one that gets subtotals when Totals is on. A report can group by up to two things.
Custom fields#
Your organization's custom fields are columns too, under the record they belong to: a task's and a project's own fields, a time entry's client and project fields (Project › Engagement type), and a project's client fields. They filter exactly as the lists do, so a record the field doesn't apply to never matches, not even is empty. A dropdown groups by its option names. A multi-select groups one row per option chosen, so a record with two options counts in both, and totals count it once.
A related project's fields are blank for people who can't open that project, and they can't filter by them either. A copy published to a client shows only fields marked as visible to clients.
If a field a saved report uses is archived, replaced or changed to another type, or a filter's option is merged away, the report names the field and asks you to fix it. Archiving it from its settings page tells you how many saved reports use it first.
Filters#
Add filter narrows the report to the rows you care about. Pick a column, then how to compare it: is, is not, is any of, is none of, is more than, is at least, is less than, is at most, is between, contains, starts with, is empty, is not empty, is yes, is no, is in the last (for example 30 days) or is in the next. Dates can also be compared with a named period, like is in last month. People, clients and projects are found by typing a name; only the ones that appear in rows you can see are offered.
With more than one filter you choose whether a row must match all or any of them. Add another group of filters lets you combine sets, for example "billable time for one client" or "any time on a certain project". A filter that still needs a value is marked, and the report waits until you finish it.
Period#
When the rows have a date (time entries do), the Period section sets the dates the report covers — Last 30 days, Last month, Year to date, Custom dates and more. Dates are in your time zone.
On a summarised report you can also Compare with the previous period or the same period last year. Each summary then gets two more columns: the earlier figure and the change since then.
Calculated columns#
Add calculated column works out a new figure from the report's summaries — for example Billable %. Give it a name, then type a formula using the summaries in the report. Click a summary's name under the formula to add it where the cursor is. Under the formula you'll see it read back in the report's own words ("Billable hours ÷ Hours"), or what's wrong with it, as you type.
- Use
+,-,×(or*),÷(or/) and brackets. Three functions are available:round(x, 2)rounds to that many decimals (0 to 6),if_null(x, 0)uses the second value when the first is empty, andsafe_div(a, b)divides and leaves the answer empty whenbis zero. - Show as sets how it is shown: Number, Percent, Money or Hours. Percent shows the answer times 100 with a % sign, so
safe_div(billable_hours:sum, hours:sum)over 4 billable hours of 5 shows as 80%. A calculated column that uses a percent one sees the percent figure (80), not the share (0.8). - A calculated column can use the columns before it. A report can have up to 10, and each formula can be up to 200 characters.
- It is worked out from each row's own summed figures, and the Total row and each subtotal from their own — never by adding up or averaging the rows' answers, which would be wrong for a ratio. Dividing by nothing leaves the cell empty rather than showing a zero.
- You can Sort by a calculated column. Show top can't rank by one (it keeps the top rows before the figure exists), except in a report spread across columns.
- Beside Compare with, a calculated column shows the current period only.
- A calculated column is your own formula, not one of AspirePro's definitions; a note under the report says so.
- If any summary a calculated column uses is hidden from the person looking, the calculated column is Hidden for you too, so a formula can't be used to work out a figure they aren't allowed to see.
Spread across columns#
With a summary and two groups, Spread across columns puts one of the groups across the top instead of nesting it — hours by client down the side and by month across, one cell per pair. Pick which group goes across; the other stays down the side. Fill the cells with chooses the figure: a summary, or a calculated column that uses up to three summaries.
- The report shows the 50 biggest columns (the first 50 for dates and choices, in their own order, so January comes before February) and adds up everything else in one Other column. With Show top, the rows past it become an Other row the same way.
- Other is worked out from the records themselves, so it is right for a sum, an average, a count of unique and a calculated column alike. Column totals, row totals and the grand total are too: each is the figure over its own records, not a sum or average of the cells.
- A blank cell means there was nothing to add up there — it is not a zero. A month with no work shows as a blank column between the first and last month that have any.
- Sort orders the rows by their name or by the figure they add up to; the biggest come first unless you say otherwise.
- Totals adds the Total column and the total row.
- A grid is a table, and it can't be compared with an earlier period. Its numbers don't open the records behind them. Export writes the grid as a table with its totals.
Sort, show top and totals#
- Sort orders the rows by up to three columns, each in either direction.
- Show top keeps only the first rows after sorting — "the top 10 clients by hours". Leave it empty to show every row, up to 2,000.
- Totals adds a total row at the bottom of a summarised report. A report grouped by two things also gets a subtotal under each first group.
Show as#
A report is a Table by default. When its shape fits, you can show it as a Number (summaries, no groups), a Bar or Column chart (one group), a Donut (one group, one summary) or a Trend line (one date group, like By month). Only the ones that fit are offered. A chart draws the first summary; the table shows them all.
See what's behind a number#
In a grouped table, click a figure to open the rows it adds up — the time entries, tasks or projects themselves. The window shows the group, the figure and the rows, 50 at a time, with Load more. You can click a point on a chart the same way. Export in that window downloads the rows you've loaded as a CSV file.
Put a report on a dashboard#
Open a summarised report, then ⋯ → Add to dashboard and pick My dashboard or a shared dashboard you can edit. (Save your changes first: the widget shows the saved report.) The widget is the report, as a number, a chart, a table or a pivot table, whichever fits its columns and groups; Show as on the widget changes it. You can also add it from the widget picker, under Saved reports.
- It runs as the person looking. Share the dashboard and each person sees the report with their own access: rows they can't see are left out, and a money column they can't see isn't shown. If the first column is hidden from you, the widget shows the next one you can see and says so. A report that no longer works for you, or that was deleted, shows as unavailable on the dashboard; opening the report (if you still can) names the reason.
- Changes show at once. Edit the report and the widget shows the new version the next time the dashboard loads. The exception is the report's period: a widget starts on the report's period and then keeps its own, like any widget, so it can follow the dashboard's period filter or be set to other dates.
- Filters. A widget follows the dashboard's client, project, person, team and agreement filters wherever the report has a matching column (for example a report on time follows all of them; a report on companies follows client and person). The widget says when it can't follow one.
- Schedules and links. A scheduled dashboard, a share link or an alert that includes a saved report shows it as the person who set it up. If someone else changed the report after that person last saved it, the widget says Changed by someone else. The owner needs to open and save it. and shows no figures until they do. Excel, CSV and PDF copies print the report as a table or pivot with one column per figure, or print that same line.
- A widget's ⋯ → Open report goes to the report. The records behind a figure are listed there, not from the widget.
Share a report#
If you own a saved report, Share lets you give it to everyone, a team or a person, either to view or to edit. People you share it with can open it, export it and duplicate it; with Can edit they can also change it. Only the owner can share, archive or delete a report. Unshared reports are private — even to admins.
Anyone can Duplicate a report they can open to make a copy that is theirs to change. Archive a report from the list's ⋯ menu to hide it from the default list; Archived reports shows it again.
Export#
Export downloads the report as a CSV or an Excel file, with the same columns and totals as on screen. Reports with more than 5,000 rows can't be exported — narrow the period or add a filter first. Text that could run as a spreadsheet formula is written as plain text, so opening a file never runs anything.
What each person sees#
A report stores what you asked for, not anyone's numbers. Each time it is opened, exported or drilled into, it runs again as the person looking:
- Rows are limited to what that person can see anywhere else in AspirePro — someone who can only see their own time sees only their own time in a shared time report.
- Money and rate columns need the matching permission. A column you can't see isn't offered when you build a report. When you open a report someone shared with you that includes such a column, it shows as Hidden for you: the heading stays, the cells are empty, and the totals leave it out.
- A report can't filter, group, sort by or spread across columns a figure you can't see, because that would reveal it. If it does, the report tells you which setting is the problem instead of showing numbers.
Limits#
- Up to 30 columns, 2 groups, 3 sorts, 10 calculated columns, and 10 groups of up to 10 filters each.
- A report spread across columns shows up to 50 columns before the rest are added up as Other.
- A period of up to ten years.
- The screen shows up to 2,000 rows. A note under the report says when it was cut.
- A report that takes too long to run stops with a message; narrow the period or add a filter.
For how the numbers on dashboards are worked out, see How AspirePro calculates its numbers. To email a report on a schedule, see Reports.