Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder details

2016-03-26 Thread Hannan Khan
Dear Lars I am agreed with Dipali and like her we are using aggregated query builder to populate aggregated data sets. So, please consider to keep this in future releases until and unless we find a suitable alternative. Regards Hannan Khan HISP Bangladesh On Tue, Mar 15, 2016 at 12:43 AM, Dipa

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder details

2016-03-15 Thread Dipali Sahu
Hi Lars If not further work on the Aggregation query builder feature, *please don't remove it*. We actually find it very useful and is critical to our workflow. For example, we need to get Total patients seen in a facility. Now with queries the user can see total figures, plus when needed segregat

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder details

2016-03-14 Thread Lars Helge Øverland
Hi there, in fact, aggregation query builder is already scheduled to be removed in version 2.23 and will be replaced by program indicators. Admittedly there are a few cases where persisted aggregate event data could be useful, however we think that generating the aggregate values "on the fly" will

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder details

2016-03-13 Thread Uddin Fatema
Dear All, We are facing same problem create an Aggregation query builder details as sum of data element value I put everything but it comes to Data element for sum/average/min/max ** **and try to select I can’t find anything and this field is* mandatory and the data aggregation data element and

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder details

2016-01-05 Thread Ese Egerega
Dear All, Am riding on Nami's question on aggregate query builder. I would like to know if there is a work around since the dropdown for "Data element for sum/average/min/max*" is not working in dhis2.21* We have a data element in tracker which records the quantity of drugs dispensed to patients

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

2015-03-02 Thread Sam Kasozi
Hi Channara, While it might not have an explicit 'IF', with the help of: 'AND', 'OR', '==NULL', '!=NULL' and other logical operators, most if not all scenarios of the IF - Condition can be evaluated especially since the goal is to aggregate a value only if a specific condition holds. i.e if( *Reg

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

2015-02-24 Thread channara rin
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 elem

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

2015-02-24 Thread Tran Chau (HISP Vietnam)
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 wrote: > Thank you Tran, > My situation of using tracker is: > *Example:* in my DHIS2 system has two organisations is (A

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

2015-02-24 Thread channara rin
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

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

2015-02-23 Thread Tran Chau (HISP Vietnam)
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 th

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

2015-02-23 Thread channara rin
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.

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

2015-02-23 Thread Tran Chau (HISP Vietnam)
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

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

2015-02-23 Thread channara rin
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 wrote: > I did like that, but wonder has error. Let me try another data element > first, i will inform you soon... >

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

2015-02-23 Thread channara rin
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 wrote: > Hi Channara, > The data element should be assigned to a different data set. > In other wards, you can have the same dat

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

2015-02-23 Thread Emma Kassy
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 wrote: > Hi all DHIS2, > I wonder can i make aggregation que