dhis2-users team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

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.hisp@xxxxxxxxx> 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" <schnitzlerj@xxxxxxxxx>
> 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 <knutst@xxxxxxxxx> wrote:
>>
>>> Will have to investigate and get back to you
>>>
>>> Sent from my mobile
>>> On Jun 14, 2013 6:06 PM, "Bob Jolliffe" <bobjolliffe@xxxxxxxxx> wrote:
>>>
>>>> how do they determine which day is day 1 of week 1?
>>>>
>>>>
>>>> On 14 June 2013 17:52, Knut Staring <knutst@xxxxxxxxx> 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 <bobjolliffe@xxxxxxxxx>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 <knutst@xxxxxxxxx> 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 <bobjolliffe@xxxxxxxxx
>>>>>>> > 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 <knutst@xxxxxxxxx> 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.pickering@xxxxxxxxx> 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 <
>>>>>>>>>> pgracio@xxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>>>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> _______________________________________________
>>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>>>>>> 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@xxxxxxxxxxxxxxxxxxx
>>>>>>>>> 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@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>