Evening, I'm trying to break down the data over a year into facets by month; to avoid overlap, I'm using -1MILLI on the start and end dates and using a gap of +1MONTH.
However, it seems like February completely breaks my monthly cycles, leading to incorrect counts further down the line; facets that are after February only go to the 28th of the month, and items in the other two or three days get pushed into the next facet. What's the correct way to do this? An example is shown below, the facet periods go 2008-12-31, 2009-01-31, 2009-02-28 and then from then on only hit 28. [2008-12-31T23:59:59.999Z] => 0 [2009-01-31T23:59:59.999Z] => 0 [2009-02-28T23:59:59.999Z] => 0 [2009-03-28T23:59:59.999Z] => 0 [2009-04-28T23:59:59.999Z] => 0 [2009-05-28T23:59:59.999Z] => 0 [2009-06-28T23:59:59.999Z] => 0 [2009-07-28T23:59:59.999Z] => 0 [2009-08-28T23:59:59.999Z] => 13 [2009-09-28T23:59:59.999Z] => 6 [2009-10-28T23:59:59.999Z] => 2 [2009-11-28T23:59:59.999Z] => 7 [gap] => +1MONTH [end] => 2009-12-28T23:59:59.999Z Thanks for your help, Liam
