Hi Ola, Okay I will try that and will let you know of the results.
Regards, Baakai On Thu, Mar 26, 2015 at 5:06 PM, Ola Hodne Titlestad <[email protected]> wrote: > Hi Baakai, > > This sounds like a caching issue to me. What I mean is that the system or > bowser, in order to boost performance remembered the query > (indicator,period, orgunit) and gave you the same result from its > memory/cache without actually calculating the values again. > > Can you try with another orgunit or period in the pivot table and see if you > still get non-annualised values for that same indicator? > > If the numerator is monthly and the denominator is yearly the annualised > option will add a factor of 12 to the indicators value, so should be easy > to see whether it works or not. > > Ola > ------ > > On 26 Mar 2015 00:35, "Baakai Kamoriki" <[email protected]> wrote: >> >> Thanks Lars and Ola, >> >> It works! I have set the aggregation operator to "average(sum in org >> unit hierarchy)" on the population data elements. I also noticed that >> even without setting "annualized" to yes, for the indicators it still >> yield the same result in pivot table as to that set to "annualized". >> >> In fact, after setting aggregation operator to "average(sum in org >> unit hierarchy) on the population data element, I went straight to the >> pivot table and run the analysis. It gives me the result but then I >> realized that I have not set the indicator to "annualized". I decided >> to download a copy of the result to excel before I annualized the >> indicator, just to see what would be the difference in the results. >> >> Now having set the indicator to "annualized - yes", I refresh the >> pivot table and run the same indicator again with same period and org >> unit and to my surprise the results were the same? Does that mean that >> we do not have to annualize the indicator if the denominator is set to >> "average(sum in org unit hierarchy). >> >> I did not try it out with data element aggregation operator set to >> "average" instead of "average (sum in org unit hierarchy)". >> >> Anyway, thanks once again for your help. >> >> Regards >> >> >> >> On Tue, Mar 24, 2015 at 6:16 PM, Lars Helge Øverland >> <[email protected]> wrote: >> > Hi Baakai, >> > >> > make sure you set the "aggregation operator" to "average (sum in org >> > unit >> > hierarchy)" on the population data elements. Then set "annualized" to >> > yes >> > for your indicators. >> > >> > regards, >> > >> > Lars >> > >> > >> > On Tue, Mar 24, 2015 at 4:49 AM, Baakai Kamoriki <[email protected]> >> > wrote: >> >> >> >> Dear all, >> >> >> >> Can anyone enlightens on how to generate monthly indicators which uses >> >> yearly population data? >> >> >> >> I had been trying to run pivot table on some health indicator for >> >> Solomon Islands such as watery diarrhoea, ARI to name a few by month >> >> but the pivot table always say no values. In fact these data are >> >> collected on a monthly basis, however our population figures are >> >> yearly? >> >> >> >> Is there a way to do this kind of analysis in DHIS? >> >> >> >> We are currently using version 2.18. >> >> >> >> Many thanks. >> >> >> >> -- >> >> Mrs Baakai Kamoriki >> >> Chief Medical Statistician >> >> HIS Unit/ MOH >> >> Honiara >> >> Solomon Islands >> >> >> >> _______________________________________________ >> >> Mailing list: https://launchpad.net/~dhis2-users >> >> Post to : [email protected] >> >> Unsubscribe : https://launchpad.net/~dhis2-users >> >> More help : https://help.launchpad.net/ListHelp >> > >> > >> >> >> >> -- >> Mrs Baakai Kamoriki >> Chief Medical Statistician >> HIS Unit/ MOH >> Honiara >> Solomon Islands >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp -- Mrs Baakai Kamoriki Chief Medical Statistician HIS Unit/ MOH Honiara Solomon Islands _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
