My report shows two different totals using the same data, filters and aggregation.

[Robert Campbell]

I have two reports using the same data with the same filter one grouped by sys id and the other using count distinct sys id. I would expect these to be exactly the same. One is a pie chart and the other is a list but with the same filter and the same aggregation, I would expect the same total number but that isn't the case.

As you can see, one has a total of 91 and the other 84.

[Venkatesh_N · Accepted solution]

Hi @Robert Campbell ,

In the first report, you have grouped by Service Team and then counting the distinct sys_ids.
But in the second report, you're only counting the grouped by sys_ids count.

To be more precise, 

The second report gives you the count of the highlighted row as count 1. but if you group it by Service team i.e splitting those 8 into (2)-(2)-(2)-(2) based on their respective service teams, then the count will be 4 instead of 1.

I hope this helps. Mark my answer correct & Like Helpful, if Applicable.

Thanks!
Venkatesh Nekkanti

[Robert Campbell]

I see. I forgot that the first one is grouped by a column on the service record which could be a one ba to many bs relationship. When I default them both to a filtered column on the same table I get the same numbers.

[rambabuboyapati]

Hi Robert,

I think the distinct count is evaluated within each group in your first report (pie chart), whereas the distinct count in your second report is on the full data set. There could be duplicate sys_ids across different groups in your first report. Please export both data sets into excel and compare.

I hope this helps.

Kind regards,

Ram