Min - Max Values

Support - Assistance technique
1

Hello,

I was wondering if anyone knew how to set Min and Max values for data elements apart from the data entry screen . Setting this value from the data entry screen only sets the values for the particular element, month and Org Unit. I am hoping to be able to define this min/max value for particular elements irrespective of Org Unit or period. This was largely possible in 1.4…

Thanks.

···

Regards,

Adedapo Adejumo.
Mobile : +2348033683677
Skype : dapojorge

2

Hello Dapo,

please go to "data administration" module and then "Min-Max Value
Generation" in the left-side menu.

regards Lars

···

On Sat, Feb 4, 2012 at 9:45 AM, Dapo Adejumo <dapo_adejumo@yahoo.com> wrote:

Hello,
I was wondering if anyone knew how to set Min and Max values for data
elements apart from the data entry screen . Setting this value from the data
entry screen only sets the values for the particular element, month and Org
Unit. I am hoping to be able to define this min/max value for particular
elements irrespective of Org Unit or period. This was largely possible in
1.4....

Thanks.

________________________________

Regards,

Adedapo Adejumo.
Mobile : +2348033683677
Skype : dapojorge

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

3

Thanks Lars,

I had used that functionality but wasnt exactly sure what the command ‘generate’ does . Apart from the impression that it seems the action will generate values for all the elements in a particular dataset, I presume this generation will be based on statistical deductions from values entered for particular elements for particular org - units ( say 6 months history ) . What I am hoping to do is to be able to set custom values for selected data elements - Is this possible?

Thanks

···

Regards,

Adedapo Adejumo.
Mobile : +2348033683677
Skype : dapojorge

----- Original Message -----
From: Lars Helge Øverland larshelge@gmail.com
To: Dapo Adejumo dapo_adejumo@yahoo.com
Cc: “dhis2-devs@lists.launchpad.net” dhis2-devs@lists.launchpad.net
Sent: Sunday, 5 February 2012 1:24 PM
Subject: Re: [Dhis2-devs] Min - Max Values

Hello Dapo,

please go to “data administration” module and then “Min-Max Value
Generation” in the left-side menu.

regards Lars

On Sat, Feb 4, 2012 at 9:45 AM, Dapo Adejumo dapo_adejumo@yahoo.com wrote:

Hello,
I was wondering if anyone knew how to set Min and Max values for data
elements apart from the data entry screen . Setting this value from the data
entry screen only sets the values for the particular element, month and Org
Unit. I am hoping to be able to define this min/max value for particular
elements irrespective of Org Unit or period. This was largely possible in
1.4…

Thanks.

Regards,

Adedapo Adejumo.
Mobile : +2348033683677
Skype : dapojorge

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

4

Hi Dapo,

By double clicking the data value from the data entry screen, you can set individual min/max limits for particular data element/orgunits. In other cases when we needed to set a sort of uniform limit, it was easier to do this with SQL and store the results in the minmaxdataelement minmaxdataelement table. The method through the data entry screen works fine if you have a few to enter, but is rather painful if you wan to do it for all the facilities in Nigeria for instance. I could not really find a way to set a predetermined mix max either, so that is why we resorted to using SQL in this case.

Regards,

Jason

···

2012/2/5 Dapo Adejumo dapo_adejumo@yahoo.com

Thanks Lars,

I had used that functionality but wasnt exactly sure what the command ‘generate’ does . Apart from the impression that it seems the action will generate values for all the elements in a particular dataset, I presume this generation will be based on statistical deductions from values entered for particular elements for particular org - units ( say 6 months history ) . What I am hoping to do is to be able to set custom values for selected data elements - Is this possible?

Thanks

Regards,

Adedapo Adejumo.

Mobile : +2348033683677

Skype : dapojorge

----- Original Message -----
From: Lars Helge Øverland larshelge@gmail.com
To: Dapo Adejumo dapo_adejumo@yahoo.com
Cc: “dhis2-devs@lists.launchpad.net” dhis2-devs@lists.launchpad.net

Sent: Sunday, 5 February 2012 1:24 PM
Subject: Re: [Dhis2-devs] Min - Max Values

Hello Dapo,

please go to “data administration” module and then “Min-Max Value
Generation” in the left-side menu.

regards Lars

On Sat, Feb 4, 2012 at 9:45 AM, Dapo Adejumo dapo_adejumo@yahoo.com wrote:

