Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Hi,
I had duplicate entries in my view so I activated the Distinct option. But Views Calc now still sums up also the omitted rows. This results in a sum that has exactly the duplicate total of the the above numbes in the visible rows.
Am I doing something wrong?
Regards, Thomas
Comment | File | Size | Author |
---|---|---|---|
Views Calc - with Distinct.png | 8.82 KB | t.lan |
Comments
Comment #1
jon_stewart CreditAttribution: jon_stewart commentedSubscribing - This occurs for me too.
Comment #2
Skorpjon CreditAttribution: Skorpjon commentedSubcribing
Same bug. For the user 1 it shows the right value. Everyone else gets the double value.
Comment #3
Skorpjon CreditAttribution: Skorpjon commentedIt is not a problem of Views Calc. Duplicate of http://drupal.org/node/284392
Comment #4
Skorpjon CreditAttribution: Skorpjon commentedMy mistake. But take a look at http://drupal.org/node/681760. This could fix the problem...
Comment #5
atrofast CreditAttribution: atrofast commentedI have the same problem, there are duplicates in the SUM but not the results after turning distinct on. I haven't tried applying any of those patches to core, and frankly am a little worried about doing so until there is a proper release. Can anyone confirm those changes fix this problem? Thanks.
Comment #6
leon85321 CreditAttribution: leon85321 commented#4 fixed that problem!
Only comment out 3 lines, and add 4 lines of code will do it!
Thx for the post.
Comment #7
hobo CreditAttribution: hobo commentedI'm seeing this too.
Comment #8
JCB CreditAttribution: JCB commentedThanks Skorpjon
Seems like there was a core problem with Node Module.
I applied the patch at comment #127
(http://drupal.org/node/681760#comment-4371188)
Here is link to patch:
http://drupal.org/files/issues/681760_node_access-127-D6.patch
Solved my problem
Comment #9
truyenle CreditAttribution: truyenle commentedsame issue and the patch does work for me.
Comment #10
fantasma CreditAttribution: fantasma commentedToday i discovered this problem as well. The problem appears if a node access module (using grants) is used.
If only one grant is active, everything works fine. Two active grants will double the result, and so on.
The problem disappears if "hook_node_grants($account, $op)" in the node access modul only returns one grant id for a realm.
I can live with this solution, bit this should be fixed in Views Calc.
Comment #11
KarenS CreditAttribution: KarenS commentedThe D6 version is no longer supported.
Comment #12
jvieille CreditAttribution: jvieille commentedNever fixed, even in D7 apparently.
Using a views with relationships gives my a count either ignoring distinct (counting on a related table field) or 1 (counting on a main table field)