Aggregation query builder

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

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@gmail.com 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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.”

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@gmail.com 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@gmail.com 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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.”

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@gmail.com 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@gmail.com 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@gmail.com 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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.”

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@gmail.com 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


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Mon, Feb 23, 2015 at 4:53 PM, channara rin rin.channara@gmail.com 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@gmail.com 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@gmail.com 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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.”

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@gmail.com 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@gmail.com 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


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Mon, Feb 23, 2015 at 4:53 PM, channara rin rin.channara@gmail.com 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@gmail.com 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@gmail.com 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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.”

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@gmail.com 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@gmail.com 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@gmail.com 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


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Mon, Feb 23, 2015 at 4:53 PM, channara rin rin.channara@gmail.com 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@gmail.com 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@gmail.com 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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.”

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@gmail.com> 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@gmail.com> > 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@gmail.com> 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@gmail.com> >>> 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@gmail.com> >>>> 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@gmail.com> >>>>> 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@gmail.com >>>>>> > 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@lists.launchpad.net
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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

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@gmail.com 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@gmail.com 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@gmail.com 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@gmail.com 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@gmail.com 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


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Mon, Feb 23, 2015 at 4:53 PM, channara rin rin.channara@gmail.com 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@gmail.com 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@gmail.com 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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.”

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@gmail.com 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@gmail.com 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@gmail.com 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@gmail.com 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@gmail.com 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@gmail.com 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


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Mon, Feb 23, 2015 at 4:53 PM, channara rin rin.channara@gmail.com 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@gmail.com 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@gmail.com 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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.”