Using Xtraction: 15.2.5863.1325
This was recently brought to my attention from a report designer, something that was overlooked in previous reporting and wasn't noticed until now.
When using the Fixed Date filter in a time component, and setting the time interval as 1 year (example) - Xtraction appears to start counting the year from the month that was selected, until it hits 12 months and then groups them all together for the year.
Fixed date filter starting 1-JUN-14, ending 1-JUN-16.
Xtraction will report 12 months worth of records between June 2014, to June 2015 and group them together as June 2014. Behavior that I would have expected if I asked for "12 Months" but not "1 Year".
If I were to "View Records" for 2014, it will show me 12 months of records between June 2014 and June 2015. Likewise, 2015 will show me records from June 2015 to June 2016.
More so, despite selecting the end date as 1-JUN-16 it doesn't stop there. 2016's records continue on from 01-JUN-16 until today. Like it wants to continue on with 2016 and get all 12 months worth.
Is this expected behavior from Xtraction? Is it by design?