dhis2-users team mailing list archive

[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