dhis2-devs team mailing list archive

[Barnali Bhaduri <barnali760@xxxxxxxxxxx>]

Dear Tran Chau,
                          Thank you very much for all the help and all the suggestion. Now I am understood the 'Aggregation query builder ' process.
                           After 'Save' the 'Aggregation query builder' there is any automaticresult  generation process.I was try with ' Automated Aggregation'    
                            but the result was not updating.In my project every timeaggregated result will be generated automatically. 


 
Barnali Banerjee


________________________________
 From: Rajib Sengupta <rajibs123@xxxxxxxxx>
To: Tanusree Bag <tanusree.bag@xxxxxxxxx>; Barnali Bhaduri <barnali760@xxxxxxxxxxx> 
Sent: Monday, 15 April 2013 3:02 AM
Subject: Fw: [Dhis2-devs] Fwd: Re: Requirement
 




----- Forwarded Message -----
From: Tran Chau <tran.hispvietnam@xxxxxxxxx>
To: Lars Helge Øverland <larshelge@xxxxxxxxx> 
Cc: DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx> 
Sent: Thursday, April 11, 2013 8:05 PM
Subject: Re: [Dhis2-devs] Fwd: Re: Requirement
 


Dear Barnali,


@Suppose I have one data element Gender,I want to count Total Female and show the result.,
I assume that :

1. Patient data element which you want to define a formula is Patient-Gender. This data element links to  an optionset with defined values as Female, Male, Unknown.
2. The name of your program is P

3. The stage of program P which included patient data value Patient-Gender is S

4. Aggregate data element which you want to put the aggregate result after running this formula is Gender.

5. The name of data set which includes data element Gender is D.

I. To define an aggregate query builder formula, please select menu Maintenance > Persons and Programs > Aggregation Query Builder link on left menu
.
InCreate new aggregation query builder form, 
	* Name - Provide name of query,  this name is usually same with the 
name of aggregate data element, such as Total Female.
	* Dataset - Select dataset D
	* Data element - Gender.
	* Operator - In your case, select the option Number of persons
	* Program - Select program P
	* Program Stage - Select program stageS.
	* Data element for sum/average/min/max - Ignore this field.
	* In Data elements tab: Select data element Patient-Gender
	* Click on button =
	* In Condition section, type 'Female' after = sign

Click Save button.


II. To run this formula, please come to Services > Individual Records > Manual Person Aggregation

1. Select data set D

2. Select the date range. The system will generate period list based on date range and period type of data set D. E.g If data set D has period type is monthly, you select 2013-03-11 --> 2013-04-11, you will have two periods for running are March 2013 and April 2013.

3. Select orgunit where you want want to count Total Female.

4. Click Aggregate and Save button to calculate result and save it as a data value of data element Gender. These data values are calculated by the selected orgunit ( on step 3 ), periods created ( on step 2 ) and data element Gender.

................

Hope this can help you. Please contact me if you have any question.



Best regards,
------------------------------------------------
Châu Thu Trân                                
HISP Viet Nam
Email: tran.hispvietnam@xxxxxxxxx


On Thu, Apr 11, 2013 at 2:44 PM, Lars Helge Øverland <larshelge@xxxxxxxxx> wrote:

---------- Forwarded message ----------
>From: "Barnali Bhaduri" <barnali760@xxxxxxxxxxx>
>Date: Apr 10, 2013 8:35 PM
>Subject: Re: [Dhis2-devs] Requirement
>
To: "Lars Helge Øverland" <larshelge@xxxxxxxxx>
>Cc: 
>
>
>Hi Lars,
>                Ok,Thank you for the reply.
>                 I am creating one program ,type of the program is 'single event without registration',and entering some data,now I am  want to counting the particular data element value and want to show this value.
>Example :
> Suppose I have one data element Gender,I want to count Total Female and show the result.
>Regards,
>
>Barnali Banerjee
>
>
>________________________________
> From: Lars Helge Øverland <larshelge@xxxxxxxxx>
>To: Rodolfo Melia <rmelia@xxxxxxxxxxxx> 
>Cc: Barnali Bhaduri <barnali760@xxxxxxxxxxx>; "dhis2-devs@xxxxxxxxxxxxxxxxxxx" <dhis2-devs@xxxxxxxxxxxxxxxxxxx> 
>Sent: Wednesday, 10 April 2013 12:01 PM
>Subject: Re: [Dhis2-devs] Requirement
> 
>
>
>
>
>Hi Barnali,
>
>
>it would be good if could provide some more info re your problem, like the aggregation query, potential exceptions - makes it easier to help.
>
>
>regards,
>
>
>Lars
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>On Tue, Apr 9, 2013 at 9:31 PM, Rodolfo Melia <rmelia@xxxxxxxxxxxx> wrote:
>
>Sometimes, if you are simply counting encounters or similar, you may not even need to set a condition. If you set a condition, then it must be a full logical statement, like gender='female'.
>>
>>
>>
>>On Tue, Apr 9, 2013 at 8:10 PM, Barnali Bhaduri <barnali760@xxxxxxxxxxx> wrote:
>>
>>Hi,
>>>           Thank you very much.
>>>           I have one requirement,related to aggregation query builder using single event without registration program data element.I try to follow DHIS2 user guide ,but it is not clear to me,when I try to follow the  step,the test condition not run successfully .From where I get the result.
>>>
>>>Thanks
>>>
>>>Barnali Banerjee
>>>
>>>
>>>________________________________
>>> From: Rodolfo Melia <rmelia@xxxxxxxxxxxx>
>>>To: Barnali Bhaduri <barnali760@xxxxxxxxxxx> 
>>>Cc: "dhis2-devs@xxxxxxxxxxxxxxxxxxx" <dhis2-devs@xxxxxxxxxxxxxxxxxxx> 
>>>Sent: Monday, 8 April 2013 2:00 PM
>>>Subject: Re: [Dhis2-devs] Requirement
>>> 
>>>
>>>
>>>Hi - you seem to want to use the system for recording individual transactions, rather than data reported in a pre-stablished interval using a recurrent reporting frequency. Perhaps you should use Single Event without registration?
>>>
>>>
>>>Regarding your UI requirements, you can create a custom form that could incorporate jscript, so you can achieve what you describe in your email.
>>>
>>>
>>>R
>>>
>>>
>>>
>>>On Sun, Apr 7, 2013 at 8:24 AM, Barnali Bhaduri <barnali760@xxxxxxxxxxx> wrote:
>>>
>>>Dear All,
>>>>We have the following requirement for an data element. Please let me know what will be the best way to implement it in DHIS2
>>>>
>>>>
>>>>
>>>>Say the aggregate data element is ABC for a facility, Facility 1
>>>>
>>>> 
>>>>1. On the 1st date (the day when the system starts) for a Facility the 
Admin Facility Staff will enter initial current value of ABC in a data 
entry form (UI-1). Say the initial value is X.
>>>>
>>>>
>>>>This form will be entered 
>>>>1. On the first day of implementation
>>>>2. Once in a while when required to manually override the value of ABC 
>>>>Facility staff will rarely use UI-1  
>>>>
>>>>
>>>>
>>>>Nice to Have requirement:
>>>>When the form is edited it will be great to have a time-stamped history of this record only if the system automatically does it
>>>>.
>>>>We will not like to have any "Frequency" (Period) , that needs to be manually selected. But as it 
seems a required field, we can make the Frequency Yearly. If that is the case, is it possible to have a job that will copy the value of ABC of 
2013 to 2014 at mid-night of 31st December, 2013 automatically? 
>>>>
>>>>
>>>>2. Ongoing basis the Facility Staff at the Front desk (different from the 
admin staff), will be using another form (UI-2) to increment ABC by 1, 
with a single click
>>>>
>>>>
>>>>The initial ABC value will come from the UI 1. Say, it is X. 
>>>>
>>>>
>>>>It will have the following layout 
>>>>ABC =  _X__ (not editable) [Increment Button by 1]
>>>>The facility staff will click on the increment button. With one click the value of ABC will become X + 1.
>>>>
>>>>
>>>>The facility staff may do this click once, more then once or not at-all on a single day. It is not required to capture the time-stamp of these 
clicks.
>>>>
>>>>
>>>>
>>>>The requirement is that the staff entry will be ONLY in the form of clicking the buttons, nothing else. 
>>>>There should be minimal amount of manual data entry required in this screen. If any data is required (e.g: Organization Unit) it should be only a 
single value and defaulted by the system (e.g: Organization Unit 
defaulted to Facility 1)
>>>>
>>>>
>>>>The basic idea of the requirement is as following:
>>>>
>>>>1. The facility admin wants to make this easier for the staff as much as possible while wants to keep the duty segregated. 
>>>>
>>>>2. They want to have two UI, one for initialization and manual override and other for one click update (not editable) 
>>>>3. They are not so concerned about the reporting part. It is good to have 
the audit , history etc to understand the performance of staff, but not 
at the expense of making it difficult for the staff in their already 
burdened day. 
>>>>
>>>>
>>>>Thanks 
>>>>
>>>>Barnali Banerjee
>>>>_______________________________________________
>>>>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
>>>>
>>>>
>>>
>>>
>>>
>>>-- 
>>>
>>>Rodolfo Meliá
>>>Principal
>>>rmelia@xxxxxxxxxxxx
>>>www.knowming.com
>>>+1 708 872 7636
>>>+44 777 576 4090
>>>Skype: rod.melia
>>>Twitter: @RodolfoMelia
>>>
>>>
>>>Note: Please note my new email address, which I will be using for PSI related work: rmelia@xxxxxxxxxxxx
>>>
>>>
>>
>>
>>
>>-- 
>>
>>Rodolfo Meliá
>>Principal
>>rmelia@xxxxxxxxxxxx
>>www.knowming.com
>>+1 708 872 7636
>>+44 777 576 4090
>>Skype: rod.melia
>>Twitter: @RodolfoMelia
>>
>>
>>Note: Please note my new email address, which I will be using for PSI related work: rmelia@xxxxxxxxxxxx
>>_______________________________________________
>>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
>>
>>
>
>
>
>_______________________________________________
>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
>
>

_______________________________________________
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