Hello,
I was wondering if anyone knew how to set Min and Max values for data

elements apart from the data entry screen . Setting this value from the data
entry screen only sets the values for the particular element, month and Org
Unit. I am hoping to be able to define this min/max value for particular

elements irrespective of Org Unit or period. This was largely possible in
1.4…

Thanks.

Regards,

Adedapo Adejumo.
Mobile : +2348033683677

Skype : dapojorge

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

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

5

Hi,

if this turns out to be a common requirement we can consider creating
a system function for this. I.e. generating min-max values with fixed
limits per data element for all org units.

The current min-max generation function will generate limits based on
all available data for each org unit/data element, where the limits
are set 2 standard deviations from the mean.

Lars

···

On Mon, Feb 6, 2012 at 7:13 AM, Jason Pickering <jason.p.pickering@gmail.com> wrote:

Hi Dapo,

By double clicking the data value from the data entry screen, you can set
individual min/max limits for particular data element/orgunits. In other
cases when we needed to set a sort of uniform limit, it was easier to do
this with SQL and store the results in the minmaxdataelement
minmaxdataelement table. The method through the data entry screen works fine
if you have a few to enter, but is rather painful if you wan to do it for
all the facilities in Nigeria for instance. I could not really find a way to
set a predetermined mix max either, so that is why we resorted to using SQL
in this case.

Regards,
Jason

2012/2/5 Dapo Adejumo <dapo_adejumo@yahoo.com>

Thanks Lars,
I had used that functionality but wasnt exactly sure what the command
'generate' does . Apart from the impression that it seems the action will
generate values for all the elements in a particular dataset, I presume this
generation will be based on statistical deductions from values entered for
particular elements for particular org - units ( say 6 months history ) .
What I am hoping to do is to be able to set custom values for selected data
elements - Is this possible?

Thanks

________________________________

Regards,

Adedapo Adejumo.
Mobile : +2348033683677
Skype : dapojorge

----- Original Message -----
From: Lars Helge Øverland <larshelge@gmail.com>
To: Dapo Adejumo <dapo_adejumo@yahoo.com>
Cc: "dhis2-devs@lists.launchpad.net" <dhis2-devs@lists.launchpad.net>
Sent: Sunday, 5 February 2012 1:24 PM
Subject: Re: [Dhis2-devs] Min - Max Values

Hello Dapo,

please go to "data administration" module and then "Min-Max Value
Generation" in the left-side menu.

regards Lars

On Sat, Feb 4, 2012 at 9:45 AM, Dapo Adejumo <dapo_adejumo@yahoo.com> >> wrote:
> Hello,
> I was wondering if anyone knew how to set Min and Max values for data
> elements apart from the data entry screen . Setting this value from the
> data
> entry screen only sets the values for the particular element, month and
> Org
> Unit. I am hoping to be able to define this min/max value for particular
> elements irrespective of Org Unit or period. This was largely possible
> in
> 1.4....
>
> Thanks.
>
>
> ________________________________
>
> Regards,
>
> Adedapo Adejumo.
> Mobile : +2348033683677
> Skype : dapojorge
>
> _______________________________________________
> Mailing list: DHIS 2 developers in Launchpad
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : DHIS 2 developers in Launchpad
> More help : ListHelp - Launchpad Help
>

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

6

Thanks Lars and Jason,

I think it might be worthwhile considering adding this functionality in the future especially considering the potential number of facilities a database could hold.

···

Regards,

Adedapo Adejumo.
Mobile : +2348033683677
Skype : dapojorge

----- Original Message -----
From: Lars Helge Øverland larshelge@gmail.com
To: Jason Pickering jason.p.pickering@gmail.com
Cc: Dapo Adejumo dapo_adejumo@yahoo.com; “dhis2-devs@lists.launchpad.net” dhis2-devs@lists.launchpad.net
Sent: Wednesday, 8 February 2012 9:52 PM
Subject: Re: [Dhis2-devs] Min - Max Values

Hi,

if this turns out to be a common requirement we can consider creating
a system function for this. I.e. generating min-max values with fixed
limits per data element for all org units.

The current min-max generation function will generate limits based on
all available data for each org unit/data element, where the limits
are set 2 standard deviations from the mean.

Lars

On Mon, Feb 6, 2012 at 7:13 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Dapo,

