| Thread Previous • Date Previous • Date Next • Thread Next |
Randy: I think if we make the data element aggregation type = 'average' we can just select the period and we will have our result, given that the data element is collected monthly. 2014-03-31 10:08 GMT+02:00 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 >>> >>> >>> >> >
| Thread Previous • Date Previous • Date Next • Thread Next |
