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 ol...@ifi.uio.no 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 btkamor...@gmail.com 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
larshe...@gmail.com 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 btkamor...@gmail.com
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 : dhis2-users@lists.launchpad.net
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 : dhis2-users@lists.launchpad.net
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 : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp