I want to make a simple view using Charts.

The x-axis will be a custom field of type Date that I want to show in Y-m-d format and grouped by the same date. The y-axis will be NID with COUNT aggregation.

This seems so easy but the problem is the aggregation of the date field. Apparently, views doesn't like to aggregate those kind of fields. Tried Views Date Format SQL but this only works for core date fields (Posted Date, Updated date...)

So, is there any other way to do this? Thanks.