← Back to team overview

dhis2-users team mailing list archive

Re: Combination of categories: 3 having a level 1, and 2 of 3 having a level 2

 

Hi Ilias,

>Jason is actually right : Pregnant women should not be counted in > 5 Yrs.
I'll pay attention to this.

I was not really taking a position on  it one way or the other, just to
make you aware of the fact that you should not use categorical data
elements (except very carefully) for data elements whose categories do not
add to a total. If the reporting system is collecting the data that way
(meaning pregnant women are excluded from Female/>5 years) then category
options will work fine. But if the reporting system is not, that is the
case you need to be careful with.

The extreme case of this is with logistics data elements, which are
disaggregated by things like "Quantity ordered", "Quantity received", and
many other category options. If you have several hundred (or thousand) of
commodities, creating each and every "default" data element is rather
painful and inefficient. Using the option for "Skip category total in
reports" in the category combination may be more appropriate for these
types of data elements, where the category options do not add to a total.
You may then need to use other methods (indicators or SQL or whatever) to
calculate "Totals".

Regards,
Jason



On Wed, Dec 11, 2013 at 4:03 PM, Ilias Dine <ilias.dine@xxxxxxxxx> wrote:

> Hi Adebusoye,
>
> I understand the logic. The combination of categories created must have
> been associated first with the data element. And there's actually the
> possibility to enable or disable columns in section grey field... Thank
> you, it makes it possible to handle this case. I guess it is not possible
> to merge the two columns "sex" and that it is essential to choose a type of
> sex for pregnant women in section grey field. I then added a third option
> for sex category that I called "Sex Not Applicable" and repeated the same
> procedure. Except that: 1) I disable "Sex Not Applicable" for < 5 Yrs and >
> 5 Yrs and 2) I disable "Male" and "Female" for Pregnant Women. I will see
> what is the most obvious to use with data entry and data processing.
>
> Jason is actually right : Pregnant women should not be counted in > 5 Yrs.
> I'll pay attention to this.
>
> Kind Regards,
> Ilias
>
>
> 2013/12/10 Adebusoye Anifalaje <busoye@xxxxxxxx>
>
>> Hi Ilias,
>>
>> 1) You create two data element categories (I assume you have already
>> created data element category options). For instance
>>
>>         a) Age/Pregnancy (< 5 Yrs; > 5 Yrs and Pregnant Women)
>>         b) Sex ( Male Female)
>>
>> 2) You create a category combination e.g. Malaria Age/Pregnancy + Sex.
>>
>>         a)Select Age/Pregnancy Category (this should be on top)
>>         b) select Sex Category
>>
>> 3) Create data set sections (you can have a look at the manual for this
>> if you are not familiar with it)
>>         a) At this stage you Pregnancy Column will also have Male/Female
>> designations
>>         b) Use the Section Grey Field Management option to disable the
>> Male column from Pregnancy.
>>
>> If you are still unclear about how to go about any of the steps, I will
>> be happy to help clarify.
>>
>> Regards,
>>
>> Busoye
>>
>>
>>
>>
>> On 10 Dec 2013, at 19:55, Ilias Dine <ilias.dine@xxxxxxxxx> wrote:
>>
>> > Hi,
>> >
>> > I'm facing this problem with the definition of categories of a data
>> element. It is the total number of confirmed cases of malaria which is in
>> our system divided into 3 categories :
>> >
>> > 1. Less than 5 years
>> > 2. More than 5 years
>> > 3. Pregnant women.
>> >
>> > The problem is that the categories "less than 5 years" and "more than 5
>> years" are in turn divided into sub-categories "Male" and "Female", while
>> the category "Pregnant women" does not have this subdivision.
>> >
>> > Is there a way to handle this situation ?
>> >
>> > Best Regards,
>> > Ilias
>> > _______________________________________________
>> > 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
>
>

Follow ups

References