dhis2-users team mailing list archive

[Jørn Braa <jornbraa@xxxxxxxxx>]

Hi Robin,
in the 'DHIS world' we distinguish between
- data elements, ('data variable', 'count'), which is may be regarded as an
atomic unit / raw piece of data, such as in your case cases of patient
encounters by diagnosed disease and by gender (gender / age group will
typically be defined as dimension of the data element e.g. cases of measles)
and
- indicators, which may be any further calculation based on the data
elements, but typically percentages, rates, ..

You define your indicators - as well as your data elements-  in the DHIS
meta data management module.

In your case you define the 'five diseases' as data elements and the
'averages' as indicators.

query builder only then used to aggregate the cases. The averages and other
indicators  are calculated as indicators by DHIS.
You can see the manual about indicators and data elements and meta data
managment

Jørn



On Tue, Jul 22, 2014 at 5:39 PM, Robin Martens <martens@xxxxxxx> wrote:

>   Hi devs and users,
>
>
>
> I've been exploring the aggregation query builder which is effectively the
> link between tracker data and aggregated data. Now I'm a bit stuck on the
> following limits of the system, namely that a single query seems able to
> produce only a single data value, for any combination of orgunit and other
> dimensions there might be. On the other hand, it does calculate (and
> recalculate in case of past data?) this data value for each past period of
> the aggregated data element (monthly, quarterly, or any other). Can anyone
> confirm this is correct?
>
>
>
> If so, imagine the following case: you have the aggregated data element
> "average patient age" which has 3 dimensions: orgunit, gender, and disease
> type. If you happen to have 20 orgunits, 2 genders, and 5 disease types,
> this makes 20x2x5=200 separate aggregation queries to be defined manually
> one by one! And that's only for a single aggregated data element!
>
>
>
> Just wondering if I missed a functionality of the query builder somewhere
> (which I really hope I did).
>
>
>
> Thanks for any feedback,
>
>
>
> Robin
>
> _______________________________________________
> 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
>
>