How to create a query to GROUP BY Date? Where is GROUP BY?

HI,

I am trying to return the sum of a set numbers grouped by Month and year in a date.

For example:

number | Date
2 | 01/02/2016
3 | 02/02/2016
5 | 12/03/2016
6 | 21/03/2016
7 | 22/03/2016
8 | 28/02/2017
9 | 29/03/2017
12 | 30/03/2017

The result based on Group By dates month and year would be:
5, 18, 8, 21

I can not see how you do a Group By so need help determining how I do something like this.

Thanks in Advance!

1 Like

There must be a day to group a result by date? What am I missing, the lack of documentation makes this frustrating!:confounded::sob:

no there is not right now this grouping feature as far as I knwo

Hi there? were you able to solve this issue?