Answers to the questions we hear most often about reporting in Teamwork.com — covering Custom Reports, the Time Report, Profitability Report, Utilisation Report, Budget Reporting, Dashboards, Formula Fields, Scheduled Reports, Exports, and Advanced Reporting.
In this article
Advanced Reporting- Formula Fields
- Dashboards and Insights
Advanced Reports
Can I get averages by group in Advanced Reporting?
Yes. When you apply a grouping, you get an option to change how the values are aggregated — sum, average, count, and more. This also works with custom fields, so you can do things like calculate the average time per tag or a completion rate across a group.
Why do numbers appear in custom field column labels in Advanced Reporting?
This is how Advanced Reporting tells apart custom fields that share the same name — without a number, identically named fields would get grouped together incorrectly. The number can't be removed, but if it's getting in your way, you can create an expression and give it its own name instead.
Why don't currency values in Advanced Reporting have commas or proper formatting?
Currency values that come from formula fields display without commas because they're treated as text rather than numbers. Standard currency columns still display with full formatting — it's only formula-derived currency values that show up unformatted.
Formula Fields
Can I convert time values to currency in formula fields (e.g. non-billable hours × rate)?
You can't convert time to currency directly, but you can get there using TO_CUR_TIME along with some unit manipulation. The AI formula assistant can also help you build a formula like this if you're not sure where to start.
Can formulas reference other formula fields?
Not currently — a formula field can't use another formula field as an input. As a workaround, copy the contents of the first formula directly into the second. Letting formulas reference each other is something we'd like to support in the future.
How do I display a different currency symbol in formula fields?
Divide by TO_CURRENCY(1) to get the raw number, then wrap it with CONCATENATE("$", <your formula>) to add the symbol you want. Keep in mind the result will display as text rather than a native currency value.
Dashboards and Insights
What are the plans for dashboards in Teamwork?
We offer a few dashboard options inside Teamwork.com, when you log in, we have the main home dashboard, we offer a range of widget options, you can add new tabs for different configurations of widgets. We also offer insights panels on the top of various other features in app, including Risks, Milestones, and Project health report.
Can I see tasks broken down by workflow stage as a chart/widget?
Yes we offer a workflows widget on the dashboard.
Is there a burndown chart available?
A task completion burndown exists on the legacy Dashboard but isn't fully accurate (doesn't account for new tasks created). A time-based burndown (logged vs estimated) isn't available yet. More accurate charts are expected as part of the new dashboards work.