By double clicking the data value from the data entry screen, you can set
individual min/max limits for particular data element/orgunits. In other
cases when we needed to set a sort of uniform limit, it was easier to do
this with SQL and store the results in the minmaxdataelement
minmaxdataelement table. The method through the data entry screen works fine
if you have a few to enter, but is rather painful if you wan to do it for
all the facilities in Nigeria for instance. I could not really find a way to
set a predetermined mix max either, so that is why we resorted to using SQL
in this case.

Regards,
Jason

2012/2/5 Dapo Adejumo dapo_adejumo@yahoo.com

Thanks Lars,
I had used that functionality but wasnt exactly sure what the command
‘generate’ does . Apart from the impression that it seems the action will
generate values for all the elements in a particular dataset, I presume this
generation will be based on statistical deductions from values entered for
particular elements for particular org - units ( say 6 months history ) .
What I am hoping to do is to be able to set custom values for selected data
elements - Is this possible?

Thanks

Regards,

Adedapo Adejumo.
Mobile : +2348033683677
Skype : dapojorge

----- Original Message -----
From: Lars Helge Øverland larshelge@gmail.com
To: Dapo Adejumo dapo_adejumo@yahoo.com
Cc: “dhis2-devs@lists.launchpad.net” dhis2-devs@lists.launchpad.net
Sent: Sunday, 5 February 2012 1:24 PM
Subject: Re: [Dhis2-devs] Min - Max Values

Hello Dapo,

please go to “data administration” module and then “Min-Max Value
Generation” in the left-side menu.

regards Lars

On Sat, Feb 4, 2012 at 9:45 AM, Dapo Adejumo dapo_adejumo@yahoo.com >> wrote:

Hello,
I was wondering if anyone knew how to set Min and Max values for data
elements apart from the data entry screen . Setting this value from the
data
entry screen only sets the values for the particular element, month and
Org
Unit. I am hoping to be able to define this min/max value for particular
elements irrespective of Org Unit or period. This was largely possible
in
1.4…

Thanks.

Regards,

Adedapo Adejumo.
Mobile : +2348033683677
Skype : dapojorge

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

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

7

Here is the SQL I use for this purpose. Of course you may need to adjust it slightly to your needs

The first number is the dataelement ID you wish to update.

The second number is the categoryoptioncomboid you wish to update.

Third number is the desired minvalue

Fourth number is the desired maxvalue

The false statement indicates whether this is a generated value or not (assume it should be FALSE here).

The last WHERE clause may need to be adjusted slightly, to determine exactly which organisational units you wish to update. In this example, I am updating all level 4 organisationunits.

This query will produce a series of SQL Insert statements, which you can then execute on your database.

Hope this helps. Of course, it would be useful to have this functionality through the UI. :slight_smile:

Best regards,

Jason

SELECT DISTINCT

‘INSERT INTO minmaxdataelement VALUES (’ ||

nextval(‘hibernate_sequence’::regclass) ||

‘,’ ||

organisationunitid ||

‘,’ ||

22::integer ||

‘,’ ||

15::integer ||

‘,’ ||

0::integer ||

‘,’ ||

100::integer ||

‘,’ || ‘FALSE);’

FROM organisationunit where organisationunitid

in (SELECT DISTINCT idlevel4 from _orgunitstructure)

···

On Wed, Feb 8, 2012 at 11:26 PM, Dapo Adejumo dapo_adejumo@yahoo.com wrote:

Thanks Lars and Jason,

I think it might be worthwhile considering adding this functionality in the future especially considering the potential number of facilities a database could hold.

Regards,

Adedapo Adejumo.

Mobile : +2348033683677

Skype : dapojorge

----- Original Message -----
From: Lars Helge Øverland larshelge@gmail.com

To: Jason Pickering jason.p.pickering@gmail.com

Cc: Dapo Adejumo dapo_adejumo@yahoo.com; “dhis2-devs@lists.launchpad.net” dhis2-devs@lists.launchpad.net

Sent: Wednesday, 8 February 2012 9:52 PM
Subject: Re: [Dhis2-devs] Min - Max Values

Hi,

if this turns out to be a common requirement we can consider creating
a system function for this. I.e. generating min-max values with fixed
limits per data element for all org units.

The current min-max generation function will generate limits based on

all available data for each org unit/data element, where the limits
are set 2 standard deviations from the mean.

