dhis2-users team mailing list archive

[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
>
>
>