dhis2-users team mailing list archive

[Robin Martens <martens@xxxxxxx>]

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