Lars

On Mon, Feb 6, 2012 at 7:13 AM, Jason Pickering > jason.p.pickering@gmail.com wrote:

Hi Dapo,

By double clicking the data value from the data entry screen, you can set
individual min/max limits for particular data element/orgunits. In other
cases when we needed to set a sort of uniform limit, it was easier to do

this with SQL and store the results in the minmaxdataelement
minmaxdataelement table. The method through the data entry screen works fine
if you have a few to enter, but is rather painful if you wan to do it for
all the facilities in Nigeria for instance. I could not really find a way to
set a predetermined mix max either, so that is why we resorted to using SQL

in this case.

Regards,
Jason

2012/2/5 Dapo Adejumo dapo_adejumo@yahoo.com

Thanks Lars,
I had used that functionality but wasnt exactly sure what the command
‘generate’ does . Apart from the impression that it seems the action will
generate values for all the elements in a particular dataset, I presume this

generation will be based on statistical deductions from values entered for
particular elements for particular org - units ( say 6 months history ) .
What I am hoping to do is to be able to set custom values for selected data
elements - Is this possible?

Thanks

Regards,

Adedapo Adejumo.
Mobile : +2348033683677

Skype : dapojorge

----- Original Message -----
From: Lars Helge Øverland larshelge@gmail.com
To: Dapo Adejumo dapo_adejumo@yahoo.com

Cc: “dhis2-devs@lists.launchpad.net” dhis2-devs@lists.launchpad.net

Sent: Sunday, 5 February 2012 1:24 PM
Subject: Re: [Dhis2-devs] Min - Max Values

Hello Dapo,

please go to “data administration” module and then "Min-Max Value

Generation" in the left-side menu.

regards Lars

On Sat, Feb 4, 2012 at 9:45 AM, Dapo Adejumo dapo_adejumo@yahoo.com > > >> wrote:

Hello,
I was wondering if anyone knew how to set Min and Max values for data
elements apart from the data entry screen . Setting this value from the
data

entry screen only sets the values for the particular element, month and
Org
Unit. I am hoping to be able to define this min/max value for particular
elements irrespective of Org Unit or period. This was largely possible
in
1.4…

Thanks.

Regards,

Adedapo Adejumo.
Mobile : +2348033683677

Skype : dapojorge

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

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

8

Many thanks Jason!

···

Sent from my BlackBerry® wireless handheld from Glo Mobile.

From: Jason Pickering jason.p.pickering@gmail.com

Date: Thu, 9 Feb 2012 09:05:44 +0200

To: Dapo Adejumodapo_adejumo@yahoo.com

Cc: Lars Helge Øverlandlarshelge@gmail.com; dhis2-devs@lists.launchpad.netdhis2-devs@lists.launchpad.net

Subject: Re: [Dhis2-devs] Min - Max Values

Here is the SQL I use for this purpose. Of course you may need to adjust it slightly to your needs

The first number is the dataelement ID you wish to update.

The second number is the categoryoptioncomboid you wish to update.

Third number is the desired minvalue

Fourth number is the desired maxvalue

The false statement indicates whether this is a generated value or not (assume it should be FALSE here).

The last WHERE clause may need to be adjusted slightly, to determine exactly which organisational units you wish to update. In this example, I am updating all level 4 organisationunits.

This query will produce a series of SQL Insert statements, which you can then execute on your database.

Hope this helps. Of course, it would be useful to have this functionality through the UI. :slight_smile:

Best regards,

Jason

SELECT DISTINCT

‘INSERT INTO minmaxdataelement VALUES (’ ||

nextval(‘hibernate_sequence’::regclass) ||

‘,’ ||

organisationunitid ||

‘,’ ||

22::integer ||

‘,’ ||

15::integer ||

‘,’ ||

0::integer ||

‘,’ ||

100::integer ||

‘,’ || ‘FALSE);’

FROM organisationunit where organisationunitid

in (SELECT DISTINCT idlevel4 from _orgunitstructure)

On Wed, Feb 8, 2012 at 11:26 PM, Dapo Adejumo dapo_adejumo@yahoo.com wrote:

Thanks Lars and Jason,

I think it might be worthwhile considering adding this functionality in the future especially considering the potential number of facilities a database could hold.

Regards,

Adedapo Adejumo.

Mobile : +2348033683677

Skype : dapojorge

