← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] Aggregation query builder

 

Hi Channara,

Does creating two data elements solve your issue ?

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

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

> Thank you Tran,
> My situation of using tracker is:
> *Example:* in my DHIS2 system has two organisations is (A, and B) and
> Data Element is HTC(HIV Testing and Counseling) and two organisations work
> with Target Group is organisation: "A" work with target group:
> EW(Entertainment Worker) and organisation: "B" work with target group: MSM
> (Man who sex with man).
>
> So two organisations will track record with different target group but the
> same Data Element is HTC and different organisations in one quarterly.
>
> This formula is the same in two organisations. but the type of tracker
> records is differents. so the value get from aggregate query builder can be
> different.
>
> Thank you
> CHANNARA
>
>
>
> On Tue, Feb 24, 2015 at 1:54 PM, Tran Chau (HISP Vietnam) <
> tran.hispvietnam@xxxxxxxxx> wrote:
>
>> 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