← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Aggregation query builder

 

Hi Channara,

Tracker Aggregation formula is for generating Data Elemment data.
It is not 'Data Set' specific.  It generates the Data Element value for all
Data Sets that the Data Element belong to.
On interface, there is 'Data Set' selector before selecting the Data
Element.
This does not limit the Data Set that we are going to generate the Data
Element value.
It is only used for searching/selecting the Data Element, regardless of the
Data Set we are going to generate the value.
We know that it is confusing, because there is Data Set selector before
Data Element selection.  I will discuss with DHIS for doing something about
this in future.

For your case, I would suggest creating two (or more) different data
elements if you want different formula for same data element.  Would this
solve your issue?
If not, could you explain to me the detail of different formula you are
trying to apply to different org unit?
So that I understand what you are trying to do and assist you on it.

....................................
Best regards,
Tran Chau

On Tue, Feb 24, 2015 at 12:04 PM, channara rin <rin.channara@xxxxxxxxx>
wrote:

> Hi Tran,
> if like this seem sound, but when i create New aggregate query builder, it
> require select "Data set" and then choose data element, And my DHIS2 system
> is each Dataset has different organisation unit. because each dataset has
> some is the same data element and some is different data element.
>
> On Mon, Feb 23, 2015 at 6:03 PM, Tran Chau (HISP Vietnam) <
> tran.hispvietnam@xxxxxxxxx> wrote:
>
>> Hi Channara,
>>
>> No, we cannot define aggregation query builder for the same data element
>> with different organisation units.
>> Organisation unit is not required in one aggregate query builder formula.
>>
>> When these formulas is run automatically, the system will get tracker
>> data from orgunits and generate aggregate data for each orgunit.
>>
>> Besides, we can run the aggregation query builder formulas by manually.
>> For this functionality, we can choose orgunits where we need to generate
>> aggregate data. Go to *Individual Records > Manual aggregation* to see
>> this function.
>>
>> ...................................
>> Best regards,
>> Tran Chau.
>>
>>
>>
>>
>> On Mon, Feb 23, 2015 at 5:00 PM, channara rin <rin.channara@xxxxxxxxx>
>> wrote:
>>
>>> seem another data element is OK, but why only that data element meet
>>> error? s.th wrong with it?
>>>
>>> any one tell me?
>>>
>>> Thank you
>>> Channara
>>>
>>> On Mon, Feb 23, 2015 at 4:53 PM, channara rin <rin.channara@xxxxxxxxx>
>>> wrote:
>>>
>>>> I did like that, but wonder has error. Let me try another data element
>>>> first, i will inform you soon...
>>>>
>>>> Thank you
>>>> Channara
>>>>
>>>> On Mon, Feb 23, 2015 at 4:48 PM, Emma Kassy <ekassy29@xxxxxxxxx> wrote:
>>>>
>>>>> Hi Channara,
>>>>> The data element should be assigned to a different data set.
>>>>> In other wards, you can have the same data element but in different
>>>>> data sets. That way you will not have an error.
>>>>>
>>>>> On Mon, Feb 23, 2015 at 8:13 AM, channara rin <rin.channara@xxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> Hi all DHIS2,
>>>>>> I wonder can i make aggregation query builder for the same data
>>>>>> element but in different organisation unit?
>>>>>>
>>>>>> When i did, i go the error?
>>>>>> [image: Inline image 1]
>>>>>>
>>>>>> _______________________________________________
>>>>>> 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
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Thank you and Kind Regards
>>>>> *Immarcqulate. A (Emma Kassy) *
>>>>>
>>>>> *"You miss 100% of the shots you don't take."*
>>>>>
>>>>
>>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>

PNG image


Follow ups

References