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
Comment #1
naeluh commentedComment #2
naeluh commentedIs there any information that I could provide that could help this issue I really would like to get this thanks !!
Comment #3
scottrigby@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.