----- Original Message -----
From: Lars Helge Øverland larshelge@gmail.com

To: Jason Pickering jason.p.pickering@gmail.com

Cc: Dapo Adejumo dapo_adejumo@yahoo.com; “dhis2-devs@lists.launchpad.net” dhis2-devs@lists.launchpad.net

Sent: Wednesday, 8 February 2012 9:52 PM
Subject: Re: [Dhis2-devs] Min - Max Values

Hi,

if this turns out to be a common requirement we can consider creating
a system function for this. I.e. generating min-max values with fixed
limits per data element for all org units.

The current min-max generation function will generate limits based on

all available data for each org unit/data element, where the limits
are set 2 standard deviations from the mean.

Lars

On Mon, Feb 6, 2012 at 7:13 AM, Jason Pickering > jason.p.pickering@gmail.com wrote:

Hi Dapo,

By double clicking the data value from the data entry screen, you can set
individual min/max limits for particular data element/orgunits. In other
cases when we needed to set a sort of uniform limit, it was easier to do

this with SQL and store the results in the minmaxdataelement
minmaxdataelement table. The method through the data entry screen works fine
if you have a few to enter, but is rather painful if you wan to do it for
all the facilities in Nigeria for instance. I could not really find a way to
set a predetermined mix max either, so that is why we resorted to using SQL

in this case.

Regards,
Jason

2012/2/5 Dapo Adejumo dapo_adejumo@yahoo.com

Thanks Lars,
I had used that functionality but wasnt exactly sure what the command
‘generate’ does . Apart from the impression that it seems the action will
generate values for all the elements in a particular dataset, I presume this

generation will be based on statistical deductions from values entered for
particular elements for particular org - units ( say 6 months history ) .
What I am hoping to do is to be able to set custom values for selected data
elements - Is this possible?

Thanks

Regards,

Adedapo Adejumo.
Mobile : +2348033683677

Skype : dapojorge

----- Original Message -----
From: Lars Helge Øverland larshelge@gmail.com
To: Dapo Adejumo dapo_adejumo@yahoo.com

Cc: “dhis2-devs@lists.launchpad.net” dhis2-devs@lists.launchpad.net

Sent: Sunday, 5 February 2012 1:24 PM
Subject: Re: [Dhis2-devs] Min - Max Values

Hello Dapo,

please go to “data administration” module and then "Min-Max Value

Generation" in the left-side menu.

regards Lars

On Sat, Feb 4, 2012 at 9:45 AM, Dapo Adejumo dapo_adejumo@yahoo.com > > >> wrote:

Hello,
I was wondering if anyone knew how to set Min and Max values for data
elements apart from the data entry screen . Setting this value from the
data

entry screen only sets the values for the particular element, month and
Org
Unit. I am hoping to be able to define this min/max value for particular
elements irrespective of Org Unit or period. This was largely possible
in
1.4…

Thanks.

Regards,

Adedapo Adejumo.
Mobile : +2348033683677

Skype : dapojorge

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

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

9

Hi guys,

Although I agree that there should be some kind of automated functionality to populate default min/max values for all orgunits per data element, I think it is also good to again emphasize the functionality to generate more reasonable min/max values based on historical data (e.g. last six months). There are of course huge differences in catchment population for health units, so typically a default min/max for all orgunits will not be very useful, at least for most data elements.

A combination of the two will most likely be the most effective and useful approach, and then also plan for some individual adjustments (by the lower level users) using the functionality in data entry to change the min/max range for a specific orgunit+data element combination (double click on a data entry field in the form).

Ola

···

Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 9 February 2012 08:13, Dapo Adejumo dapo_adejumo@yahoo.com wrote:

Many thanks Jason!
Sent from my BlackBerry® wireless handheld from Glo Mobile.

From: Jason Pickering jason.p.pickering@gmail.com

Date: Thu, 9 Feb 2012 09:05:44 +0200

To: Dapo Adejumodapo_adejumo@yahoo.com

Cc: Lars Helge Øverlandlarshelge@gmail.com; dhis2-devs@lists.launchpad.netdhis2-devs@lists.launchpad.net

Subject: Re: [Dhis2-devs] Min - Max Values

Here is the SQL I use for this purpose. Of course you may need to adjust it slightly to your needs

The first number is the dataelement ID you wish to update.

The second number is the categoryoptioncomboid you wish to update.

