distinct view

sorry, this is currently not possible.

Well, the question is back again with Views grouping capabilities. But I tried to aggregate on the variables fields, without success unfortunately...

There seem to be loads of "situations" where it is hard to get Views to aggregate distinct lists properly.

Therefore, IMHO, this module should not force people to figure out how to configure this in Views by themselves, but offer distinct lists as an option that actually works. Even if that means running queries outside of views in order to get it to work reliably and as expected...

This is also an issue on D7.

Example and a suggested list option:
Visible, sortable columns with exposed filters for Timestamp (in Y-m-d format, only the day, not hh:mm:ss...), Type, Hostname, and Severity.
Exposed filters for Message, Location and Referrer, without showing those columns (so that we can limit the display per distict IP address to only one row per day...)

Desired result:

• DIstinct view showing sortable columns for Time, Type, Hostname and Severity.

(All identical IP addresses in Hostname should then be grouped and shown maximum ONCE PER DAY for all occurrances where Type and Severity are identical across the entries.)

It's possible to get a view like that. It seems there is a bug, either in this (freaking awesome) module or in views itself, I'm using 7.3.3 currently.
The problem is that it adds the wid column to the query when you add any sorting criteria.
Just start with a new view, select hostname, type and severity as fields, turn on aggregation, add type one more time but set it to "count".
I haven't tried to add filter criteria in that view. Just turn "views query output" on and make sure the "wid" doesn't get added to your query, otherwise the aggregation won't work.
To sort the view just use the table sorting option.
I don't think you can group by date here because it's stored as a timestamp. You can always do a view_query_alter if you have to have it ;-)

This is the view I'm using:

