Woot! Sounds like we made progress!
As for collecting historic data, what you'll need to do is change your filter to account for the date. To do that, instead of saying Date Created between 1/1/2017 and 12/31/2017, change it to Date Created At or after 1/1/2017 00:00:00 [and] Date Created Before Tomorrow.
When you do that, as the historic collection iterates over each date, it will plug in midnight of the collection date in as "Tomorrow".
That should get you the data you need in a historic collection.
[Edit:]
Just to expand on what I typed above because it might look a bit arcane, when you run a historic collection, what PA does is iterate over each date that the collection runs for; for example, the past three months. It will run a collection for May 15, then May 16, then May 17, and so on, up through August 14.
For each date, it will generate a collection period start and collection period end. For May 15, the collection period start will be 2017-05-15 00:00:00, and the collection period end will be 2017-05-15 23:59:59. For July 3, the collection period start will be 2017-07-03 00:00:00, and the collection period end will be 2017-07-03 23:59:59. And so on.
When the collection actually happens, all dates and times are calculated relative to the collection period, not the current date. If you have dates hard-coded in the condition, such as between 2017-01-01 00:00:00 and 2017-12-31 23:59:59, then the collection period will be ignored, and all of your numbers will be the same (the current value).
If, on the other hand, you use a relative date, such as "Today", "Tomorrow", or the like, then the condition will apply to the date/time relative to the collection period. That's why when you use "Date Created At or after 2017-01-01 00:00:00 [and] Date CreatedBefore Tomorrow" as your condition instead of the between condition you were using, what happens is that the collector says, "Query for anything created at or after 2017-01-01 00:00:00 relative to my current collection period", which is 2017-01-01 00:00:00 since that's a literal, static value, "and created at or before Tomorrow relative to my current collection period", which, for July 3 for example, would be before midnight on July 4.
The end result will be the number of records opened at or after 2017-01-01 00:00:00 and before 2017-07-04 00:00:00 (that is, through 2017-07-03 23:59:59). On May 17, the effective range would be anything opened at or after 2017-01-01 00:00:00 and before 2017-05-18 00:00:00 (that is, through 2017-05-17 23:59:59). And so on.
Hope this helps!
--Dennis R
