I hate to bump myself but does anybody have any input on this at all? On Thursday, April 10, 2014 11:59:43 AM UTC+12, Tim Uckun wrote: > > I want to do something like this. > > select date_trunc('month', time_stamp), sum(distinct_count) from ( > select date_trunc('week', time_stamp) as time_stamp, count(distinct > field_name) as distinct_count > from blah > group by date_trun('week', time_stamp) > ) > group by date_trunc('month', time_stamp) > > So basically I want to break up the data into weekly chunks and count the > distinct appearances of a value and then sum those up on a per monthly > basis. > > In preparation for that I tried to do the subquery for that which looks > like this > > aggregations: { > by_month: { > date_histogram: { > field: "time_stamp", > interval: "1M", > format: "yyyy-MM-dd HH:mm" > }, > aggregations: { > by_node_mac: { > terms: { > field: "node_mac" > }, > aggregations: { > cardinality: {field: 'device_mac'} > } > > } > } > } > } > } > > but I seem to be getting the wrong answers. I am using fake data which > should give me very low numbers for the cardinality but it actually seems > to be counting the number of rows not the number of distinct items. The > numbers are outrageously high. > > I tried a precision threshold of 1000 and 100 but it seems to make no > difference. > > >
-- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/016b94f6-4b62-4009-83ec-ccef3bfb17f6%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.