Dear All, Coming back to the possibility to define the different "type of weeks" in the setting. Does anyone know a library in Java handling this easily? In case this will not be addressed soon in the next versions. What would be the workaround for a given scenario/country - has anyone addressed this already?
Best regards, Johannes On 15 June 2013 18:18, Knut Staring <knu...@gmail.com> wrote: > I'm not sure it is important to aggregate along the time dimension for > weekly data. But it is important to do so spatially, ie upwards in the > hierarchy. > > Sent from my mobile > On Jun 15, 2013 11:36 AM, "Bob Jolliffe" <bobjolli...@gmail.com> wrote: > >> 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 >> >> > _______________________________________________ > 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
