Hi all,
As of 2.27 the aggregation from weeks to months in analytics was changed: weeks are attributed to the month where they have four days or more. But we are experiencing some unexpected behavior in 2.28. As an example here I paste a row extracted from _periodstructure table in demo server:
(We have checked that period type is set to ISO8601, so Monday is the first day in the week)
periodid
iso
daysno
startdate
enddate
daily
weekly
weeklywednesday
weeklythursday
weeklysaturday
weeklysunday
monthly
bimonthly
quarterly
sixmonthly
sixmonthlyapril
yearly
financialapril
financialjuly
financialoct
890450
2017W13
7
2017-03-28
2017-04-03
null
2017W13
null
null
null
null
201704
201702B
2017Q2
2017S1
2017AprilS1
2017
2017April
2016July
2016Oct
Here there are two things:
-
2017W13 is actually from 2017-03-27 to 2017-04-02 in ISO8601.
-
This week is attributed to April, which would be wrong even if the week were from 2017-03-28 to 2017-04-03.
Is it the expected behavior? Maybe am I missing some configuration parameter?
Thanks in advance,
Víctor