Re: [Dhis2-users] Indicator

2014-03-31 Thread Lars Helge Øverland
On Mon, Mar 31, 2014 at 11:54 AM, Knut Staring wrote: > I have a similar requirment, where the weekly disease trend this year > needs to be compared to the average of the 3 previous years. I have done > this with custom javascript but would be nice to have it available > This would be what the

Re: [Dhis2-users] Indicator

2014-03-31 Thread Knut Staring
I have a similar requirment, where the weekly disease trend this year needs to be compared to the average of the 3 previous years. I have done this with custom javascript but would be nice to have it available On 31 Mar 2014 15:04, "Ola Hodne Titlestad" wrote: > Hi Randy, > > To me this sounds l

Re: [Dhis2-users] Indicator

2014-03-31 Thread Lars Helge Øverland
Hi Randy and Kenneth, Jason is correct above. If you need the average consumption you should use the "average" aggregation operator. Note that you can only have one aggregation operator defined per data element. This becomes a problem if you usually want to see the sum of consumption, but for a s

Re: [Dhis2-users] Indicator

2014-03-31 Thread Ola Hodne Titlestad
Hi Randy, To me this sounds like the new surveillance type of validation rules is a better match. Have you looked at that? We would then somehow need to expose those formula values in the Web API somehow, so that they can be used in reports etc. Ola -- 31. mars 2014 09:01 skrev "Wilson,Rand

Re: [Dhis2-users] Indicator

2014-03-31 Thread Kenneth Børtveit
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 : > Hi Jason, > > Can you elaborate and provide us little more info about "D" ! > > Say for example, > eg. Indicator =

Re: [Dhis2-users] Indicator

2014-03-31 Thread Brajesh Murari
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 b

Re: [Dhis2-users] Indicator

2014-03-31 Thread Kenneth Børtveit
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 : > Thank you, I was trying to get a grip on how 'D' works and how I co

Re: [Dhis2-users] Indicator

2014-03-31 Thread Kenneth Børtveit
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 : > 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 m

Re: [Dhis2-users] Indicator

2014-03-31 Thread Jason Pickering
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 aggr

Re: [Dhis2-users] Indicator

2014-03-31 Thread Kenneth Børtveit
Thank you Brajesh, that covers it. 2014-03-31 9:22 GMT+02:00 Brajesh Murari : > 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 o

Re: [Dhis2-users] Indicator

2014-03-31 Thread Brajesh Murari
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

Re: [Dhis2-users] Indicator

2014-03-31 Thread Wilson,Randy
Actually we need to create an indicator that sums the data over the last 3 months and divides by 3 - e.g. average monthly consumption for the past 3 months. Similarly we will need a function to average the number of cases of epidemic prone disease over the past 6 months and then check to see of