Hi Julie,
I am forwarding your question to the appropriate user mailing list.
Just to make sure, did you run Analytics?
Regards,
Knut
···
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
Hi Knut,
Yes I did.
Thank you very much in advance
Julie
···
2017-05-17 16:07 GMT+02:00 Knut Staring knutst@gmail.com:
Hi Julie,
I am forwarding your question to the appropriate user mailing list.
Just to make sure, did you run Analytics?
Regards,
Knut
---------- Forwarded message ----------
From: Julie juvhamme@gmail.com
Date: Wed, May 17, 2017 at 3:44 PM
Subject: Difficulties with the Program Indicators
To: Knut Staring knutst@gmail.comHi,
I am using the Event tracker of DHIS2 for a project.
In a nutshell, I already set up the program and programs stages. I also
run the Analytics and I have will all the data needed in my program.
Indeed, while I am using the Event report with the data element (and not
the indicators), everything is fine and I can see the pivot tables with
the data.
Now I am trying to create Indicators trough the program and everything
seemed ok (the formula, etc.). Except that when I am trying to use the
indicator in a pivot table, the table appears but with no data inside.
So what could be the problem with the indicators and how can I fix it?
Is it a problem of configuration? Formula? …
Many thanks.
Julie
–
This message was sent from Launchpad by
Julie (https://launchpad.net/~juvhamme)
using the “Contact this team’s admins” link on the DHIS 2 Users team page
(https://launchpad.net/~dhis2-users).
For more information see
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
–
Julie Vanhamme
Hi,
If everything is ok and your formula is correct but you can’t see the result. I guess you select both program indicator and data elements to show in Pivot table or Event report.
Until now, DHIS2 only shows data for 1 selection data elements or program indicator. If you only select program indicator to show, but you don’t see result, then you need to check your program indicator formula.
Sincerely,
···
On Wed, May 17, 2017 at 9:25 PM, Julie Vanhamme juvhamme@gmail.com wrote:
Hi Knut,
Yes I did.
Thank you very much in advance
Julie
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
–
Julie Vanhamme
2017-05-17 16:07 GMT+02:00 Knut Staring knutst@gmail.com:
Hi Julie,
I am forwarding your question to the appropriate user mailing list.
Just to make sure, did you run Analytics?
Regards,
Knut
---------- Forwarded message ----------
From: Julie juvhamme@gmail.com
Date: Wed, May 17, 2017 at 3:44 PM
Subject: Difficulties with the Program Indicators
To: Knut Staring knutst@gmail.comHi,
I am using the Event tracker of DHIS2 for a project.
In a nutshell, I already set up the program and programs stages. I also
run the Analytics and I have will all the data needed in my program.
Indeed, while I am using the Event report with the data element (and not
the indicators), everything is fine and I can see the pivot tables with
the data.
Now I am trying to create Indicators trough the program and everything
seemed ok (the formula, etc.). Except that when I am trying to use the
indicator in a pivot table, the table appears but with no data inside.
So what could be the problem with the indicators and how can I fix it?
Is it a problem of configuration? Formula? …
Many thanks.
Julie
–
This message was sent from Launchpad by
Julie (https://launchpad.net/~juvhamme)
using the “Contact this team’s admins” link on the DHIS 2 Users team page
(https://launchpad.net/~dhis2-users).
For more information see
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
–
Em Le Hong
DHIS2 Implementation| **HISP Vietnam **
em.hispvietnam@gmail.com | Skype: em.hispvietnam@gmail.com
Hi Julie,
Would be good if you could share some more details about your program configuration, including how you set up your program indicator.
Are you using event capture (single event data) or tracker capture (multiple events and registration) for this use cases?
When you say you can see the data in event reports, does that include aggregate values in the ‘aggregated mode’?
If I have trouble with my program indicators, I typically like to use pivot table app to debug. Try to add a few indicators that just count all events or all enrollments and display these at the same time. Will give you an indication of whether event analytics worked or not.
Then for your program indicators where you struggle to get data, try to play with the different options of aggregation, e.g event count, enrollment count etc. You’ll soon see if the issue is related to aggregation or the filter.
Ola
···
On 17 May 2017 17:48, “Em Le Hong” em.hispvietnam@gmail.com wrote:
Hi,
If everything is ok and your formula is correct but you can’t see the result. I guess you select both program indicator and data elements to show in Pivot table or Event report.
Until now, DHIS2 only shows data for 1 selection data elements or program indicator. If you only select program indicator to show, but you don’t see result, then you need to check your program indicator formula.
Sincerely,
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 Wed, May 17, 2017 at 9:25 PM, Julie Vanhamme juvhamme@gmail.com wrote:
Hi Knut,
Yes I did.
Thank you very much in advance
Julie
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
–
Em Le Hong
DHIS2 Implementation| **HISP Vietnam **
em.hispvietnam@gmail.com | Skype: em.hispvietnam@gmail.com
Julie Vanhamme
2017-05-17 16:07 GMT+02:00 Knut Staring knutst@gmail.com:
Hi Julie,
I am forwarding your question to the appropriate user mailing list.
Just to make sure, did you run Analytics?
Regards,
Knut
---------- Forwarded message ----------
From: Julie juvhamme@gmail.com
Date: Wed, May 17, 2017 at 3:44 PM
Subject: Difficulties with the Program Indicators
To: Knut Staring knutst@gmail.comHi,
I am using the Event tracker of DHIS2 for a project.
In a nutshell, I already set up the program and programs stages. I also
run the Analytics and I have will all the data needed in my program.
Indeed, while I am using the Event report with the data element (and not
the indicators), everything is fine and I can see the pivot tables with
the data.
Now I am trying to create Indicators trough the program and everything
seemed ok (the formula, etc.). Except that when I am trying to use the
indicator in a pivot table, the table appears but with no data inside.
So what could be the problem with the indicators and how can I fix it?
Is it a problem of configuration? Formula? …
Many thanks.
Julie
–
This message was sent from Launchpad by
Julie (https://launchpad.net/~juvhamme)
using the “Contact this team’s admins” link on the DHIS 2 Users team page
(https://launchpad.net/~dhis2-users).
For more information see
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
–
Hi Ola,
Thank you very much for your advices. I am a DHIS2 beginner and I guess that I am making some mistakes in the configuration and/or formula. I tried yesterday and I get data in my pivot tables but not the data I need. In only get “2” as I wrote it in my filter (see below). Let me answer to your questions and explain the situation 
I am using “Event capture” as we did a one shot survey and we don’t track the patient.
Program configuration:
-
without registration
-
version: 4
-
Drop-down list
-
other field are empty or have the default configuration
Program indicator set up (I believe that here is the problem and that I am making some mistakes with the formula): -
I have one Data Element as follow : Are you satisfied with the gynecological service? Very satisfied (1), more or less (2) , and not at all (3) (these are the three responses possibles of my DE)
-
I wanted to create an indicator as follow: % of the respondents that say that they are “very satisfied” with the gynecological service.
-
Aggregation type: Average
-
Expression: I only selected my data element divided by the number of event count and then multiple by 100 : (#{qH1SRxSAoWI.AbdjW61ac8I} / V{event_count}) * 100
-
Filter I select my data element == 1 , so it is something like that : #{qH1SRxSAoWI.AbdjW61ac8I} == 2
I guess I am wrong in my formula. Any guidance, solution or advice?
Thank you again very much in advance for your support.
Julie
···
2017-05-18 9:28 GMT+02:00 Ola Hodne Titlestad olati@ifi.uio.no:
Hi Julie,
Would be good if you could share some more details about your program configuration, including how you set up your program indicator.
Are you using event capture (single event data) or tracker capture (multiple events and registration) for this use cases?
When you say you can see the data in event reports, does that include aggregate values in the ‘aggregated mode’?
If I have trouble with my program indicators, I typically like to use pivot table app to debug. Try to add a few indicators that just count all events or all enrollments and display these at the same time. Will give you an indication of whether event analytics worked or not.
Then for your program indicators where you struggle to get data, try to play with the different options of aggregation, e.g event count, enrollment count etc. You’ll soon see if the issue is related to aggregation or the filter.
Ola
Julie Vanhamme
On 17 May 2017 17:48, “Em Le Hong” em.hispvietnam@gmail.com wrote:
Hi,
If everything is ok and your formula is correct but you can’t see the result. I guess you select both program indicator and data elements to show in Pivot table or Event report.
Until now, DHIS2 only shows data for 1 selection data elements or program indicator. If you only select program indicator to show, but you don’t see result, then you need to check your program indicator formula.
Sincerely,
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 Wed, May 17, 2017 at 9:25 PM, Julie Vanhamme juvhamme@gmail.com wrote:
Hi Knut,
Yes I did.
Thank you very much in advance
Julie
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
–
Em Le Hong
DHIS2 Implementation| **HISP Vietnam **
em.hispvietnam@gmail.com | Skype: em.hispvietnam@gmail.com
Julie Vanhamme
2017-05-17 16:07 GMT+02:00 Knut Staring knutst@gmail.com:
Hi Julie,
I am forwarding your question to the appropriate user mailing list.
Just to make sure, did you run Analytics?
Regards,
Knut
---------- Forwarded message ----------
From: Julie juvhamme@gmail.com
Date: Wed, May 17, 2017 at 3:44 PM
Subject: Difficulties with the Program Indicators
To: Knut Staring knutst@gmail.comHi,
I am using the Event tracker of DHIS2 for a project.
In a nutshell, I already set up the program and programs stages. I also
run the Analytics and I have will all the data needed in my program.
Indeed, while I am using the Event report with the data element (and not
the indicators), everything is fine and I can see the pivot tables with
the data.
Now I am trying to create Indicators trough the program and everything
seemed ok (the formula, etc.). Except that when I am trying to use the
indicator in a pivot table, the table appears but with no data inside.
So what could be the problem with the indicators and how can I fix it?
Is it a problem of configuration? Formula? …
Many thanks.
Julie
–
This message was sent from Launchpad by
Julie (https://launchpad.net/~juvhamme)
using the “Contact this team’s admins” link on the DHIS 2 Users team page
(https://launchpad.net/~dhis2-users).
For more information see
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
–
Hi Julie,
I’m not sure for others, but the expression seem not correct. For number it should only 1 equal sign like: #{qH1SRxSAoWI.AbdjW61ac8I} = 2
···
On Fri, May 19, 2017 at 2:00 PM, Julie Vanhamme juvhamme@gmail.com wrote:
Hi Ola,
Thank you very much for your advices. I am a DHIS2 beginner and I guess that I am making some mistakes in the configuration and/or formula. I tried yesterday and I get data in my pivot tables but not the data I need. In only get “2” as I wrote it in my filter (see below). Let me answer to your questions and explain the situation
I am using “Event capture” as we did a one shot survey and we don’t track the patient.
Program configuration:
- without registration
- version: 4
- Drop-down list
- other field are empty or have the default configuration
Program indicator set up (I believe that here is the problem and that I am making some mistakes with the formula):
- I have one Data Element as follow : Are you satisfied with the gynecological service? Very satisfied (1), more or less (2) , and not at all (3) (these are the three responses possibles of my DE)
- I wanted to create an indicator as follow: % of the respondents that say that they are “very satisfied” with the gynecological service.
- Aggregation type: Average
- Expression: I only selected my data element divided by the number of event count and then multiple by 100 : (#{qH1SRxSAoWI.AbdjW61ac8I} / V{event_count}) * 100
- Filter I select my data element == 1 , so it is something like that : #{qH1SRxSAoWI.AbdjW61ac8I} == 2
I guess I am wrong in my formula. Any guidance, solution or advice?
Thank you again very much in advance for your support.
Julie
–
Julie Vanhamme
2017-05-18 9:28 GMT+02:00 Ola Hodne Titlestad olati@ifi.uio.no:
Hi Julie,
Would be good if you could share some more details about your program configuration, including how you set up your program indicator.
Are you using event capture (single event data) or tracker capture (multiple events and registration) for this use cases?
When you say you can see the data in event reports, does that include aggregate values in the ‘aggregated mode’?
If I have trouble with my program indicators, I typically like to use pivot table app to debug. Try to add a few indicators that just count all events or all enrollments and display these at the same time. Will give you an indication of whether event analytics worked or not.
Then for your program indicators where you struggle to get data, try to play with the different options of aggregation, e.g event count, enrollment count etc. You’ll soon see if the issue is related to aggregation or the filter.
Ola
On 17 May 2017 17:48, “Em Le Hong” em.hispvietnam@gmail.com wrote:
Hi,
If everything is ok and your formula is correct but you can’t see the result. I guess you select both program indicator and data elements to show in Pivot table or Event report.
Until now, DHIS2 only shows data for 1 selection data elements or program indicator. If you only select program indicator to show, but you don’t see result, then you need to check your program indicator formula.
Sincerely,
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 Wed, May 17, 2017 at 9:25 PM, Julie Vanhamme juvhamme@gmail.com wrote:
Hi Knut,
Yes I did.
Thank you very much in advance
Julie
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
–
Em Le Hong
DHIS2 Implementation| **HISP Vietnam **
em.hispvietnam@gmail.com | Skype: em.hispvietnam@gmail.com
Julie Vanhamme
2017-05-17 16:07 GMT+02:00 Knut Staring knutst@gmail.com:
Hi Julie,
I am forwarding your question to the appropriate user mailing list.
Just to make sure, did you run Analytics?
Regards,
Knut
---------- Forwarded message ----------
From: Julie juvhamme@gmail.com
Date: Wed, May 17, 2017 at 3:44 PM
Subject: Difficulties with the Program Indicators
To: Knut Staring knutst@gmail.comHi,
I am using the Event tracker of DHIS2 for a project.
In a nutshell, I already set up the program and programs stages. I also
run the Analytics and I have will all the data needed in my program.
Indeed, while I am using the Event report with the data element (and not
the indicators), everything is fine and I can see the pivot tables with
the data.
Now I am trying to create Indicators trough the program and everything
seemed ok (the formula, etc.). Except that when I am trying to use the
indicator in a pivot table, the table appears but with no data inside.
So what could be the problem with the indicators and how can I fix it?
Is it a problem of configuration? Formula? …
Many thanks.
Julie
–
This message was sent from Launchpad by
Julie (https://launchpad.net/~juvhamme)
using the “Contact this team’s admins” link on the DHIS 2 Users team page
(https://launchpad.net/~dhis2-users).
For more information see
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
–
Em Le Hong
DHIS2 Implementation| **HISP Vietnam **
em.hispvietnam@gmail.com | Skype: em.hispvietnam@gmail.com
Hi Julie,
I believe you should make two program indicators and combine them together in the indicator maintenance app.
The aggregation type should be count for both
Program Indicator 1 = very satisfied responses
Expression: event count
filter: dataelement == very satisfied code
Program Indicator 2 = number of surveys
Expression: event count
filter: blank
Combined indicator in indicator maintenance app
Numerator: Program Indicator 1 = very satisfied responses
Denominator: Program Indicator 2 = number of surveys
Type = factor of 100
···
On Fri, May 19, 2017 at 3:00 PM, Julie Vanhamme juvhamme@gmail.com wrote:
Hi Ola,
Thank you very much for your advices. I am a DHIS2 beginner and I guess that I am making some mistakes in the configuration and/or formula. I tried yesterday and I get data in my pivot tables but not the data I need. In only get “2” as I wrote it in my filter (see below). Let me answer to your questions and explain the situation
I am using “Event capture” as we did a one shot survey and we don’t track the patient.
Program configuration:
- without registration
- version: 4
- Drop-down list
- other field are empty or have the default configuration
Program indicator set up (I believe that here is the problem and that I am making some mistakes with the formula):
- I have one Data Element as follow : Are you satisfied with the gynecological service? Very satisfied (1), more or less (2) , and not at all (3) (these are the three responses possibles of my DE)
- I wanted to create an indicator as follow: % of the respondents that say that they are “very satisfied” with the gynecological service.
- Aggregation type: Average
- Expression: I only selected my data element divided by the number of event count and then multiple by 100 : (#{qH1SRxSAoWI.AbdjW61ac8I} / V{event_count}) * 100
- Filter I select my data element == 1 , so it is something like that : #{qH1SRxSAoWI.AbdjW61ac8I} == 2
I guess I am wrong in my formula. Any guidance, solution or advice?
Thank you again very much in advance for your support.
Julie
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
–
Julie Vanhamme
2017-05-18 9:28 GMT+02:00 Ola Hodne Titlestad olati@ifi.uio.no:
Hi Julie,
Would be good if you could share some more details about your program configuration, including how you set up your program indicator.
Are you using event capture (single event data) or tracker capture (multiple events and registration) for this use cases?
When you say you can see the data in event reports, does that include aggregate values in the ‘aggregated mode’?
If I have trouble with my program indicators, I typically like to use pivot table app to debug. Try to add a few indicators that just count all events or all enrollments and display these at the same time. Will give you an indication of whether event analytics worked or not.
Then for your program indicators where you struggle to get data, try to play with the different options of aggregation, e.g event count, enrollment count etc. You’ll soon see if the issue is related to aggregation or the filter.
Ola
On 17 May 2017 17:48, “Em Le Hong” em.hispvietnam@gmail.com wrote:
Hi,
If everything is ok and your formula is correct but you can’t see the result. I guess you select both program indicator and data elements to show in Pivot table or Event report.
Until now, DHIS2 only shows data for 1 selection data elements or program indicator. If you only select program indicator to show, but you don’t see result, then you need to check your program indicator formula.
Sincerely,
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 Wed, May 17, 2017 at 9:25 PM, Julie Vanhamme juvhamme@gmail.com wrote:
Hi Knut,
Yes I did.
Thank you very much in advance
Julie
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
–
Em Le Hong
DHIS2 Implementation| **HISP Vietnam **
em.hispvietnam@gmail.com | Skype: em.hispvietnam@gmail.com
Julie Vanhamme
2017-05-17 16:07 GMT+02:00 Knut Staring knutst@gmail.com:
Hi Julie,
I am forwarding your question to the appropriate user mailing list.
Just to make sure, did you run Analytics?
Regards,
Knut
---------- Forwarded message ----------
From: Julie juvhamme@gmail.com
Date: Wed, May 17, 2017 at 3:44 PM
Subject: Difficulties with the Program Indicators
To: Knut Staring knutst@gmail.comHi,
I am using the Event tracker of DHIS2 for a project.
In a nutshell, I already set up the program and programs stages. I also
run the Analytics and I have will all the data needed in my program.
Indeed, while I am using the Event report with the data element (and not
the indicators), everything is fine and I can see the pivot tables with
the data.
Now I am trying to create Indicators trough the program and everything
seemed ok (the formula, etc.). Except that when I am trying to use the
indicator in a pivot table, the table appears but with no data inside.
So what could be the problem with the indicators and how can I fix it?
Is it a problem of configuration? Formula? …
Many thanks.
Julie
–
This message was sent from Launchpad by
Julie (https://launchpad.net/~juvhamme)
using the “Contact this team’s admins” link on the DHIS 2 Users team page
(https://launchpad.net/~dhis2-users).
For more information see
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
–
Shurajit Dutta
Health Information Consultant
Hi Shurajit,
Thank you very much. It worked! :-)))
I tested it with several data elements and I get just one more issue for one data element.
I have Program Indicator 1 == Not at all satisfied (which was 0)
Expression: event count
filter : dataelement == 0
I also took my Program Indicator 2: number of surveys which was already set up, as it is the same as for the others.
I combined the two indicators and I got 100, as 100%. For all the others, it worked and I got the right percentage.
I dubble checked if my configuration was ok and it is the same logic as with the other. Any idea why I get 100%? And actually, it is supposed to be 0% as none of the respondents selected this option (not at all satisfied).
Is it because of the 0 value?
Thank you
Julie
···
2017-05-19 9:09 GMT+02:00 Shurajit Dutta shurajitdutta@gmail.com:
Hi Julie,
I believe you should make two program indicators and combine them together in the indicator maintenance app.
The aggregation type should be count for both
Program Indicator 1 = very satisfied responses
Expression: event count
filter: dataelement == very satisfied code
Program Indicator 2 = number of surveys
Expression: event count
filter: blank
Combined indicator in indicator maintenance app
Numerator: Program Indicator 1 = very satisfied responses
Denominator: Program Indicator 2 = number of surveys
Type = factor of 100
Julie Vanhamme
On Fri, May 19, 2017 at 3:00 PM, Julie Vanhamme juvhamme@gmail.com wrote:
Hi Ola,
Thank you very much for your advices. I am a DHIS2 beginner and I guess that I am making some mistakes in the configuration and/or formula. I tried yesterday and I get data in my pivot tables but not the data I need. In only get “2” as I wrote it in my filter (see below). Let me answer to your questions and explain the situation
I am using “Event capture” as we did a one shot survey and we don’t track the patient.
Program configuration:
- without registration
- version: 4
- Drop-down list
- other field are empty or have the default configuration
Program indicator set up (I believe that here is the problem and that I am making some mistakes with the formula):
- I have one Data Element as follow : Are you satisfied with the gynecological service? Very satisfied (1), more or less (2) , and not at all (3) (these are the three responses possibles of my DE)
- I wanted to create an indicator as follow: % of the respondents that say that they are “very satisfied” with the gynecological service.
- Aggregation type: Average
- Expression: I only selected my data element divided by the number of event count and then multiple by 100 : (#{qH1SRxSAoWI.AbdjW61ac8I} / V{event_count}) * 100
- Filter I select my data element == 1 , so it is something like that : #{qH1SRxSAoWI.AbdjW61ac8I} == 2
I guess I am wrong in my formula. Any guidance, solution or advice?
Thank you again very much in advance for your support.
Julie
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
–
Shurajit Dutta
Health Information Consultant
Julie Vanhamme
2017-05-18 9:28 GMT+02:00 Ola Hodne Titlestad olati@ifi.uio.no:
Hi Julie,
Would be good if you could share some more details about your program configuration, including how you set up your program indicator.
Are you using event capture (single event data) or tracker capture (multiple events and registration) for this use cases?
When you say you can see the data in event reports, does that include aggregate values in the ‘aggregated mode’?
If I have trouble with my program indicators, I typically like to use pivot table app to debug. Try to add a few indicators that just count all events or all enrollments and display these at the same time. Will give you an indication of whether event analytics worked or not.
Then for your program indicators where you struggle to get data, try to play with the different options of aggregation, e.g event count, enrollment count etc. You’ll soon see if the issue is related to aggregation or the filter.
Ola
On 17 May 2017 17:48, “Em Le Hong” em.hispvietnam@gmail.com wrote:
Hi,
If everything is ok and your formula is correct but you can’t see the result. I guess you select both program indicator and data elements to show in Pivot table or Event report.
Until now, DHIS2 only shows data for 1 selection data elements or program indicator. If you only select program indicator to show, but you don’t see result, then you need to check your program indicator formula.
Sincerely,
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 Wed, May 17, 2017 at 9:25 PM, Julie Vanhamme juvhamme@gmail.com wrote:
Hi Knut,
Yes I did.
Thank you very much in advance
Julie
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
–
Em Le Hong
DHIS2 Implementation| **HISP Vietnam **
em.hispvietnam@gmail.com | Skype: em.hispvietnam@gmail.com
Julie Vanhamme
2017-05-17 16:07 GMT+02:00 Knut Staring knutst@gmail.com:
Hi Julie,
I am forwarding your question to the appropriate user mailing list.
Just to make sure, did you run Analytics?
Regards,
Knut
---------- Forwarded message ----------
From: Julie juvhamme@gmail.com
Date: Wed, May 17, 2017 at 3:44 PM
Subject: Difficulties with the Program Indicators
To: Knut Staring knutst@gmail.comHi,
I am using the Event tracker of DHIS2 for a project.
In a nutshell, I already set up the program and programs stages. I also
run the Analytics and I have will all the data needed in my program.
Indeed, while I am using the Event report with the data element (and not
the indicators), everything is fine and I can see the pivot tables with
the data.
Now I am trying to create Indicators trough the program and everything
seemed ok (the formula, etc.). Except that when I am trying to use the
indicator in a pivot table, the table appears but with no data inside.
So what could be the problem with the indicators and how can I fix it?
Is it a problem of configuration? Formula? …
Many thanks.
Julie
–
This message was sent from Launchpad by
Julie (https://launchpad.net/~juvhamme)
using the “Contact this team’s admins” link on the DHIS 2 Users team page
(https://launchpad.net/~dhis2-users).
For more information see
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
–
Hi Julie
Sorry did you get this fixed?
I believe it may have to do with your code of 0 as dhis2 reserves 0 for no type values. So that option code may not be ready correctly in he filter. Instead of 0 I typically use 99.
···
On May 19, 2017 5:00 PM, “Julie Vanhamme” juvhamme@gmail.com wrote:
Hi Shurajit,
Thank you very much. It worked! :-)))
I tested it with several data elements and I get just one more issue for one data element.
I have Program Indicator 1 == Not at all satisfied (which was 0)
Expression: event count
filter : dataelement == 0
I also took my Program Indicator 2: number of surveys which was already set up, as it is the same as for the others.
I combined the two indicators and I got 100, as 100%. For all the others, it worked and I got the right percentage.
I dubble checked if my configuration was ok and it is the same logic as with the other. Any idea why I get 100%? And actually, it is supposed to be 0% as none of the respondents selected this option (not at all satisfied).
Is it because of the 0 value?
Thank you
Julie
Julie Vanhamme
2017-05-19 9:09 GMT+02:00 Shurajit Dutta shurajitdutta@gmail.com:
Hi Julie,
I believe you should make two program indicators and combine them together in the indicator maintenance app.
The aggregation type should be count for both
Program Indicator 1 = very satisfied responses
Expression: event count
filter: dataelement == very satisfied code
Program Indicator 2 = number of surveys
Expression: event count
filter: blank
Combined indicator in indicator maintenance app
Numerator: Program Indicator 1 = very satisfied responses
Denominator: Program Indicator 2 = number of surveys
Type = factor of 100
On Fri, May 19, 2017 at 3:00 PM, Julie Vanhamme juvhamme@gmail.com wrote:
Hi Ola,
Thank you very much for your advices. I am a DHIS2 beginner and I guess that I am making some mistakes in the configuration and/or formula. I tried yesterday and I get data in my pivot tables but not the data I need. In only get “2” as I wrote it in my filter (see below). Let me answer to your questions and explain the situation
I am using “Event capture” as we did a one shot survey and we don’t track the patient.
Program configuration:
- without registration
- version: 4
- Drop-down list
- other field are empty or have the default configuration
Program indicator set up (I believe that here is the problem and that I am making some mistakes with the formula):
- I have one Data Element as follow : Are you satisfied with the gynecological service? Very satisfied (1), more or less (2) , and not at all (3) (these are the three responses possibles of my DE)
- I wanted to create an indicator as follow: % of the respondents that say that they are “very satisfied” with the gynecological service.
- Aggregation type: Average
- Expression: I only selected my data element divided by the number of event count and then multiple by 100 : (#{qH1SRxSAoWI.AbdjW61ac8I} / V{event_count}) * 100
- Filter I select my data element == 1 , so it is something like that : #{qH1SRxSAoWI.AbdjW61ac8I} == 2
I guess I am wrong in my formula. Any guidance, solution or advice?
Thank you again very much in advance for your support.
Julie
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
–
Shurajit Dutta
Health Information Consultant
Julie Vanhamme
2017-05-18 9:28 GMT+02:00 Ola Hodne Titlestad olati@ifi.uio.no:
Hi Julie,
Would be good if you could share some more details about your program configuration, including how you set up your program indicator.
Are you using event capture (single event data) or tracker capture (multiple events and registration) for this use cases?
When you say you can see the data in event reports, does that include aggregate values in the ‘aggregated mode’?
If I have trouble with my program indicators, I typically like to use pivot table app to debug. Try to add a few indicators that just count all events or all enrollments and display these at the same time. Will give you an indication of whether event analytics worked or not.
Then for your program indicators where you struggle to get data, try to play with the different options of aggregation, e.g event count, enrollment count etc. You’ll soon see if the issue is related to aggregation or the filter.
Ola
On 17 May 2017 17:48, “Em Le Hong” em.hispvietnam@gmail.com wrote:
Hi,
If everything is ok and your formula is correct but you can’t see the result. I guess you select both program indicator and data elements to show in Pivot table or Event report.
Until now, DHIS2 only shows data for 1 selection data elements or program indicator. If you only select program indicator to show, but you don’t see result, then you need to check your program indicator formula.
Sincerely,
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 Wed, May 17, 2017 at 9:25 PM, Julie Vanhamme juvhamme@gmail.com wrote:
Hi Knut,
Yes I did.
Thank you very much in advance
Julie
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
–
Em Le Hong
DHIS2 Implementation| **HISP Vietnam **
em.hispvietnam@gmail.com | Skype: em.hispvietnam@gmail.com
Julie Vanhamme
2017-05-17 16:07 GMT+02:00 Knut Staring knutst@gmail.com:
Hi Julie,
I am forwarding your question to the appropriate user mailing list.
Just to make sure, did you run Analytics?
Regards,
Knut
---------- Forwarded message ----------
From: Julie juvhamme@gmail.com
Date: Wed, May 17, 2017 at 3:44 PM
Subject: Difficulties with the Program Indicators
To: Knut Staring knutst@gmail.comHi,
I am using the Event tracker of DHIS2 for a project.
In a nutshell, I already set up the program and programs stages. I also
run the Analytics and I have will all the data needed in my program.
Indeed, while I am using the Event report with the data element (and not
the indicators), everything is fine and I can see the pivot tables with
the data.
Now I am trying to create Indicators trough the program and everything
seemed ok (the formula, etc.). Except that when I am trying to use the
indicator in a pivot table, the table appears but with no data inside.
So what could be the problem with the indicators and how can I fix it?
Is it a problem of configuration? Formula? …
Many thanks.
Julie
–
This message was sent from Launchpad by
Julie (https://launchpad.net/~juvhamme)
using the “Contact this team’s admins” link on the DHIS 2 Users team page
(https://launchpad.net/~dhis2-users).
For more information see
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
–