$view = new view;
$view->name = 'watchdog_ip';
$view->description = '';
$view->tag = 'default';
$view->base_table = 'watchdog';
$view->human_name = 'Watchdog IP';
$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'] = 'Watchdog IP';
$handler->display->display_options['group_by'] = TRUE;
$handler->display->display_options['access']['type'] = 'none';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$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'] = '20';
$handler->display->display_options['style_plugin'] = 'table';
$handler->display->display_options['style_options']['columns'] = array(
  'type_2' => 'type_2',
  'hostname' => 'hostname',
  'hostname_1' => 'hostname_1',
  'type_1' => 'type_1',
  'type' => 'type',
);
$handler->display->display_options['style_options']['default'] = 'type';
$handler->display->display_options['style_options']['info'] = array(
  'type_2' => array(
    'sortable' => 0,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'hostname' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => ' ',
    'empty_column' => 0,
  ),
  'hostname_1' => array(
    'sortable' => 0,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'type_1' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'type' => array(
    'sortable' => 1,
    'default_sort_order' => 'desc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
);
$handler->display->display_options['style_options']['override'] = 1;
$handler->display->display_options['style_options']['sticky'] = 0;
$handler->display->display_options['style_options']['empty_table'] = 0;
/* Field: Watchdog: Type */
$handler->display->display_options['fields']['type_2']['id'] = 'type_2';
$handler->display->display_options['fields']['type_2']['table'] = 'watchdog';
$handler->display->display_options['fields']['type_2']['field'] = 'type';
$handler->display->display_options['fields']['type_2']['exclude'] = TRUE;
$handler->display->display_options['fields']['type_2']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['type_2']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['type_2']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['type_2']['alter']['external'] = 0;
$handler->display->display_options['fields']['type_2']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['type_2']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['type_2']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['type_2']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['type_2']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['type_2']['alter']['more_link'] = 0;
$handler->display->display_options['fields']['type_2']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['type_2']['alter']['trim'] = 0;
$handler->display->display_options['fields']['type_2']['alter']['html'] = 0;
$handler->display->display_options['fields']['type_2']['element_label_colon'] = 1;
$handler->display->display_options['fields']['type_2']['element_default_classes'] = 1;
$handler->display->display_options['fields']['type_2']['hide_empty'] = 0;
$handler->display->display_options['fields']['type_2']['empty_zero'] = 0;
$handler->display->display_options['fields']['type_2']['hide_alter_empty'] = 1;
/* Field: Watchdog: Hostname */
$handler->display->display_options['fields']['hostname']['id'] = 'hostname';
$handler->display->display_options['fields']['hostname']['table'] = 'watchdog';
$handler->display->display_options['fields']['hostname']['field'] = 'hostname';
$handler->display->display_options['fields']['hostname']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['hostname']['alter']['make_link'] = 1;
$handler->display->display_options['fields']['hostname']['alter']['path'] = 'watchdog?type=[type_2]&hostname=[hostname]';
$handler->display->display_options['fields']['hostname']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['hostname']['alter']['external'] = 0;
$handler->display->display_options['fields']['hostname']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['hostname']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['hostname']['alter']['target'] = '_blank';
$handler->display->display_options['fields']['hostname']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['hostname']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['hostname']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['hostname']['alter']['more_link'] = 0;
$handler->display->display_options['fields']['hostname']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['hostname']['alter']['trim'] = 0;
$handler->display->display_options['fields']['hostname']['alter']['html'] = 0;
$handler->display->display_options['fields']['hostname']['element_label_colon'] = 1;
$handler->display->display_options['fields']['hostname']['element_default_classes'] = 1;
$handler->display->display_options['fields']['hostname']['hide_empty'] = 0;
$handler->display->display_options['fields']['hostname']['empty_zero'] = 0;
$handler->display->display_options['fields']['hostname']['hide_alter_empty'] = 1;
/* Field: Watchdog: Hostname */
$handler->display->display_options['fields']['hostname_1']['id'] = 'hostname_1';
$handler->display->display_options['fields']['hostname_1']['table'] = 'watchdog';
$handler->display->display_options['fields']['hostname_1']['field'] = 'hostname';
$handler->display->display_options['fields']['hostname_1']['label'] = 'Check IP';
$handler->display->display_options['fields']['hostname_1']['alter']['alter_text'] = 1;
$handler->display->display_options['fields']['hostname_1']['alter']['text'] = 'check';
$handler->display->display_options['fields']['hostname_1']['alter']['make_link'] = 1;
$handler->display->display_options['fields']['hostname_1']['alter']['path'] = 'http://www.projecthoneypot.org/ip_[hostname_1]';
$handler->display->display_options['fields']['hostname_1']['alter']['absolute'] = 1;
$handler->display->display_options['fields']['hostname_1']['alter']['external'] = 0;
$handler->display->display_options['fields']['hostname_1']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['hostname_1']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['hostname_1']['alter']['target'] = '_blank';
$handler->display->display_options['fields']['hostname_1']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['hostname_1']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['hostname_1']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['hostname_1']['alter']['more_link'] = 0;
$handler->display->display_options['fields']['hostname_1']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['hostname_1']['alter']['trim'] = 0;
$handler->display->display_options['fields']['hostname_1']['alter']['html'] = 0;
$handler->display->display_options['fields']['hostname_1']['element_label_colon'] = 1;
$handler->display->display_options['fields']['hostname_1']['element_default_classes'] = 1;
$handler->display->display_options['fields']['hostname_1']['hide_empty'] = 0;
$handler->display->display_options['fields']['hostname_1']['empty_zero'] = 0;
$handler->display->display_options['fields']['hostname_1']['hide_alter_empty'] = 1;
/* Field: Watchdog: Type */
$handler->display->display_options['fields']['type_1']['id'] = 'type_1';
$handler->display->display_options['fields']['type_1']['table'] = 'watchdog';
$handler->display->display_options['fields']['type_1']['field'] = 'type';
$handler->display->display_options['fields']['type_1']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['external'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['type_1']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['type_1']['alter']['more_link'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['trim'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['html'] = 0;
$handler->display->display_options['fields']['type_1']['element_label_colon'] = 1;
$handler->display->display_options['fields']['type_1']['element_default_classes'] = 1;
$handler->display->display_options['fields']['type_1']['hide_empty'] = 0;
$handler->display->display_options['fields']['type_1']['empty_zero'] = 0;
$handler->display->display_options['fields']['type_1']['hide_alter_empty'] = 1;
/* Field: COUNT(Watchdog: Type) */
$handler->display->display_options['fields']['type']['id'] = 'type';
$handler->display->display_options['fields']['type']['table'] = 'watchdog';
$handler->display->display_options['fields']['type']['field'] = 'type';
$handler->display->display_options['fields']['type']['group_type'] = 'count';
$handler->display->display_options['fields']['type']['label'] = 'Count';
$handler->display->display_options['fields']['type']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['type']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['type']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['type']['alter']['external'] = 0;
$handler->display->display_options['fields']['type']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['type']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['type']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['type']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['type']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['type']['alter']['more_link'] = 0;
$handler->display->display_options['fields']['type']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['type']['alter']['trim'] = 0;
$handler->display->display_options['fields']['type']['alter']['html'] = 0;
$handler->display->display_options['fields']['type']['element_label_colon'] = 1;
$handler->display->display_options['fields']['type']['element_default_classes'] = 1;
$handler->display->display_options['fields']['type']['hide_empty'] = 0;
$handler->display->display_options['fields']['type']['empty_zero'] = 0;
$handler->display->display_options['fields']['type']['hide_alter_empty'] = 1;
$handler->display->display_options['fields']['type']['format_plural'] = 0;

/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page');
$handler->display->display_options['path'] = 'watchdog/ip';

The patch provided in https://drupal.org/node/2017801 should allow distinct mode to work.

Just make sure that "Link this field to its message" is not enabled for the Message field, otherwise the query will add the 'wid' field.