← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] Aggregation query builder

 

I am afraid to make trouble in system.

SORRY, I want to verify about aggregate query builder again... because i am
not clear...

IF i make aggregate query builder on one data elements. so the value of
that data element will be created base on each organisation unit and period
that set in data element?

AND what you mean put different formula in the same data element?

Thanks



On Tue, Feb 24, 2015 at 3:37 PM, Tran Chau (HISP Vietnam) <
tran.hispvietnam@xxxxxxxxx> wrote:

> 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


References