Why are grand totals hidden when I group a report by Tag or User Group?

When you run a report and group your data by Tag or User Group, you may notice that the grand total is not displayed within the report's table or chart.

This is intentional behavior designed to prevent confusion from inaccurate, double-counted totals. This guide explains why this happens and where you can find the correct total.

Our application allows a single time entry to have multiple tags. For example, a 1-hour time entry for a design task for a specific client could have two tags:

When you generate a report and group it by Tag, this single 1-hour entry needs to be represented under both categories. This creates a "double-counting" issue.

Example:

Let's look at that single 1-hour time entry. In a report grouped by Tag, it would appear like this:

If we were to sum the rows, the Grand Total would incorrectly show 2 hours, even though only 1 hour of work was actually tracked. This is because the same time entry was counted once for each of its tags.

To prevent the confusion caused by these inflated numbers, we've chosen to hide the grand total within the chart or table only when you group by Tag or User Group.

We believe that showing an inaccurate total is more confusing than hiding it. This way, you can still see the correct totals for each individual tag without being misled by an incorrect overall sum.

The correct, non-duplicated grand total for all time entries matching your filters is always visible at the top of the report page. This summary total is the true reflection of the time tracked.

We hope this explanation helps clarify how totals work with tag and user group based reporting! If you have any further questions, please don't hesitate to reach out to our support team.