dhis2-users team mailing list archive

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

My understanding is that 'D' is selected where you use the indicator.
It just counts the days in the period were we use the indicator.


2014-03-31 10:27 GMT+02:00 Brajesh Murari <brajesh.murari@xxxxxxxxx>:

> Hi Jason,
>
> Can you elaborate and provide us little more info about "D" !
>
> Say for example,
> eg. Indicator =  ( ("Data Element A" + "Data Element B")  / D )
>
> Here data for "Data Element A" is collected monthly and data for "Data
> Element B" is collected
> quarterly, than in this use case what would be the value for "D" in above
> indicator ?
>
> Does its value would be total number of days in current monthly period or
> total
> number of days in quarterly period !
>
> Please elaborate little more about "D" because it is still not that much
> clear.
>
> Regards
> Brajesh Murari
>
>
> P please consider the environment before printing this email
>
>   On Monday, 31 March 2014 1:38 PM, Kenneth Børtveit <
> kenneth.bortveit@xxxxxxxxx> wrote:
>  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
>
>
>
>
>
>
>