🙋❓FAQS
Why do my grouping options change? Sometimes I can group by item, and other times I’m not! What gives?
We’ve designed Reporting be as powerful as possible, which means allowing all the available options that we can at each stage. So if you’ve only got Time data sources, you’ll be able to group by Item Name, Team Member etc. But if you include other data sources such as Expenses or Invoices, they don’t belong to any Team Member or specific Item, it’s not possible to include that grouping.
Work In Progress in your new Reporting is showing different figures than the other WIP report. What gives?
Any discrepancies would be related to the Unscheduled Time portion of the calculations. We've made some improvements to the how calculations are made for the new reporting section in order for it to be more helpful.
In the new Reporting, Unscheduled Time now rolls forward instead of disappearing.
In the current WIP, if there was unscheduled time in the past, it would no longer be included in calculations regardless of item status. Now, completed item time will be excluded from calculations, but if there is unscheduled time in the past on an item that was Paused or In Play, we assume work may still be done and move that time forward. To exclude, simply Complete items you no longer want to be included in that calculation.
I’ve added a column to Expenses that I actually want to filter differently to the other columns. How do I do this?
You can create a new filter set simply by clicking the dropdown from Expenses and selecting ‘Create new empty set’. You can then name this set, and add filters on the right hand column. This also allows you to move columns between filter sets if you accidentally add one to the wrong set. You can also duplicate filter sets on the right hand side if you need to.
Why are some jobs appearing that have no data?
Because columns from Job Totals aren't affected by the date filter, you'll need to specifically filter out any jobs that you don't want to see: either using the Global Filters to remove them entirely from the report, or using the Job Totals filter set itself if you don't want to exclude the job entirely and still see it appear if it fits other data sources.
If you're seeing jobs that are out of date, or completed many moons ago, consider adding a Job Status filter at the global level. This might also be a nice nudge to tidy up your jobs and archive those that are no longer required 🧹
Still confused? Watch the below on how you might tackle filtering when you've got a Job Totals column in your report.
I've put in my Used Time column from Job Totals, but I can't filter by date. Why?
Columns from Job Totals show the totals stored on the job — exactly the same as on the jobs list. This means you can't map them across time. To get the same data plotted over time, create a column using To Do's as a data source. It's handy to have both options so that you can create reports that can compare totals as a whole separately from specific data columns based on Time, Expenses, Quotes and Invoices.
Aside from Budget, all other Job Totals columns can be made from the specific data sources to be mapped over time, or via a combination of data columns using formula columns.
I want this sharing level for all of my other saved favourites in the lists! Please?
Of course you do! It’s only natural. During this testing period, we’ll be gathering feedback on the functionality and experience in Reporting alone, and plan to roll out this capability further at a later date.