Hi I am trying to group my graph by month in drupal views.

I can not get it to work ?

here is my graph

http://client.theconfluencegroup.com/ana_date

here's my query from views:

SELECT field_data_field_date_created.field_date_created_value AS field_data_field_date_created_field_date_created_value, field_data_field_date_created.bundle AS field_data_field_date_created_bundle, node.created AS node_created_1, MIN(node.nid) AS nid, 'node' AS field_data_field_twitter_followers_node_entity_type, SUM(field_data_field_twitter_followers.field_twitter_followers_value) AS field_data_field_twitter_followers_field_twitter_followers_v, DATE_FORMAT((DATE_ADD('19700101', INTERVAL node.created SECOND) + INTERVAL -21600 SECOND), '%M %Y') AS node_created, 'node' AS field_data_field_facebook_likes_node_entity_type, SUM(field_data_field_facebook_likes.field_facebook_likes_value) AS field_data_field_facebook_likes_field_facebook_likes_value, 'node' AS field_data_field_unique_monthly_visitors_node_entity_type, SUM(field_data_field_unique_monthly_visitors.field_unique_monthly_visitors_value) AS field_data_field_unique_monthly_visitors_field_unique_monthl, 'node' AS field_data_field_date_created_node_entity_type
FROM
{node} node
LEFT JOIN {field_data_field_project} field_data_field_project ON node.nid = field_data_field_project.entity_id AND (field_data_field_project.entity_type = 'node' AND field_data_field_project.deleted = '0')
LEFT JOIN {field_data_field_twitter_followers} field_data_field_twitter_followers ON node.nid = field_data_field_twitter_followers.entity_id AND (field_data_field_twitter_followers.entity_type = 'node' AND field_data_field_twitter_followers.deleted = '0')
LEFT JOIN {field_data_field_facebook_likes} field_data_field_facebook_likes ON node.nid = field_data_field_facebook_likes.entity_id AND (field_data_field_facebook_likes.entity_type = 'node' AND field_data_field_facebook_likes.deleted = '0')
LEFT JOIN {field_data_field_unique_monthly_visitors} field_data_field_unique_monthly_visitors ON node.nid = field_data_field_unique_monthly_visitors.entity_id AND (field_data_field_unique_monthly_visitors.entity_type = 'node' AND field_data_field_unique_monthly_visitors.deleted = '0')
LEFT JOIN {field_data_field_date_created} field_data_field_date_created ON node.nid = field_data_field_date_created.entity_id AND (field_data_field_date_created.entity_type = 'node' AND field_data_field_date_created.deleted = '0')
WHERE (( (node.status = '1') AND (field_data_field_project.field_project_value LIKE 'Anastasia' ESCAPE '\\') AND (node.created >= -15012000) ))
GROUP BY node_created, field_data_field_twitter_followers_node_entity_type, field_data_field_facebook_likes_node_entity_type, field_data_field_unique_monthly_visitors_node_entity_type, field_data_field_date_created_node_entity_type, field_data_field_date_created_field_date_created_value, field_data_field_date_created_bundle, node_created_1
ORDER BY node_created_1 ASC

thanks !

Comments

naeluh’s picture

Priority: Normal » Major
naeluh’s picture

Is there any information that I could provide that could help this issue I really would like to get this thanks !!

scottrigby’s picture

Priority: Major » Normal
Status: Active » Postponed

@naeluh hi. Postponing until #1674902: Highcharts views 2.x status is finished, when we can revisit how this will work in the new Views UI.

See #1913362: Pie chart displaying as whole pie? for an explanation of timeline and support for the 1.x and 2.x branches.