Thanks for the view. I have managed to see the story of the author exposed in the views, I can give dates manually, but then to calculate the total stories he posted from 1-30 of a month (and that date varies) I have to do 30 manual searches for each date. Is it possible to give date range in the exposed filter to find how many stories the selected author posted between given dates.
Here is the views I am using:
$view = new view(); $view->name = 'total'; $view->description = ''; $view->tag = 'default'; $view->base_table = 'users'; $view->human_name = 'total'; $view->core = 7; $view->api_version = '3.0'; $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
/* Display: Master */ $handler = $view->new_display('default', 'Master', 'default'); $handler->display->display_options['title'] = 'total'; $handler->display->display_options['use_more_always'] = FALSE; $handler->display->display_options['group_by'] = TRUE; $handler->display->display_options['access']['type'] = 'perm'; $handler->display->display_options['access']['perm'] = 'access user profiles'; $handler->display->display_options['cache']['type'] = 'none'; $handler->display->display_options['query']['type'] = 'views_query'; $handler->display->display_options['query']['options']['distinct'] = TRUE; $handler->display->display_options['query']['options']['query_comment'] = FALSE; $handler->display->display_options['exposed_form']['type'] = 'basic'; $handler->display->display_options['pager']['type'] = 'full'; $handler->display->display_options['pager']['options']['items_per_page'] = '10'; $handler->display->display_options['style_plugin'] = 'default'; $handler->display->display_options['row_plugin'] = 'fields'; /* Relationship: User: Content authored */ $handler->display->display_options['relationships']['uid']['id'] = 'uid'; $handler->display->display_options['relationships']['uid']['table'] = 'users'; $handler->display->display_options['relationships']['uid']['field'] = 'uid'; /* Field: User: Name */ $handler->display->display_options['fields']['name']['id'] = 'name'; $handler->display->display_options['fields']['name']['table'] = 'users'; $handler->display->display_options['fields']['name']['field'] = 'name'; $handler->display->display_options['fields']['name']['label'] = ''; $handler->display->display_options['fields']['name']['alter']['word_boundary'] = FALSE; $handler->display->display_options['fields']['name']['alter']['ellipsis'] = FALSE; /* Field: COUNT(Content: Nid) */ $handler->display->display_options['fields']['nid']['id'] = 'nid'; $handler->display->display_options['fields']['nid']['table'] = 'node'; $handler->display->display_options['fields']['nid']['field'] = 'nid'; $handler->display->display_options['fields']['nid']['relationship'] = 'uid'; $handler->display->display_options['fields']['nid']['group_type'] = 'count'; $handler->display->display_options['fields']['nid']['label'] = 'Number of Stories Posted'; $handler->display->display_options['fields']['nid']['hide_alter_empty'] = FALSE; /* Filter criterion: Content: Author uid */ $handler->display->display_options['filters']['uid']['id'] = 'uid'; $handler->display->display_options['filters']['uid']['table'] = 'node'; $handler->display->display_options['filters']['uid']['field'] = 'uid'; $handler->display->display_options['filters']['uid']['relationship'] = 'uid'; $handler->display->display_options['filters']['uid']['value'] = ''; $handler->display->display_options['filters']['uid']['exposed'] = TRUE; $handler->display->display_options['filters']['uid']['expose']['operator_id'] = 'uid_op'; $handler->display->display_options['filters']['uid']['expose']['label'] = 'Author uid'; $handler->display->display_options['filters']['uid']['expose']['operator'] = 'uid_op'; $handler->display->display_options['filters']['uid']['expose']['identifier'] = 'uid'; $handler->display->display_options['filters']['uid']['expose']['remember_roles'] = array( 2 => '2', 1 => 0, 24 => 0, 6 => 0, 5 => 0, 25 => 0, ); /* Filter criterion: Date: Date (node) */ $handler->display->display_options['filters']['date_filter_1']['id'] = 'date_filter_1'; $handler->display->display_options['filters']['date_filter_1']['table'] = 'node'; $handler->display->display_options['filters']['date_filter_1']['field'] = 'date_filter'; $handler->display->display_options['filters']['date_filter_1']['relationship'] = 'uid'; $handler->display->display_options['filters']['date_filter_1']['exposed'] = TRUE; $handler->display->display_options['filters']['date_filter_1']['expose']['operator_id'] = 'date_filter_1_op'; $handler->display->display_options['filters']['date_filter_1']['expose']['label'] = 'Date (node)'; $handler->display->display_options['filters']['date_filter_1']['expose']['operator'] = 'date_filter_1_op'; $handler->display->display_options['filters']['date_filter_1']['expose']['identifier'] = 'date_filter_1'; $handler->display->display_options['filters']['date_filter_1']['expose']['remember_roles'] = array( 2 => '2', 1 => 0, 24 => 0, 6 => 0, 5 => 0, 25 => 0, ); $handler->display->display_options['filters']['date_filter_1']['form_type'] = 'date_popup'; $handler->display->display_options['filters']['date_filter_1']['date_fields'] = array( 'node.created' => 'node.created', );
/* Display: Page */ $handler = $view->new_display('page', 'Page', 'page'); $handler->display->display_options['defaults']['hide_admin_links'] = FALSE; $handler->display->display_options['path'] = 'total'; $translatables['total'] = array( t('Master'), t('total'), t('more'), t('Apply'), t('Reset'), t('Sort by'), t('Asc'), t('Desc'), t('Items per page'), t('- All -'), t('Offset'), t('« first'), t('‹ previous'), t('next ›'), t('last »'), t('nodes'), t('Number of Stories Posted'), t('Author uid'), t('Date (node)'), t('Page'), );