dhis2-users team mailing list archive

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