I have used the count in grouping. but it is not correct in some cases. eg : i have grouped my data month wise first then inside department wise. i used count as group aggregate. for some dept it is correct. but for some the count is not correct. in the month of may : total count is 85, but inside it IT dep count is showing 2, but when clicked it shows 5 rows.
Hello @Juwel_Jose, welcome back to the community!
Actually, Count in group aggregates doesn’t count lower and uppercase together and it might be the reason for your difference in the count readings. You can check if that is not the case.
Thanks. I hope it helps!
The grouping counts can be affected by several internal factors. The most notable and most common is duplicate row keys: if you have multiple rows that have the same key, sometimes the count will be the number of rows (irrespective of keys), sometimes it will be the number of distinct keys (irrespective of the number of actual rows).
Please provide screenshots showing the count discrepancies.
“Count in group aggregates doesn’t count lower and uppercase together”. Yes this was the problem. solved it. Thanks for your help.