Generating Monthly Indicators

Support - Assistance technique
1

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

2

Hi,

Make sure your yearly population data elements have aggregation type set to ‘average’.

Also make sure your monthly numerator data elements are part of dataset(s) with period type set to monthly.

Then you should be able to see the monthly indicator values.

Note that you may want to use the option to annualise the indicators values (an option when editing indicators) when using monthly numerators and yearly denominators. This will add a factor of 12 to your monthly values.

Let me know how it goes.

Ola

···

On 24 Mar 2015 04:49, “Baakai Kamoriki” btkamoriki@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

3

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 btkamoriki@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

4

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 <larshelge@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 <btkamoriki@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: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

--
Mrs Baakai Kamoriki
Chief Medical Statistician
HIS Unit/ MOH
Honiara
Solomon Islands

5

Hi Lars

Does this work with atomic indicators?

Best regards,

JM

···

On Tue, Mar 24, 2015 at 4:49 AM, Baakai Kamoriki btkamoriki@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

6

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” btkamoriki@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 > > larshelge@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 btkamoriki@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

7

Hi,

it's a good idea to disable caching while developing your system
configuration. Do it from apps > settings > cache strategy > no cache.

You can turn it back on when you put your system in production.

regards,

Lars

8

Hi all

I am getting an error

409

Conflict

Column index out of bounds:0

When I run the event report Impatient: To ten diagnosis this year. Can you please help

Regards

Simon Muyambo

__________ Information from ESET NOD32 Antivirus, version of virus signature database 11381 (20150326) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

9

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 <olati@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" <btkamoriki@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 >> <larshelge@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 <btkamoriki@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: DHIS 2 Users in Launchpad
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : DHIS 2 Users in Launchpad
>> More help : ListHelp - Launchpad Help
>
>

--
Mrs Baakai Kamoriki
Chief Medical Statistician
HIS Unit/ MOH
Honiara
Solomon Islands

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

--
Mrs Baakai Kamoriki
Chief Medical Statistician
HIS Unit/ MOH
Honiara
Solomon Islands

10

Hi Lars and Ola,

I am not quite clear on what you mean by “disable cache while developing your system configuration”, and then this phrase “turn it back on when you put your system in production”. Note the Bold phrases.

But now I’ve come to understand why we have to annualize (give a factor of 12) indicators when we want to generate monthly indicators while using yearly denominator. I’ve just realized that when indicators are not annualized the figures are so small because they were monthly data against yearly population.

I have tried to run bloody diarrhoea incidence (Not annualized) by month for 2014 selecting all provinces as org units, then i run the same indicator again (this time Annualized), for the same period but for only 4 provinces. Then i just realized that the results were not the same. The results of the annualized indicator were much higher as they have been factored by 12.

Thank you so much for clarifying and pointing out the issue. So it was a cache browser issue then.

So now what do I do. Do I have to keep clearing the browser every time I make mistake of this kind.

For your advice, please.

Regards,

Baakai

···

On Thu, Mar 26, 2015 at 7:25 PM, Lars Helge Øverland larshelge@gmail.com wrote:

–

Hi,

it’s a good idea to disable caching while developing your system configuration. Do it from apps > settings > cache strategy > no cache.

You can turn it back on when you put your system in production.

regards,

Lars

Mrs Baakai Kamoriki
Chief Medical Statistician
HIS Unit/ MOH
Honiara
Solomon Islands

11

Hi Baakai,

Once you have annualized all the indicators which you need to, the effect of caching should resolve itself after the cache expires, which is usually 6AM the next day. What Lars meant was, that if you need to immediately check your results, you should disable caching on the server. Otherwise, the problem will resolve itself.

Regards,

Jason

···

On Thu, Mar 26, 2015 at 7:25 PM, Lars Helge Øverland larshelge@gmail.com wrote:

–
Mrs Baakai Kamoriki
Chief Medical Statistician
HIS Unit/ MOH
Honiara
Solomon Islands

Hi,

it’s a good idea to disable caching while developing your system configuration. Do it from apps > settings > cache strategy > no cache.

You can turn it back on when you put your system in production.

regards,

Lars

12

Thanks Jason,

Now I understand.

Thanks also to Ola and Lars.

Appreciate it very much ALL your assistance.

Kind regards,

Baakai

···

On Sun, Mar 29, 2015 at 9:14 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Baakai,

Once you have annualized all the indicators which you need to, the effect of caching should resolve itself after the cache expires, which is usually 6AM the next day. What Lars meant was, that if you need to immediately check your results, you should disable caching on the server. Otherwise, the problem will resolve itself.

Regards,

Jason

On Mar 29, 2015 8:10 AM, “Baakai Kamoriki” btkamoriki@gmail.com wrote:

Hi Lars and Ola,

I am not quite clear on what you mean by “disable cache while developing your system configuration”, and then this phrase “turn it back on when you put your system in production”. Note the Bold phrases.

But now I’ve come to understand why we have to annualize (give a factor of 12) indicators when we want to generate monthly indicators while using yearly denominator. I’ve just realized that when indicators are not annualized the figures are so small because they were monthly data against yearly population.

I have tried to run bloody diarrhoea incidence (Not annualized) by month for 2014 selecting all provinces as org units, then i run the same indicator again (this time Annualized), for the same period but for only 4 provinces. Then i just realized that the results were not the same. The results of the annualized indicator were much higher as they have been factored by 12.

Thank you so much for clarifying and pointing out the issue. So it was a cache browser issue then.

So now what do I do. Do I have to keep clearing the browser every time I make mistake of this kind.

For your advice, please.

Regards,

Baakai

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

–

On Thu, Mar 26, 2015 at 7:25 PM, Lars Helge Øverland larshelge@gmail.com wrote:

–
Mrs Baakai Kamoriki
Chief Medical Statistician
HIS Unit/ MOH
Honiara
Solomon Islands

Hi,

it’s a good idea to disable caching while developing your system configuration. Do it from apps > settings > cache strategy > no cache.

You can turn it back on when you put your system in production.

regards,

Lars

Mrs Baakai Kamoriki
Chief Medical Statistician
HIS Unit/ MOH
Honiara
Solomon Islands