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" <juvha...@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 <shurajitdu...@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 <juvha...@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 <ol...@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.hispviet...@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,
>>>>>
>>>>> On Wed, May 17, 2017 at 9:25 PM, Julie Vanhamme <juvha...@gmail.com>
>>>>> 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 <knu...@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 <juvha...@gmail.com>
>>>>>>> Date: Wed, May 17, 2017 at 3:44 PM
>>>>>>> Subject: Difficulties with the Program Indicators
>>>>>>> To: Knut Staring <knu...@gmail.com>
>>>>>>>
>>>>>>>
>>>>>>> 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@lists.launchpad.net
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>> More help : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> *Em Le Hong*
>>>>> DHIS2 Implementation| *HISP Vietnam *
>>>>> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> 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
>>>>>
>>>>>
>>>
>>> _______________________________________________
>>> 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
>>
>
>
_______________________________________________
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
