I've been trying to aggregate (SUM) by a date field with a custom format (YYYY, MM) but its not working as expected. I tried Views Date Format SQL and Merge rows modules but didn't work for me. Also, some other suggested solution is to group by field (Table settings) which also does not fit my needs.
2014-08-05 12 2014-08-05 15 2014-08-15 20 2014-09-09 10
Im trying to do it as follows:
2014,Aug 47 2014,Sep 10
Note: My collected dates attributes are year, month , day (i.e. 2014-08-05 00:00:00)