Third number is the desired minvalue

Fourth number is the desired maxvalue

The false statement indicates whether this is a generated value or not (assume it should be FALSE here).

The last WHERE clause may need to be adjusted slightly, to determine exactly which organisational units you wish to update. In this example, I am updating all level 4 organisationunits.

This query will produce a series of SQL Insert statements, which you can then execute on your database.

Hope this helps. Of course, it would be useful to have this functionality through the UI. :slight_smile:

Best regards,

Jason

SELECT DISTINCT

‘INSERT INTO minmaxdataelement VALUES (’ ||

nextval(‘hibernate_sequence’::regclass) ||

‘,’ ||

organisationunitid ||

‘,’ ||

22::integer ||

‘,’ ||

15::integer ||

‘,’ ||

0::integer ||

‘,’ ||

100::integer ||

‘,’ || ‘FALSE);’

FROM organisationunit where organisationunitid

in (SELECT DISTINCT idlevel4 from _orgunitstructure)

On Wed, Feb 8, 2012 at 11:26 PM, Dapo Adejumo dapo_adejumo@yahoo.com wrote:

Thanks Lars and Jason,

I think it might be worthwhile considering adding this functionality in the future especially considering the potential number of facilities a database could hold.

Regards,

Adedapo Adejumo.

Mobile : +2348033683677

Skype : dapojorge

----- Original Message -----
From: Lars Helge Øverland larshelge@gmail.com

To: Jason Pickering jason.p.pickering@gmail.com

Cc: Dapo Adejumo dapo_adejumo@yahoo.com; “dhis2-devs@lists.launchpad.net” dhis2-devs@lists.launchpad.net

Sent: Wednesday, 8 February 2012 9:52 PM
Subject: Re: [Dhis2-devs] Min - Max Values

Hi,

if this turns out to be a common requirement we can consider creating
a system function for this. I.e. generating min-max values with fixed
limits per data element for all org units.

The current min-max generation function will generate limits based on

all available data for each org unit/data element, where the limits
are set 2 standard deviations from the mean.

Lars

On Mon, Feb 6, 2012 at 7:13 AM, Jason Pickering > > jason.p.pickering@gmail.com wrote:

Hi Dapo,

By double clicking the data value from the data entry screen, you can set
individual min/max limits for particular data element/orgunits. In other
cases when we needed to set a sort of uniform limit, it was easier to do

this with SQL and store the results in the minmaxdataelement
minmaxdataelement table. The method through the data entry screen works fine
if you have a few to enter, but is rather painful if you wan to do it for
all the facilities in Nigeria for instance. I could not really find a way to
set a predetermined mix max either, so that is why we resorted to using SQL

in this case.

Regards,
Jason

2012/2/5 Dapo Adejumo dapo_adejumo@yahoo.com

Thanks Lars,
I had used that functionality but wasnt exactly sure what the command
‘generate’ does . Apart from the impression that it seems the action will
generate values for all the elements in a particular dataset, I presume this

generation will be based on statistical deductions from values entered for
particular elements for particular org - units ( say 6 months history ) .
What I am hoping to do is to be able to set custom values for selected data
elements - Is this possible?

Thanks

Regards,

Adedapo Adejumo.
Mobile : +2348033683677

Skype : dapojorge

----- Original Message -----
From: Lars Helge Øverland larshelge@gmail.com
To: Dapo Adejumo dapo_adejumo@yahoo.com

Cc: “dhis2-devs@lists.launchpad.net” dhis2-devs@lists.launchpad.net

Sent: Sunday, 5 February 2012 1:24 PM
Subject: Re: [Dhis2-devs] Min - Max Values

Hello Dapo,

please go to “data administration” module and then "Min-Max Value

Generation" in the left-side menu.

regards Lars

On Sat, Feb 4, 2012 at 9:45 AM, Dapo Adejumo dapo_adejumo@yahoo.com > > > > > > > > >> wrote:

Hello,
I was wondering if anyone knew how to set Min and Max values for data
elements apart from the data entry screen . Setting this value from the
data

entry screen only sets the values for the particular element, month and
Org
Unit. I am hoping to be able to define this min/max value for particular
elements irrespective of Org Unit or period. This was largely possible
in
1.4…

Thanks.

Regards,

Adedapo Adejumo.
Mobile : +2348033683677

Skype : dapojorge

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

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

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