Aggregating from weeks to months will always be approximate so these anomalies will happen. Maybe some clever pro-rata scaling can be done.
On 15 June 2013 10:39, Ola Hodne Titlestad <ol...@ifi.uio.no> wrote: > Not very related, but one issue with weeks that came up in Uganda recently > is that monthly aggregates of the reporting rates of weekly datasets got > above 100% for months with 5 weeks. Seems the aggregation code here assumes > 4 weeks per month throughout the year and with 5 weeks of reported datasets > for some months the reporting rate got too high. > > Ola > ------ > On 15 Jun 2013 11:24, "John Lewis" <johnlewis.h...@gmail.com> wrote: > >> Hi all, >> Defining week start and end date is quite complicated. I had the same >> issue in bangladesh. The point also how do we aggregate it to month. >> Technically we break the data of a week which fall in two month, which is >> not a good idea. >> Instead of rewriting.entire aggregation engine would it better to define >> as daily data set. Since we collect data once a week we can use daily data >> set and modify data enter screen to show weekly end date. >> On 15 Jun 2013 03:40, "Johannes Schnitzler" <schnitzl...@gmail.com> >> wrote: >> >>> Dear All, >>> >>> How I have solved the issue in another application, also used for >>> Cambodia, is that I'm allowing to define the start day of the week e.g. >>> Monday, Tuesday, Wednesday .... as well as how many days "touching the new >>> year" are needed to qualify a week to be counted as week 1 of the new year. >>> This is part of the setting of the application and is used to calculate it >>> on the fly e.g. for data entry date / week selection. I have written the >>> code for this in R (bad code... but it is working). This allows to deal >>> with a lot of countries. >>> >>> For ISO it is 4 days to qualify for the new year and the start day >>> depends on the country, >>> For Cambodia it is 1 day and start day is Wednesday. >>> >>> As in DHIS I'm storing the period type daily weekly monthly .... >>> And for the actual date I'm storing always start date, end date of the >>> period and in addition the Year and the TIme unit.. >>> For weekly data: start date, end date, Week Number, Year of the week >>> (which might be of course be different from the Year of the first day of >>> the week for the first and last week of the year). >>> For daily data: start date, end date (which is of course the same), day >>> number in year, Year >>> For monthly data: start date, end date, month number, Year >>> .... >>> >>> In this case one has all freedom to combine data sets from different >>> "week definitions" as one can decide later on which week calculation to be >>> applied across the piece based on the start date of the week knowing that >>> the week counting might be off for some of the countries for a few days. >>> But this is the best what we can do I assume ... >>> >>> Best regards, >>> >>> Johannes >>> >>> >>> On 14 June 2013 19:08, Knut Staring <knu...@gmail.com> wrote: >>> >>>> Will have to investigate and get back to you >>>> >>>> Sent from my mobile >>>> On Jun 14, 2013 6:06 PM, "Bob Jolliffe" <bobjolli...@gmail.com> wrote: >>>> >>>>> how do they determine which day is day 1 of week 1? >>>>> >>>>> >>>>> On 14 June 2013 17:52, Knut Staring <knu...@gmail.com> wrote: >>>>> >>>>>> For my purposes, that's really all I know, and for my requirements it >>>>>> will be exactly parallel to countries that require Monday instead of >>>>>> Sunday. >>>>>> >>>>>> But certainly the Nepali, Ethiopian and several others have more >>>>>> complex requirements, which I think partly must be treated as separate >>>>>> cases. >>>>>> >>>>>> >>>>>> On Fri, Jun 14, 2013 at 5:42 PM, Bob Jolliffe >>>>>> <bobjolli...@gmail.com>wrote: >>>>>> >>>>>>> Explain the Cambodian calendar a bit more. I am sure there is more >>>>>>> to it than when the weeks start. Or is that it? >>>>>>> >>>>>>> >>>>>>> On 14 June 2013 17:35, Knut Staring <knu...@gmail.com> wrote: >>>>>>> >>>>>>>> Thanks Jason and Bob. >>>>>>>> >>>>>>>> Unfortunately, this seems to be a pressing requirement in several >>>>>>>> countries >>>>>>>> >>>>>>>> I think one simplification that could be justified would be to have >>>>>>>> only one week type in one DHIS2 instance. Thus, the exact meaning of >>>>>>>> 2012W25 is defined by looking at the FIRSTDAYOFWEEK setting in the >>>>>>>> particular db (which probably should be displayed on the About DHIS 2 >>>>>>>> page. >>>>>>>> >>>>>>>> Of course, that does not solve interoperability issues (but rather >>>>>>>> it deteriorate through obfuscation), but I think it is reasonable to >>>>>>>> think >>>>>>>> that everyone in Cambodia uses weeks starting on Wednesdays. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Fri, Jun 14, 2013 at 5:29 PM, Bob Jolliffe < >>>>>>>> bobjolli...@gmail.com> wrote: >>>>>>>> >>>>>>>>> Weeks are as we all know something of a headache. What we have >>>>>>>>> defined currently in DHIS2, as Jason points out, is the ISO standard >>>>>>>>> week, >>>>>>>>> which even itself is something of a headache. >>>>>>>>> >>>>>>>>> I suspect that to incorporate all the variety which is called for >>>>>>>>> (Wednesday week starts is the most exotic I've seen to date! But >>>>>>>>> there are >>>>>>>>> also Islamic calendar issues, Ethiopian/Amharic calendar, Monday vs >>>>>>>>> Sunday >>>>>>>>> starts etc) we might need to zoom right out to define a generic >>>>>>>>> repeating >>>>>>>>> period with rules around starting and stopping. But it could get >>>>>>>>> quite >>>>>>>>> complicated. Two immediate issues which come to mind >>>>>>>>> (i) we need a string representation of periods. So 2010W23 has a >>>>>>>>> particular meaning in terms of the ISO week number. How to >>>>>>>>> differentiate >>>>>>>>> this from a week which starts on a Wednesday (and which day of the >>>>>>>>> year >>>>>>>>> would be day 1 of week 1?); >>>>>>>>> (ii) how to aggregate along the time axis ie, weeks->months->years >>>>>>>>> >>>>>>>>> Its something which needs to be done, but I am not at all clear >>>>>>>>> what the correct design approach would be. Would be interested to >>>>>>>>> hear >>>>>>>>> people's thoughts. >>>>>>>>> >>>>>>>>> Bob >>>>>>>>> >>>>>>>>> >>>>>>>>> On 14 June 2013 17:12, Knut Staring <knu...@gmail.com> wrote: >>>>>>>>> >>>>>>>>>> Devs: Is this something which could be targeted for 2.13? >>>>>>>>>> >>>>>>>>>> Knut >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Mon, May 13, 2013 at 6:18 PM, Jason Pickering < >>>>>>>>>> jason.p.picker...@gmail.com> wrote: >>>>>>>>>> >>>>>>>>>>> Currently not. This has come up before, but for now, ISO weeks >>>>>>>>>>> are what has been implemented. >>>>>>>>>>> >>>>>>>>>>> http://en.wikipedia.org/wiki/ISO_week_date >>>>>>>>>>> >>>>>>>>>>> Regards, >>>>>>>>>>> Jason >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Mon, May 13, 2013 at 6:54 PM, Paulo Grácio < >>>>>>>>>>> pgra...@criticalsoftware.com> wrote: >>>>>>>>>>> >>>>>>>>>>>> Hi, **** >>>>>>>>>>>> >>>>>>>>>>>> ** ** >>>>>>>>>>>> >>>>>>>>>>>> Is there a way to define week start day for Weekly periods?**** >>>>>>>>>>>> >>>>>>>>>>>> ** ** >>>>>>>>>>>> >>>>>>>>>>>> Regards,**** >>>>>>>>>>>> >>>>>>>>>>>> Paulo Grácio**** >>>>>>>>>>>> >>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-users >>>>>>>>>>>> Post to : dhis2-users@lists.launchpad.net >>>>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>>>>>>>>> More help : https://help.launchpad.net/ListHelp >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> _______________________________________________ >>>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-users >>>>>>>>>>> Post to : dhis2-users@lists.launchpad.net >>>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>>>>>>>> More help : https://help.launchpad.net/ListHelp >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Knut Staring >>>>>>>>>> Dept. of Informatics, University of Oslo >>>>>>>>>> +4791880522 >>>>>>>>>> http://dhis2.org >>>>>>>>>> >>>>>>>>>> _______________________________________________ >>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-users >>>>>>>>>> Post to : dhis2-users@lists.launchpad.net >>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>>>>>>> More help : https://help.launchpad.net/ListHelp >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Knut Staring >>>>>>>> Dept. of Informatics, University of Oslo >>>>>>>> +4791880522 >>>>>>>> http://dhis2.org >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Knut Staring >>>>>> Dept. of Informatics, University of Oslo >>>>>> +4791880522 >>>>>> http://dhis2.org >>>>>> >>>>> >>>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~dhis2-users >>>> Post to : dhis2-users@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : dhis2-users@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-users >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-users@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
