dhis2-users team mailing list archive

[Andrei Evguenov <andrei@xxxxxxxxxx>]

Hi,

Is there any way in analytic api to select latest data value for aggregation ? As per example:

orgUnitParent -> child1,child2
dataElement [number] de1
dataSet [monthly] -> de1

dataValue: de1 -> child1 -> 2017-03-01 -> value = 10
dataValue: de1 -> child2 -> 2017-03-01 -> value = 4

At this stage analytic api call for orgUnitParent, dx:de1 ou:orgUnitParent pe:THIS_YEAR ->   "rows": [ [ “de1”, "2017”, “orgUnitParent”, “14" ] ], 14 is good but lets POST another value:

dataValue: de1 -> child2 -> 2017-05-01 -> value = 6

Now analytic api call for orgUnitParent, dx:de1 ou:orgUnitParent pe:THIS_YEAR ->   "rows": [ [ “de1”, "2017”, “orgUnitParent”, “20" ] ], 20 .. sums all data values… we need just sum of the latest values, i.e 16

I have read: https://lists.launchpad.net/dhis2-users/msg13042.html <https://lists.launchpad.net/dhis2-users/msg13042.html> it’s programs/event setup, and the answer didn’t seem to help me.  Reading the documentation I assume there is not LATEST relative period, and currently we have to do the following to get the desired result:

orgUnitGroup -> child1, child2

Analytic api call dx:de1 ou:OU_GROUP:orgUnitGroup pe:THIS_MONTH;LAST_12_MONTH -> "rows": [[ “de1”, "201703”, “child1”, “10” ],  [ “de1”, "201703”, “child2”, “4” ], [ “de1”, "201705”, “child2”, “6” ]] -> after that our server in between front end and dhis2 instance does the aggregation manual based on latest value for OU.. 

It would be awesome if there was another option since we are using DHIS2 because of it’s aggregation capabilities.

Appreciate your helpful response,

Andrei @ Sussol