dhis2-devs team mailing list archive

[Tran Chau <tran.hispvietnam@xxxxxxxxx>]

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
.
In* Create 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 stage* S*.
    -

   *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 <https://twitter.com/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 <https://twitter.com/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
>
>