Re: [Dhis2-users] [Dhis2-devs] 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-users] [Dhis2-devs] Aggregation query builder details

2016-03-14 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-users] [Dhis2-devs] 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-users] [Dhis2-devs] 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-users] [Dhis2-devs] 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-users] [Dhis2-devs] Aggregation query builder

2015-03-02 Thread Chau Thu Tran
Hi Channara, Aggregation query builder doesn't have if-condition Tran Chau On Mar 2, 2015 4:30 PM, "channara rin" wrote: > Hi DHIS2 family, > Do you know Aggregation query builder has if-condition? > > Thanks > CHANNARA > > ___ > Mailing list: https:

Re: [Dhis2-users] [Dhis2-devs] 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-users] [Dhis2-devs] 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-users] [Dhis2-devs] 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-users] [Dhis2-devs] 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-users] [Dhis2-devs] 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-users] [Dhis2-devs] 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-users] [Dhis2-devs] Aggregation Query Builder

2014-08-19 Thread rin.channara
I am tried use DateDiff in demo and also my DHIS2 in my computer. it always display popup message “Run Failed”. example like DateDiff(Birth Date, Enrollment Date) thank you CHANNARA From: Matthieu Pinard (UiO) Sent: ‎Tuesday‎, ‎August‎ ‎19‎, ‎2014 ‎3‎:‎09‎ ‎Evening To: channara rin Cc: DHIS