dhis2-users team mailing list archive

[Kenneth Børtveit <kenneth.bortveit@xxxxxxxxx>]

Thank you, I was trying to get a grip on how 'D' works and how I could use
it.


2014-03-31 10:01 GMT+02:00 Jason Pickering <jason.p.pickering@xxxxxxxxx>:

> Hi.
>
> Just a minor clarification, in that "D" will return the current number of
> days in a given period, not necessarily a given month.
>
> Lets say you collect data monthly. When you look at monthly aggregated
> data, the "D" will always equal to the number of days the month. However,
> if you look at aggregated quarterly data, then you will get "31+28+31" for
> quarter one as the denominator, and the aggregate total for the numerator
> (for instance).
>
> So, if you collect your data quarterly, you will get the number of days in
> a quarter. However, if you collect your data monthly, and want the number
> of days in the preceding, current, and next months, then you will not be
> able to use "D".
>
> Regards,
> Jason
>
>
>
> On Mon, Mar 31, 2014 at 9:22 AM, Brajesh Murari <brajesh.murari@xxxxxxxxx>wrote:
>
>> eg. Indicator =  ( Data Element  / (D * 3) )
>>
>> Here D indicates number of days in current month.
>>
>> ie. if number of days in current month == 30
>> than or (D+D+D) or (D*3) will return 90
>>
>> Similarly, if number of days in current month == 31
>> than or (D+D+D) or (D*3) will return 93
>>
>> Similarly, if number of days in current month == 29 ( ie. in leap year )
>> than or (D+D+D) or (D*3) will return 87
>>
>> In present scenario, there is no way to define the indicator so that 'D'
>> would always be the last 3 months.
>> We can define indicator with addition (+) or multiplication (*)
>>  mathematical operators with combination
>> of 'D' for representing approx 3 months' total days count, but not last
>> three months' total day count.
>>
>> Keneeth, i think you are looking for D or mathematical expression with D
>> such that it should return exactly last
>> three months' total day count !
>>
>> Regards
>> Brajesh Murari
>>
>>
>> P please consider the environment before printing this email
>>
>>   On Monday, 31 March 2014 12:14 PM, Kenneth Børtveit <
>> kenneth.bortveit@xxxxxxxxx> wrote:
>>   Alright, thank you. It solves the problem in a way.
>>
>> I was looking for a way to define the indicator so that 'D' would allways
>> be the last 3 months, is that possible?
>>
>>
>> 2014-03-31 8:20 GMT+02:00 Jason Pickering <jason.p.pickering@xxxxxxxxx>:
>>
>> You can use the special paramater "D" which will give you the number of
>> days in the period in question. Is this what you want to achieve?
>>
>> Regards,
>> Jason
>>
>>
>>
>> On Mon, Mar 31, 2014 at 8:13 AM, Kenneth Børtveit <
>> kenneth.bortveit@xxxxxxxxx> wrote:
>>
>> Hi!
>>
>> I am trying to make an indicator that aggregates a dataelement over a
>> month and divides it by the number of days in the last 3 months.
>>
>> Does anybody have any advice?
>>
>> Best regards,
>> Kenneth Børtveit
>>
>> _______________________________________________
>> 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
>>
>>
>>
>