I want to make a simple view using the [Charts][1] module.

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][2] but this only works for core date fields (Posted Date, Updated date...)

So, is there any other way to do this?


  [1]: https://www.drupal.org/project/charts
  [2]: https://www.drupal.org/project/views_date_format_sql