I have an Excel table as below. As you can see, there are thre dimensions: Age, Sex and CDV/PTME. However, if I combine all of these, I get 8 fields instead of the 5 I need (because PTME is not broken down by age and sex). I can of course grey out three fields, but it does not make sense to have a field such as PTME F > 14 yrs as the 5th field. Is there a good way to acheive this with categorycombos?
I suppose the alternative is to keep PTME separate and rather create an indicator that sums it with the other 4. Other suggestions?
Number of persons
CDV :F ≤14yr
CDV :M ≤14yr
CDV TOTAL ≤14yr
CDV :F >14 yr
CDV :M >14yr
CDV TOTAL > 14 yr
** PTME**
TOTAL
Hi,
(given that thunderbird renders your example correctly), I would say that "Number of persons" is not really a data element at all. It contains no info, so I would drop it, and rather have two DEs:
CDV, and
PTME
CDV would then have the age and gender categegory combo. The grand total of CDV and PTME can be made with an indicator.
Johan
···
On 18.07.2013 13:16, Knut Staring wrote:
I have an Excel table as below. As you can see, there are thre
dimensions: Age, Sex and CDV/PTME. However, if I combine all of these, I
get 8 fields instead of the 5 I need (because PTME is not broken down by
age and sex). I can of course grey out three fields, but it does not
make sense to have a field such as PTME F > 14 yrs as the 5th field. Is
there a good way to acheive this with categorycombos?
I suppose the alternative is to keep PTME separate and rather create an
indicator that sums it with the other 4. Other suggestions?
*Number of persons*
*CDV :F ≤14yr*
*CDV :M ≤14yr*
*CDV TOTAL ≤14yr*
*CDV :F >14 yr*
*CDV :M >14yr*
*CDV TOTAL > 14 yr*
* PTME*
*TOTAL*
_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help
Actually, I had not fully translated the data element, it’s rather something like
“Number of people counseled and tested for HIV and have received the result”. This is common for all the breakdowns - but it could of course be that we should have
Number of people counseled and tested for HIV and have received the result - CDV
and
Number of people counseled and tested for HIV and have received the result - PTME
as two dataelements.
···
On Thu, Jul 18, 2013 at 1:28 PM, Johan Sæbø johansa@ifi.uio.no wrote:
Hi,
(given that thunderbird renders your example correctly), I would say that “Number of persons” is not really a data element at all. It contains no info, so I would drop it, and rather have two DEs:
CDV, and
PTME
CDV would then have the age and gender categegory combo. The grand total of CDV and PTME can be made with an indicator.
Johan
On 18.07.2013 13:16, Knut Staring wrote:
I have an Excel table as below. As you can see, there are thre
dimensions: Age, Sex and CDV/PTME. However, if I combine all of these, I
get 8 fields instead of the 5 I need (because PTME is not broken down by
age and sex). I can of course grey out three fields, but it does not
make sense to have a field such as PTME F > 14 yrs as the 5th field. Is
there a good way to acheive this with categorycombos?
I suppose the alternative is to keep PTME separate and rather create an
indicator that sums it with the other 4. Other suggestions?
Number of persons
CDV :F ≤14yr
CDV :M ≤14yr
CDV TOTAL ≤14yr
CDV :F >14 yr
CDV :M >14yr
CDV TOTAL > 14 yr
TOTAL
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
–
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org
Yes, I suspected that. The right breakdown for groups, DEs, categories etc is always tricky. I would say there is no "right" way to do it. It all depends on your needs for maintenance and getting totals and subtotals, though DHIS is now so flexible that you can do it most ways without much hassle.
I would probably have made a group for these two DEs ("HIV counseling and testing" or something), and an indicator for the grand total.
···
On 18.07.2013 13:34, Knut Staring wrote:
Actually, I had not fully translated the data element, it's rather
something like
"Number of people counseled and tested for HIV and have received the
result". This is common for all the breakdowns - but it could of course
be that we should have
Number of people counseled and tested for HIV and have received the
result - CDV
and
Number of people counseled and tested for HIV and have received the
result - PTME
as two dataelements.
On Thu, Jul 18, 2013 at 1:28 PM, Johan Sæbø <johansa@ifi.uio.no > <mailto:johansa@ifi.uio.no>> wrote:
Hi,
(given that thunderbird renders your example correctly), I would say
that "Number of persons" is not really a data element at all. It
contains no info, so I would drop it, and rather have two DEs:
CDV, and
PTME
CDV would then have the age and gender categegory combo. The grand
total of CDV and PTME can be made with an indicator.
Johan
On 18.07.2013 13:16, Knut Staring wrote:
I have an Excel table as below. As you can see, there are thre
dimensions: Age, Sex and CDV/PTME. However, if I combine all of
these, I
get 8 fields instead of the 5 I need (because PTME is not broken
down by
age and sex). I can of course grey out three fields, but it does not
make sense to have a field such as PTME F > 14 yrs as the 5th
field. Is
there a good way to acheive this with categorycombos?
I suppose the alternative is to keep PTME separate and rather
create an
indicator that sums it with the other 4. Other suggestions?
*Number of persons*
*CDV :F ≤14yr*
*CDV :M ≤14yr*
*CDV TOTAL ≤14yr*
*CDV :F >14 yr*
*CDV :M >14yr*
*CDV TOTAL > 14 yr*
* PTME*
*TOTAL*
_________________________________________________
Mailing list: https://launchpad.net/~dhis2-__users
<https://launchpad.net/~dhis2-users>
Post to : dhis2-users@lists.launchpad.__net
<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-__users
<https://launchpad.net/~dhis2-users>
More help : https://help.launchpad.net/__ListHelp
<https://help.launchpad.net/ListHelp>
_________________________________________________
Mailing list: https://launchpad.net/~dhis2-__users
<https://launchpad.net/~dhis2-users>
Post to : dhis2-users@lists.launchpad.__net
<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-__users
<https://launchpad.net/~dhis2-users>
More help : https://help.launchpad.net/__ListHelp
<https://help.launchpad.net/ListHelp>
--
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org