Compatibility With Date Module

It appears that Charts is not compatible with the Date module. When i try to create a chart which aggregates data on a date field ( in my particular case i am using a weekly date format) i get the following error:

user warning: Unknown column 'node_data_field_log_date.field_log_date_value' in 'field list' query: SELECT node_data_field_log_date.field_log_date_value AS node_data_field_log_date_field_log_date_value, ROUND(SUM(node_data_field_log_sale_price.field_log_sale_price_value), 0) AS field_log_sale_price_value FROM node node INNER JOIN content_type_log_item node_data_field_log_type ON node.vid = node_data_field_log_type.vid LEFT JOIN content_type_log_item node_data_field_log_agent_responsible ON node.vid = node_data_field_log_agent_responsible.vid LEFT JOIN content_type_log_item node_data_field_log_sale_price ON node.vid = node_data_field_log_sale_price.vid WHERE (node.type in ('log_item')) AND (node_data_field_log_type.field_log_type_value = 'Sale') GROUP BY node_data_field_log_date.field_log_date_value ORDER BY node_data_field_log_agent_responsible_field_log_date_value ASC in /home/concordi/public_html/cms/sites/all/modules/views/includes/view.inc on line 759.

Aggregating on a date field is very helpful for such things as sales per week or sales per month etc...