dhis2-users team mailing list archive

[Julie Vanhamme <juvhamme@xxxxxxxxx>]

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@xxxxxxxxx>:

> 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@xxxxxxxxx>
> 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@xxxxxxxxxx>:
>>
>>> 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@xxxxxxxxx> 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,
>>>>
>>>> On Wed, May 17, 2017 at 9:25 PM, Julie Vanhamme <juvhamme@xxxxxxxxx>
>>>> wrote:
>>>>
>>>>> Hi Knut,
>>>>>
>>>>> Yes I did.
>>>>>
>>>>> Thank you very much in advance
>>>>> Julie
>>>>>
>>>>> Julie Vanhamme
>>>>>
>>>>>
>>>>>
>>>>> 2017-05-17 16:07 GMT+02:00 Knut Staring <knutst@xxxxxxxxx>:
>>>>>
>>>>>> 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@xxxxxxxxx>
>>>>>> Date: Wed, May 17, 2017 at 3:44 PM
>>>>>> Subject: Difficulties with the Program Indicators
>>>>>> To: Knut Staring <knutst@xxxxxxxxx>
>>>>>>
>>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> 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
>>>>>> https://help.launchpad.net/YourAccount/ContactingPeople
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Knut Staring
>>>>>> Dept. of Informatics, University of Oslo
>>>>>> Norway: +4791880522 <+47%20918%2080%20522>
>>>>>> Skype: knutstar
>>>>>> http://dhis2.org
>>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> *Em Le Hong*
>>>> DHIS2 Implementation| *HISP Vietnam *
>>>> em.hispvietnam@xxxxxxxxx | *Skype:* em.hispvietnam@xxxxxxxxx
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Shurajit Dutta
> Health Information Consultant
>