← Back to team overview

dhis2-users team mailing list archive

Re: Option set aggregation problem

 

Hi,

I have recreated the issues on the demo application as well. I have created
one program with all the dataelements added some data (See Single Event
Without Registration for Ngelehun CHC under Bo --> Badjia).

I have created aggregation operations for most of the patient data elements
(you can check the formula if it is because of mistakes I made), but still
only the number type data elements are getting aggregated and the
occurrences of each option set are not counted.

Regards,


Seid,


On Wed, Nov 20, 2013 at 11:42 AM, Seid Hussein <seid.hisp@xxxxxxxxx> wrote:

> Hi,
>
> Thanks for the reply. Regarding assigning the program to the user role, I
> didn't do that so I think that's the problem.
>
> But for the aggregation issue, here's what happened. With a sample of what
> I did.
>
> I have a program called --> BEmONC Obstetric complications at hospital
> with only one program stage and it is created as a Single Event Without
> Registration since we want anonymous data.
>
> The program stage has about eight data elements of which three are
> recorded as texts selected from option sets and three are number data
> elements:
>
> Data Elements with Option Sets
>
> Period of pregnancy while coming to hospital -- > Antepartum, Intrapartum
> and postpartum
> Standard diagnosis -- > Abortion complications, APH, PPH, Obstructed labor
> and 4 others
> Mode of Delivery -- > SVD, Assisted delivery and Cesarean section
>
> Number data elements
>
> Number of live births at hospital
> Number of still births at hospital
> Number of neonatal deaths at hospital
>
> At aggregation query builder, for the number data elements, the operator
> is 'Sum of data element values' and for the option sets, we want to count
> the number of occurrences of a specific option from the option set so we
> used 'Number of visit'. Hence for a data element with eight options, we
> have eight aggregation formulas and eight corresponding Number type data
> elements with Aggregation domain. And for the number data elements we have
> one corresponding data element with Aggregation domain.
>
>
> Examples of aggregated data elements:
>
> BEmONC Number of abortion complications at hospital -- > aggregated from
> Abortion complications option in Standard diagnosis
> BEmONC Number of SVD deliveries at hospital -- > aggregated from SVD from
> Mode of Delivery
> BEmONC Total Number of live births at hospital -- > aggregated from Number
> of live births at hospital
>
> Now the problem is, though the aggregation from the Number data elements
> is aggregating fine, the option sets (number of occurrences) are not.
>
> Anyways, I'll try to recreate it on the demo and report more information.
>
>
> Regards,
>
>
> Seid,
>
>
>
> On Wed, Nov 20, 2013 at 11:25 AM, Olav Poppe <olav.poppe@xxxxxx> wrote:
>
>> Hi,
>> regarding not seeing the program on the demo server, have you made sure
>> to assign the program to your user role?
>>
>> Regarding the aggregation queries in 2.13, what exactly do you mean by
>> "not aggregating Individual records with option sets (counting the number
>> of visits).» You want the number of visits where one of the options in the
>> option set was selected? For example, if the option set is Discharged,
>> Transfer, Died you want the number of visits where each of the three
>> options were selected? Could you share the aggregation query formula you
>> are using?
>>
>> Olav
>>
>> 20. nov. 2013 kl. 09:00 skrev Seid Hussein <seid.hisp@xxxxxxxxx>:
>>
>> Hi all,
>>
>> Sorry for writing this again, but I thought may be my description of the
>> problem was not good.
>>
>> We have currently switched to DHIS 2.13 after facing problems with
>> version 2.12 in aggregating Number data types in patient domain (sum of
>> data values) for Single Event Without Registration.
>>
>> However, it seems that although DHIS 2.13 has fixed the problem of not
>> aggregating Number data types with patient domain, is not aggregating
>> Individual records with option sets (counting the number of visits).
>>
>> When I try to recreate the problem on the demo application, I cannot
>> enter records on the program stage because for some reason, the program I
>> assigned to the organisation units is not available in program list (in
>> Individual records).
>>
>> I have tr cleied aring caches, using incognito mode in chrome and private
>> browsing in Firefox.
>>
>> Is it working for anybody else? Can you point to some solutions?
>>  _______________________________________________
>> 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
>>
>>
>>
>

Follow ups

References