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

CommentFileSizeAuthor
Views Calc - with Distinct.png8.82 KBt.lan

Comments

jon_stewart’s picture

jon_stewart commented

Subscribing - This occurs for me too.

Skorpjon’s picture

Skorpjon commented

Subcribing

Same bug. For the user 1 it shows the right value. Everyone else gets the double value.

Skorpjon’s picture

Skorpjon commented
Status: Active » Closed (duplicate)

It is not a problem of Views Calc. Duplicate of http://drupal.org/node/284392

Skorpjon’s picture

Skorpjon commented
Status: Closed (duplicate) » Active

My mistake. But take a look at http://drupal.org/node/681760. This could fix the problem...

atrofast’s picture

atrofast commented

I 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.

leon85321’s picture

leon85321 commented

#4 fixed that problem!
Only comment out 3 lines, and add 4 lines of code will do it!

Thx for the post.

hobo’s picture

hobo commented

I'm seeing this too.

JCB’s picture

JCB commented

Thanks 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

truyenle’s picture

truyenle commented

same issue and the patch does work for me.

fantasma’s picture

fantasma commented

Today 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.

karens’s picture

karens commented
Issue summary: View changes
Status: Active » Closed (won't fix)

The D6 version is no longer supported.

jvieille’s picture

jvieille commented

Never 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)