Date aggregation [#2204473]

Hi,

I'm creating a view that lists performances (of circus shows). Then I have a performances type, that is related with shows type.

I'm listing performances like this:
Show - event, place - date

Now I'm having a problem because the list repeats one item like this:
Salsa - Fira de circ al carrer, La Bisbal de l'Empordà - 21/07/2013
Salsa - Fira de circ al carrer, La Bisbal de l'Empordà - 21/07/2013

This happens because there are two performances, one is on 21/07/2013 at 18.30 and the other 21/07/2013 at 21.00
The dates are diferent but the output I want are equal.

I'm searched but I don't find any post with the same problem.

How can I solve this ?

Thankls in advance !!

Comments

Comment #1

Arjandew CreditAttribution: Arjandew commented 26 February 2014 at 07:45

Hi,

I think that this module solves your problem:
https://drupal.org/project/views_date_format_sql

Usage:

Add or edit a view.
Enable Aggregation.
Add a date field or edit one by clicking the field name.
In the "Configure Field" pop-up look for "Use SQL to format date"
Try setting the date format to something like "Y-m" for monthly reports

arjan

Comment #2

ferriol CreditAttribution: ferriol commented 28 February 2014 at 22:08

Thanks for your suggestion, but doesn't work for me.

I'm using de date module and views_date_format_sql module doesn't supports date fields in its release version. There is a patch https://drupal.org/node/1830436 to support the date fields, and works. But doesn't work for me, because I'm using a sort criteria with the same date field.
views_date_format_sql reaches the target to group rows because is setting the date format at sql level. But when I add the sort criteria, views add other date value in group by and then the rows become different, because this hasn't the same granularity of the other date fields, it has the all value.

Wow! i'm looking for a solution. I'm spending too much time on this, I'm learning a lot but I'm losing my time too.

Thanks !! I hope this helps somebody