Reporting Dashboard Bug: number vs. donut chart shows different sum totals of numerical custom fields even with same filters applied.

Bug Description:
Sum of numerical custom fields displaying differently in numbers vs donut charts in dashboards even with exact same filters applied.

Steps to reproduce:
Create a dashboard with at least 2 charts:

  • Number chart:
    – report on tasks
    – include tasks from [company or portfolio]
    – value = SUM of [numerical custom field]
    filters:
    – task completion status = completed
    – completion date = within the last 7 days
    – assignees = include [user]

  • Donut chart:
    – report on tasks
    – include tasks from [company or portfolio] (same as number chart)
    – group = Project
    – measure = SUM of [numerical custom field]
    filters:
    – task completion status = completed
    – completion date = within the last 7 days
    – assignees = include [user]

Feature impacted:
The different sum total shown in these two side-by-side charts despite no obvious difference in the task pool it’s pulling from calls into question the data integrity of the whole reporting feature and makes me hesitant to use it for anything serious.

Status:
Active as of 2022-07-20

Hi @Alison_Palmer, thanks for flagging this.

I’ve gone ahead and escalated it to our Engineers. I’ll let you know as soon as I have an update :slight_smile:

Hi @Alison_Palmer, our Product team have come back and advised that “Group by project” is probably counting the same tasks multiple times since tasks can live in multiple projects. Is this the case?

If so, this is expected behaviour :slight_smile:

1 Like

Oh interesting, yes I believe that is what is happening. I can see why that might be useful in some cases, but for hours/time tracking it ends up double-counting the same hours.

I think it would be a great feature-add if there was a filter on the chart creation pane which would allow a user to select whether they wanted to ignore duplicate counts by putting multi-homed tasks in a “multiple projects” category or to include duplicate sums of multi-homed tasks