Hi,

I have a view set up with two fields - User Created Date and User UID - and the SQL Aggregation field as the last field. Date is set to display as m-d-Y.

groupby field settings are:
I have set the Group by fields to both date and uid fields, and the aggregate on field to UID

However, the aggregation does not work. I get a count of 1 for each user instead.

What am I missing? it seems it is considering the date as date-time in grouping the results.

How can this be fixed?

Thanks

my setup is:
Apache 2
PHP 5
Mysql 5
Drupal 6.15
Views 6.x-2.8
Views GroupBy

Comments

bevinlorenzo’s picture

I am having the same problem of getting a count of 1 for each user. However, I am also seeing this when I try to use any CCK field. I am going to try and use an updated version of CCK, but I am not sure that would be causing the issue.

-Thanks

Jukebox’s picture

+1, I have the same issue. Anybody know how to fix?

partyp’s picture

subscribing. Same issue.

j2b’s picture

Currently struggling with the same issue. My idea is, that Date display affects only dispaying of node post date, which is kept in Unix Timestamp format, or actual display is done after SQL query. Because of that, each grouped node has only "1" item in respective date, as you do not see time data in column, but computer does. Any way, is there solution to such problem?

StratisFear’s picture

This is being addressed in another thread. It might help you here.

http://drupal.org/node/573264

j2b’s picture

Thank you StratisFear. I've read this issue discussion and module with additional module for my problem was too much. I ended up with PHP snippet in block content (with PHP filter) and composed custom SQL query and HTML output.

To be honest, looked through several other modules, to make them work together with this one (like Views field), but, as for SQL aggregation function (Group by) table column name, which represents form field, is needed, all other operations on views results give no difference. Such modifications are applied after sql qyery is run. And still it is hard for me to understand this module, as even with regular fields, the results were not achieved. It turned out (due to lack of examples or deployments) more easy for me as a non-programming person, to compose SQL query, rather understand this module. Althoug, the functionality described in it would be more than welcome for Drupal.