Issues aggregating patient data values

Hi all,

I have two doubts while aggregating patient data values:

1- In the Query Builder, I want to use the “Age at visit (days since birth)” field (in the Program label → Program stage properties). I tried comparing the field with a number, but it didn’t work. I tried other syntax but none passes the Test.

2- In “Manual Person Aggregation” at “Individual Records” label, the aggregation process returns several times the same information by org unit. I have checked this in the online demo application and it’s the same (I have created the dataset “Death summary”). In my case, the same information is printed 30 times by org unit. The values can be saved, but the page is slow and unusable…

Thank you,

Victor

Dear Victor,

There is a bug with “Age at visit (days since birth)” formula. I fixed it for version 2.10. Please re-run your formulas with version 9108.

For the second issue, but this bug didn’t occur in my laptop. I cannot test your case on demo application online exactly because I didn’t find out the Death summary dataset for testing. Please send me the formula you created for this case and parameters which you selected in Manual person aggregation function, I will re-test it.

This is a formula example for**Age at visit (days since birth) to get the total number of children who visited Birth Details stage of Child Health program and had the age at visit as 1 week :

  • [PS:1149293] AND [PC:DATE@executionDate#-DATE@birthDate#] = 7*

Hope it’s useful for you.

Best regards

···

Châu Thu Trân

HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Thu, Dec 13, 2012 at 12:05 AM, Victor Garcia vgarciabnz@gmail.com wrote:

Hi all,

I have two doubts while aggregating patient data values:

1- In the Query Builder, I want to use the “Age at visit (days since birth)” field (in the Program label → Program stage properties). I tried comparing the field with a number, but it didn’t work. I tried other syntax but none passes the Test.

2- In “Manual Person Aggregation” at “Individual Records” label, the aggregation process returns several times the same information by org unit. I have checked this in the online demo application and it’s the same (I have created the dataset “Death summary”). In my case, the same information is printed 30 times by org unit. The values can be saved, but the page is slow and unusable…

Thank you,

Victor


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Thank you for the answer, Tran.

The demo application has been reset, so I have re-created it. You can see what I mean if you aggregate data for “Death summary” dataset, from 2012-01-01 to 2012-12-13 and for Njandama MCHP org unit (in Badjia chiefdom). There, the same information appears three times. I hope you can see that.

Regards,

Víctor

···

On 13 December 2012 00:53, Tran Chau tran.hispvietnam@gmail.com wrote:

Dear Victor,

There is a bug with “Age at visit (days since birth)” formula. I fixed it for version 2.10. Please re-run your formulas with version 9108.

For the second issue, but this bug didn’t occur in my laptop. I cannot test your case on demo application online exactly because I didn’t find out the Death summary dataset for testing. Please send me the formula you created for this case and parameters which you selected in Manual person aggregation function, I will re-test it.

This is a formula example for**Age at visit (days since birth) to get the total number of children who visited Birth Details stage of Child Health program and had the age at visit as 1 week :

  • [PS:1149293] AND [PC:DATE@executionDate#-DATE@birthDate#] = 7*

Hope it’s useful for you.

Best regards

Châu Thu Trân

HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Thu, Dec 13, 2012 at 12:05 AM, Victor Garcia vgarciabnz@gmail.com wrote:

Hi all,

I have two doubts while aggregating patient data values:

1- In the Query Builder, I want to use the “Age at visit (days since birth)” field (in the Program label → Program stage properties). I tried comparing the field with a number, but it didn’t work. I tried other syntax but none passes the Test.

2- In “Manual Person Aggregation” at “Individual Records” label, the aggregation process returns several times the same information by org unit. I have checked this in the online demo application and it’s the same (I have created the dataset “Death summary”). In my case, the same information is printed 30 times by org unit. The values can be saved, but the page is slow and unusable…

Thank you,

Victor


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Dear Victor,

I saw this bug and fixed for 2.10. Thank you so much.

Best regards,

···

On 13 December 2012 00:53, Tran Chau tran.hispvietnam@gmail.com wrote:

Dear Victor,

There is a bug with “Age at visit (days since birth)” formula. I fixed it for version 2.10. Please re-run your formulas with version 9108.

For the second issue, but this bug didn’t occur in my laptop. I cannot test your case on demo application online exactly because I didn’t find out the Death summary dataset for testing. Please send me the formula you created for this case and parameters which you selected in Manual person aggregation function, I will re-test it.

This is a formula example for**Age at visit (days since birth) to get the total number of children who visited Birth Details stage of Child Health program and had the age at visit as 1 week :

  • [PS:1149293] AND [PC:DATE@executionDate#-DATE@birthDate#] = 7*

Hope it’s useful for you.

Best regards

Châu Thu Trân

HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Thu, Dec 13, 2012 at 12:05 AM, Victor Garcia vgarciabnz@gmail.com wrote:

Hi all,

I have two doubts while aggregating patient data values:

1- In the Query Builder, I want to use the “Age at visit (days since birth)” field (in the Program label → Program stage properties). I tried comparing the field with a number, but it didn’t work. I tried other syntax but none passes the Test.

2- In “Manual Person Aggregation” at “Individual Records” label, the aggregation process returns several times the same information by org unit. I have checked this in the online demo application and it’s the same (I have created the dataset “Death summary”). In my case, the same information is printed 30 times by org unit. The values can be saved, but the page is slow and unusable…

Thank you,

Victor


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp