Dear All,

Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too

Here i attach screen short of Pivote Table Analysis and Data Entry Screen

In pivote table value shows = 51.7

but originally dataentry screen shows = 50

Calculation

it is dividing daysxvalue / 30 = 50* 31/30 = 51.7

But it should do daysxvalue/daysno = 50*31/31 =50

Please have a look on it.

Thanks

Fatema

Data_analytics bugs.docx (374 KB)

···

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Hi Fatema,

do you think you could explain a bit more about the data elements and calculation?

Do you think you cold try with 2.18 / 2.19 ?

regards,

Lars

···

On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatemacse@gmail.com wrote:

Dear All,

Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too

Here i attach screen short of Pivote Table Analysis and Data Entry Screen

In pivote table value shows = 51.7

but originally dataentry screen shows = 50

Calculation

it is dividing daysxvalue / 30 = 50* 31/30 = 51.7

But it should do daysxvalue/daysno = 50*31/31 =50

Please have a look on it.

Thanks

Fatema

------- Forwarded message ----------
rom: Uddin Fatema fatemacse@gmail.com
Date: Tue, May 5, 2015 at 5:56 PM
Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS.
To: Jan Henrik Øverland janhenrik.overland@gmail.com

Dear Jan,

DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping retrieve wrong data from Analytics_2015 or all analytics table.

The problem is in analytics table it store daysxvalue , daysno and value

column but when it retrieve data for pivote table, data-visualizer and gis that time it is dividing daysxvalue / 30

But it should do daysxvalue/daysno

As a result in pivot table, data visualizer and gis mapping shows wrong data.

Could you please solved it additionally, can you please tell me in source code in which file i have to change.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Dear Lars

There are monthly datasets on which a data entry operator input 50 in a cell. Analytic shows that same number as 51.7 in those months which have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in February as it have 28 days.

It has happened as the analytic table calculate the data as Ms. Fatema has described.

···

Nayeem Al Mifthah
HMIS Consultant
Management Information System
Directorate General of Health Services (DGHS), Bangladesh
Email: n.mifthah@gmail.com | nayeem@mis.dghs.gov.bd
Cell:+8801914030574

On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

do you think you could explain a bit more about the data elements and calculation?

Do you think you cold try with 2.18 / 2.19 ?

regards,

Lars

On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatemacse@gmail.com wrote:

Dear All,

Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too

Here i attach screen short of Pivote Table Analysis and Data Entry Screen

In pivote table value shows = 51.7

but originally dataentry screen shows = 50

Calculation

it is dividing daysxvalue / 30 = 50* 31/30 = 51.7

But it should do daysxvalue/daysno = 50*31/31 =50

Please have a look on it.

Thanks

Fatema

------- Forwarded message ----------
rom: Uddin Fatema fatemacse@gmail.com
Date: Tue, May 5, 2015 at 5:56 PM
Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS.
To: Jan Henrik Øverland janhenrik.overland@gmail.com

Dear Jan,

DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping retrieve wrong data from Analytics_2015 or all analytics table.

The problem is in analytics table it store daysxvalue , daysno and value

column but when it retrieve data for pivote table, data-visualizer and gis that time it is dividing daysxvalue / 30

But it should do daysxvalue/daysno

As a result in pivot table, data visualizer and gis mapping shows wrong data.

Could you please solved it additionally, can you please tell me in source code in which file i have to change.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Yes Lars i found same error in 2.18 too.

Actually I updated version in 2.18 in test server but still time zone error remains for (UTC+60 )Dhaka . You know that some time zone has time zone problem in resource table generation. So I Changes time zone UTC+6:30) Yaangoon) and update resource table and analytic.

And still I found same error which is described me and Nayeem Al Miftah.

Thanks

···

On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mifthah@gmail.com wrote:

Dear Lars

There are monthly datasets on which a data entry operator input 50 in a cell. Analytic shows that same number as 51.7 in those months which have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in February as it have 28 days.

It has happened as the analytic table calculate the data as Ms. Fatema has described.

Nayeem Al Mifthah
HMIS Consultant
Management Information System
Directorate General of Health Services (DGHS), Bangladesh
Email: n.mifthah@gmail.com | nayeem@mis.dghs.gov.bd
Cell:+8801914030574

On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

do you think you could explain a bit more about the data elements and calculation?

Do you think you cold try with 2.18 / 2.19 ?

regards,

Lars

On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatemacse@gmail.com wrote:

Dear All,

Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too

Here i attach screen short of Pivote Table Analysis and Data Entry Screen

In pivote table value shows = 51.7

but originally dataentry screen shows = 50

Calculation

it is dividing daysxvalue / 30 = 50* 31/30 = 51.7

But it should do daysxvalue/daysno = 50*31/31 =50

Please have a look on it.

Thanks

Fatema

------- Forwarded message ----------
rom: Uddin Fatema fatemacse@gmail.com
Date: Tue, May 5, 2015 at 5:56 PM
Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS.
To: Jan Henrik Øverland janhenrik.overland@gmail.com

Dear Jan,

DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping retrieve wrong data from Analytics_2015 or all analytics table.

The problem is in analytics table it store daysxvalue , daysno and value

column but when it retrieve data for pivote table, data-visualizer and gis that time it is dividing daysxvalue / 30

But it should do daysxvalue/daysno

As a result in pivot table, data visualizer and gis mapping shows wrong data.

Could you please solved it additionally, can you please tell me in source code in which file i have to change.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Okay thanks.

Could you let me know

• what is the data element value type and aggregation operator for the data element for which you get this result?

• is it possible for you to privately share a login and a link to a favorite?

regards,

Lars

···

On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatemacse@gmail.com wrote:

Yes Lars i found same error in 2.18 too.

Actually I updated version in 2.18 in test server but still time zone error remains for (UTC+60 )Dhaka . You know that some time zone has time zone problem in resource table generation. So I Changes time zone UTC+6:30) Yaangoon) and update resource table and analytic.

And still I found same error which is described me and Nayeem Al Miftah.

Thanks

On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mifthah@gmail.com wrote:

Dear Lars

There are monthly datasets on which a data entry operator input 50 in a cell. Analytic shows that same number as 51.7 in those months which have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in February as it have 28 days.

It has happened as the analytic table calculate the data as Ms. Fatema has described.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Nayeem Al Mifthah
HMIS Consultant
Management Information System
Directorate General of Health Services (DGHS), Bangladesh
Email: n.mifthah@gmail.com | nayeem@mis.dghs.gov.bd
Cell:+8801914030574

On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

do you think you could explain a bit more about the data elements and calculation?

Do you think you cold try with 2.18 / 2.19 ?

regards,

Lars

On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatemacse@gmail.com wrote:

Dear All,

Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too

Here i attach screen short of Pivote Table Analysis and Data Entry Screen

In pivote table value shows = 51.7

but originally dataentry screen shows = 50

Calculation

it is dividing daysxvalue / 30 = 50* 31/30 = 51.7

But it should do daysxvalue/daysno = 50*31/31 =50

Please have a look on it.

Thanks

Fatema

------- Forwarded message ----------
rom: Uddin Fatema fatemacse@gmail.com
Date: Tue, May 5, 2015 at 5:56 PM
Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS.
To: Jan Henrik Øverland janhenrik.overland@gmail.com

Dear Jan,

DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping retrieve wrong data from Analytics_2015 or all analytics table.

The problem is in analytics table it store daysxvalue , daysno and value

column but when it retrieve data for pivote table, data-visualizer and gis that time it is dividing daysxvalue / 30

But it should do daysxvalue/daysno

As a result in pivot table, data visualizer and gis mapping shows wrong data.

Could you please solved it additionally, can you please tell me in source code in which file i have to change.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Hi Fatema,

we have made a fix to prevent time zone issues for resource table generation in 2.18 and 2.19 now.

regards,

Lars

···

On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatemacse@gmail.com wrote:

Yes Lars i found same error in 2.18 too.

Actually I updated version in 2.18 in test server but still time zone error remains for (UTC+60 )Dhaka . You know that some time zone has time zone problem in resource table generation. So I Changes time zone UTC+6:30) Yaangoon) and update resource table and analytic.

And still I found same error which is described me and Nayeem Al Miftah.

Thanks

On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mifthah@gmail.com wrote:

Dear Lars

There are monthly datasets on which a data entry operator input 50 in a cell. Analytic shows that same number as 51.7 in those months which have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in February as it have 28 days.

It has happened as the analytic table calculate the data as Ms. Fatema has described.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Nayeem Al Mifthah
HMIS Consultant
Management Information System
Directorate General of Health Services (DGHS), Bangladesh
Email: n.mifthah@gmail.com | nayeem@mis.dghs.gov.bd
Cell:+8801914030574

On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

do you think you could explain a bit more about the data elements and calculation?

Do you think you cold try with 2.18 / 2.19 ?

regards,

Lars

On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatemacse@gmail.com wrote:

Dear All,

Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too

Here i attach screen short of Pivote Table Analysis and Data Entry Screen

In pivote table value shows = 51.7

but originally dataentry screen shows = 50

Calculation

it is dividing daysxvalue / 30 = 50* 31/30 = 51.7

But it should do daysxvalue/daysno = 50*31/31 =50

Please have a look on it.

Thanks

Fatema

------- Forwarded message ----------
rom: Uddin Fatema fatemacse@gmail.com
Date: Tue, May 5, 2015 at 5:56 PM
Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS.
To: Jan Henrik Øverland janhenrik.overland@gmail.com

Dear Jan,

DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping retrieve wrong data from Analytics_2015 or all analytics table.

The problem is in analytics table it store daysxvalue , daysno and value

column but when it retrieve data for pivote table, data-visualizer and gis that time it is dividing daysxvalue / 30

But it should do daysxvalue/daysno

As a result in pivot table, data visualizer and gis mapping shows wrong data.

Could you please solved it additionally, can you please tell me in source code in which file i have to change.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Dear Lars,

Thanks a lot

I just download 2.18 branch code and build the war file. Now i am running my database with this war file with UTC +6 Dhaka time zone but still shows same error.

Is it cash problem or anything else.

···

On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

we have made a fix to prevent time zone issues for resource table generation in 2.18 and 2.19 now.

regards,

Lars

On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatemacse@gmail.com wrote:

Yes Lars i found same error in 2.18 too.

Actually I updated version in 2.18 in test server but still time zone error remains for (UTC+60 )Dhaka . You know that some time zone has time zone problem in resource table generation. So I Changes time zone UTC+6:30) Yaangoon) and update resource table and analytic.

And still I found same error which is described me and Nayeem Al Miftah.

Thanks

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mifthah@gmail.com wrote:

Dear Lars

There are monthly datasets on which a data entry operator input 50 in a cell. Analytic shows that same number as 51.7 in those months which have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in February as it have 28 days.

It has happened as the analytic table calculate the data as Ms. Fatema has described.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Nayeem Al Mifthah
HMIS Consultant
Management Information System
Directorate General of Health Services (DGHS), Bangladesh
Email: n.mifthah@gmail.com | nayeem@mis.dghs.gov.bd
Cell:+8801914030574

On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

do you think you could explain a bit more about the data elements and calculation?

Do you think you cold try with 2.18 / 2.19 ?

regards,

Lars

On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatemacse@gmail.com wrote:

Dear All,

Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too

Here i attach screen short of Pivote Table Analysis and Data Entry Screen

In pivote table value shows = 51.7

but originally dataentry screen shows = 50

Calculation

it is dividing daysxvalue / 30 = 50* 31/30 = 51.7

But it should do daysxvalue/daysno = 50*31/31 =50

Please have a look on it.

Thanks

Fatema

------- Forwarded message ----------
rom: Uddin Fatema fatemacse@gmail.com
Date: Tue, May 5, 2015 at 5:56 PM
Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS.
To: Jan Henrik Øverland janhenrik.overland@gmail.com

Dear Jan,

DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping retrieve wrong data from Analytics_2015 or all analytics table.

The problem is in analytics table it store daysxvalue , daysno and value

column but when it retrieve data for pivote table, data-visualizer and gis that time it is dividing daysxvalue / 30

But it should do daysxvalue/daysno

As a result in pivot table, data visualizer and gis mapping shows wrong data.

Could you please solved it additionally, can you please tell me in source code in which file i have to change.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

regards,

Lars

···

On Tue, Jun 23, 2015 at 12:30 PM, Uddin Fatema fatemacse@gmail.com wrote:

Dear Lars,

Thanks a lot

I just download 2.18 branch code and build the war file. Now i am running my database with this war file with UTC +6 Dhaka time zone but still shows same error.

Is it cash problem or anything else.

On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

we have made a fix to prevent time zone issues for resource table generation in 2.18 and 2.19 now.

regards,

Lars

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatemacse@gmail.com wrote:

Yes Lars i found same error in 2.18 too.

Actually I updated version in 2.18 in test server but still time zone error remains for (UTC+60 )Dhaka . You know that some time zone has time zone problem in resource table generation. So I Changes time zone UTC+6:30) Yaangoon) and update resource table and analytic.

And still I found same error which is described me and Nayeem Al Miftah.

Thanks

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mifthah@gmail.com wrote:

Dear Lars

There are monthly datasets on which a data entry operator input 50 in a cell. Analytic shows that same number as 51.7 in those months which have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in February as it have 28 days.

It has happened as the analytic table calculate the data as Ms. Fatema has described.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Nayeem Al Mifthah
HMIS Consultant
Management Information System
Directorate General of Health Services (DGHS), Bangladesh
Email: n.mifthah@gmail.com | nayeem@mis.dghs.gov.bd
Cell:+8801914030574

On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

do you think you could explain a bit more about the data elements and calculation?

Do you think you cold try with 2.18 / 2.19 ?

regards,

Lars

On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatemacse@gmail.com wrote:

Dear All,

Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too

Here i attach screen short of Pivote Table Analysis and Data Entry Screen

In pivote table value shows = 51.7

but originally dataentry screen shows = 50

Calculation

it is dividing daysxvalue / 30 = 50* 31/30 = 51.7

But it should do daysxvalue/daysno = 50*31/31 =50

Please have a look on it.

Thanks

Fatema

------- Forwarded message ----------
rom: Uddin Fatema fatemacse@gmail.com
Date: Tue, May 5, 2015 at 5:56 PM
Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS.
To: Jan Henrik Øverland janhenrik.overland@gmail.com

Dear Jan,

DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping retrieve wrong data from Analytics_2015 or all analytics table.

The problem is in analytics table it store daysxvalue , daysno and value

column but when it retrieve data for pivote table, data-visualizer and gis that time it is dividing daysxvalue / 30

But it should do daysxvalue/daysno

As a result in pivot table, data visualizer and gis mapping shows wrong data.

Could you please solved it additionally, can you please tell me in source code in which file i have to change.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Hi Fatema,

I have made a fix for the problem with inaccurate aggregate values for data elements with average aggregation operator (e.g. 51.7 instead of 50) now in trunk and 2.19.

regards,

Lars

···

On Tue, Jun 23, 2015 at 12:48 PM, Lars Helge Øverland larshelge@gmail.com wrote:

• provide the output of the tomcat log for when it fails

regards,

Lars

On Tue, Jun 23, 2015 at 12:30 PM, Uddin Fatema fatemacse@gmail.com wrote:

Dear Lars,

Thanks a lot

I just download 2.18 branch code and build the war file. Now i am running my database with this war file with UTC +6 Dhaka time zone but still shows same error.

Is it cash problem or anything else.

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

we have made a fix to prevent time zone issues for resource table generation in 2.18 and 2.19 now.

regards,

Lars

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatemacse@gmail.com wrote:

Yes Lars i found same error in 2.18 too.

Actually I updated version in 2.18 in test server but still time zone error remains for (UTC+60 )Dhaka . You know that some time zone has time zone problem in resource table generation. So I Changes time zone UTC+6:30) Yaangoon) and update resource table and analytic.

And still I found same error which is described me and Nayeem Al Miftah.

Thanks

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mifthah@gmail.com wrote:

Dear Lars

There are monthly datasets on which a data entry operator input 50 in a cell. Analytic shows that same number as 51.7 in those months which have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in February as it have 28 days.

It has happened as the analytic table calculate the data as Ms. Fatema has described.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Nayeem Al Mifthah
HMIS Consultant
Management Information System
Directorate General of Health Services (DGHS), Bangladesh
Email: n.mifthah@gmail.com | nayeem@mis.dghs.gov.bd
Cell:+8801914030574

On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

do you think you could explain a bit more about the data elements and calculation?

Do you think you cold try with 2.18 / 2.19 ?

regards,

Lars

On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatemacse@gmail.com wrote:

Dear All,

Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too

Here i attach screen short of Pivote Table Analysis and Data Entry Screen

In pivote table value shows = 51.7

but originally dataentry screen shows = 50

Calculation

it is dividing daysxvalue / 30 = 50* 31/30 = 51.7

But it should do daysxvalue/daysno = 50*31/31 =50

Please have a look on it.

Thanks

Fatema

------- Forwarded message ----------
rom: Uddin Fatema fatemacse@gmail.com
Date: Tue, May 5, 2015 at 5:56 PM
Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS.
To: Jan Henrik Øverland janhenrik.overland@gmail.com

Dear Jan,

DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping retrieve wrong data from Analytics_2015 or all analytics table.

The problem is in analytics table it store daysxvalue , daysno and value

column but when it retrieve data for pivote table, data-visualizer and gis that time it is dividing daysxvalue / 30

But it should do daysxvalue/daysno

As a result in pivot table, data visualizer and gis mapping shows wrong data.

Could you please solved it additionally, can you please tell me in source code in which file i have to change.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Dear Lars,

Here I attached the Error Log file

···

On Tue, Jun 23, 2015 at 4:30 PM, Uddin Fatema fatemacse@gmail.com wrote:

Dear Lars,

Thanks a lot

I just download 2.18 branch code and build the war file. Now i am running my database with this war file with UTC +6 Dhaka time zone but still shows same error.

Is it cash problem or anything else.

On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

we have made a fix to prevent time zone issues for resource table generation in 2.18 and 2.19 now.

regards,

Lars

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatemacse@gmail.com wrote:

Yes Lars i found same error in 2.18 too.

Actually I updated version in 2.18 in test server but still time zone error remains for (UTC+60 )Dhaka . You know that some time zone has time zone problem in resource table generation. So I Changes time zone UTC+6:30) Yaangoon) and update resource table and analytic.

And still I found same error which is described me and Nayeem Al Miftah.

Thanks

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mifthah@gmail.com wrote:

Dear Lars

There are monthly datasets on which a data entry operator input 50 in a cell. Analytic shows that same number as 51.7 in those months which have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in February as it have 28 days.

It has happened as the analytic table calculate the data as Ms. Fatema has described.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Nayeem Al Mifthah
HMIS Consultant
Management Information System
Directorate General of Health Services (DGHS), Bangladesh
Email: n.mifthah@gmail.com | nayeem@mis.dghs.gov.bd
Cell:+8801914030574

On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

do you think you could explain a bit more about the data elements and calculation?

Do you think you cold try with 2.18 / 2.19 ?

regards,

Lars

On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatemacse@gmail.com wrote:

Dear All,

Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too

Here i attach screen short of Pivote Table Analysis and Data Entry Screen

In pivote table value shows = 51.7

but originally dataentry screen shows = 50

Calculation

it is dividing daysxvalue / 30 = 50* 31/30 = 51.7

But it should do daysxvalue/daysno = 50*31/31 =50

Please have a look on it.

Thanks

Fatema

------- Forwarded message ----------
rom: Uddin Fatema fatemacse@gmail.com
Date: Tue, May 5, 2015 at 5:56 PM
Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS.
To: Jan Henrik Øverland janhenrik.overland@gmail.com

Dear Jan,

DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping retrieve wrong data from Analytics_2015 or all analytics table.

The problem is in analytics table it store daysxvalue , daysno and value

column but when it retrieve data for pivote table, data-visualizer and gis that time it is dividing daysxvalue / 30

But it should do daysxvalue/daysno

As a result in pivot table, data visualizer and gis mapping shows wrong data.

Could you please solved it additionally, can you please tell me in source code in which file i have to change.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Dear Lars,

Thank you very much. I am really happy that 2.19 is working fine. Time zone problem solved and aggregated data problem also solved.

Again thanks a lot for you and core teams hard work.

Best Regards

Fatema

···

On Wed, Jun 24, 2015 at 4:11 PM, Uddin Fatema fatemacse@gmail.com wrote:

Dear Lars,

Here I attached the Error Log file

On Tue, Jun 23, 2015 at 4:30 PM, Uddin Fatema fatemacse@gmail.com wrote:

Dear Lars,

Thanks a lot

I just download 2.18 branch code and build the war file. Now i am running my database with this war file with UTC +6 Dhaka time zone but still shows same error.

Is it cash problem or anything else.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

we have made a fix to prevent time zone issues for resource table generation in 2.18 and 2.19 now.

regards,

Lars

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatemacse@gmail.com wrote:

Yes Lars i found same error in 2.18 too.

Actually I updated version in 2.18 in test server but still time zone error remains for (UTC+60 )Dhaka . You know that some time zone has time zone problem in resource table generation. So I Changes time zone UTC+6:30) Yaangoon) and update resource table and analytic.

And still I found same error which is described me and Nayeem Al Miftah.

Thanks

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mifthah@gmail.com wrote:

Dear Lars

There are monthly datasets on which a data entry operator input 50 in a cell. Analytic shows that same number as 51.7 in those months which have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in February as it have 28 days.

It has happened as the analytic table calculate the data as Ms. Fatema has described.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Nayeem Al Mifthah
HMIS Consultant
Management Information System
Directorate General of Health Services (DGHS), Bangladesh
Email: n.mifthah@gmail.com | nayeem@mis.dghs.gov.bd
Cell:+8801914030574

On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

do you think you could explain a bit more about the data elements and calculation?

Do you think you cold try with 2.18 / 2.19 ?

regards,

Lars

On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatemacse@gmail.com wrote:

Dear All,

Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too

Here i attach screen short of Pivote Table Analysis and Data Entry Screen

In pivote table value shows = 51.7

but originally dataentry screen shows = 50

Calculation

it is dividing daysxvalue / 30 = 50* 31/30 = 51.7

But it should do daysxvalue/daysno = 50*31/31 =50

Please have a look on it.

Thanks

Fatema

------- Forwarded message ----------
rom: Uddin Fatema fatemacse@gmail.com
Date: Tue, May 5, 2015 at 5:56 PM
Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS.
To: Jan Henrik Øverland janhenrik.overland@gmail.com

Dear Jan,

DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping retrieve wrong data from Analytics_2015 or all analytics table.

The problem is in analytics table it store daysxvalue , daysno and value

column but when it retrieve data for pivote table, data-visualizer and gis that time it is dividing daysxvalue / 30

But it should do daysxvalue/daysno

As a result in pivot table, data visualizer and gis mapping shows wrong data.

Could you please solved it additionally, can you please tell me in source code in which file i have to change.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Thanks Fatema, that’s great news.

best regards,

Lars

···

On Sat, Jul 4, 2015 at 12:55 PM, Uddin Fatema fatemacse@gmail.com wrote:

Dear Lars,

Thank you very much. I am really happy that 2.19 is working fine. Time zone problem solved and aggregated data problem also solved.

Again thanks a lot for you and core teams hard work.

Best Regards

Fatema

On Wed, Jun 24, 2015 at 4:11 PM, Uddin Fatema fatemacse@gmail.com wrote:

Dear Lars,

Here I attached the Error Log file

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

On Tue, Jun 23, 2015 at 4:30 PM, Uddin Fatema fatemacse@gmail.com wrote:

Dear Lars,

Thanks a lot

I just download 2.18 branch code and build the war file. Now i am running my database with this war file with UTC +6 Dhaka time zone but still shows same error.

Is it cash problem or anything else.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

we have made a fix to prevent time zone issues for resource table generation in 2.18 and 2.19 now.

regards,

Lars

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatemacse@gmail.com wrote:

Yes Lars i found same error in 2.18 too.

Actually I updated version in 2.18 in test server but still time zone error remains for (UTC+60 )Dhaka . You know that some time zone has time zone problem in resource table generation. So I Changes time zone UTC+6:30) Yaangoon) and update resource table and analytic.

And still I found same error which is described me and Nayeem Al Miftah.

Thanks

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mifthah@gmail.com wrote:

Dear Lars

There are monthly datasets on which a data entry operator input 50 in a cell. Analytic shows that same number as 51.7 in those months which have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in February as it have 28 days.

It has happened as the analytic table calculate the data as Ms. Fatema has described.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Nayeem Al Mifthah
HMIS Consultant
Management Information System
Directorate General of Health Services (DGHS), Bangladesh
Email: n.mifthah@gmail.com | nayeem@mis.dghs.gov.bd
Cell:+8801914030574

On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

do you think you could explain a bit more about the data elements and calculation?

Do you think you cold try with 2.18 / 2.19 ?

regards,

Lars

On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatemacse@gmail.com wrote:

Dear All,

Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too

Here i attach screen short of Pivote Table Analysis and Data Entry Screen

In pivote table value shows = 51.7

but originally dataentry screen shows = 50

Calculation

it is dividing daysxvalue / 30 = 50* 31/30 = 51.7

But it should do daysxvalue/daysno = 50*31/31 =50

Please have a look on it.

Thanks

Fatema

------- Forwarded message ----------
rom: Uddin Fatema fatemacse@gmail.com
Date: Tue, May 5, 2015 at 5:56 PM
Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS.
To: Jan Henrik Øverland janhenrik.overland@gmail.com

Dear Jan,

DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping retrieve wrong data from Analytics_2015 or all analytics table.

The problem is in analytics table it store daysxvalue , daysno and value

column but when it retrieve data for pivote table, data-visualizer and gis that time it is dividing daysxvalue / 30

But it should do daysxvalue/daysno

As a result in pivot table, data visualizer and gis mapping shows wrong data.

Could you please solved it additionally, can you please tell me in source code in which file i have to change.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Dear Lars

The problem in this thread arise again. That problem was fixed in the trunk and suppose to reflect in the later versions. Can you please check this issue and find a solution as soon as possible.

We using version 2.22 build 21827.

Regards

Hannan Khan

···

On Sat, Jul 4, 2015 at 4:55 PM, Uddin Fatema fatemacse@gmail.com wrote:

Dear Lars,

Thank you very much. I am really happy that 2.19 is working fine. Time zone problem solved and aggregated data problem also solved.

Again thanks a lot for you and core teams hard work.

Best Regards

Fatema

On Wed, Jun 24, 2015 at 4:11 PM, Uddin Fatema fatemacse@gmail.com wrote:

Dear Lars,

Here I attached the Error Log file

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

On Tue, Jun 23, 2015 at 4:30 PM, Uddin Fatema fatemacse@gmail.com wrote:

Dear Lars,

Thanks a lot

I just download 2.18 branch code and build the war file. Now i am running my database with this war file with UTC +6 Dhaka time zone but still shows same error.

Is it cash problem or anything else.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

we have made a fix to prevent time zone issues for resource table generation in 2.18 and 2.19 now.

regards,

Lars

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatemacse@gmail.com wrote:

Yes Lars i found same error in 2.18 too.

Actually I updated version in 2.18 in test server but still time zone error remains for (UTC+60 )Dhaka . You know that some time zone has time zone problem in resource table generation. So I Changes time zone UTC+6:30) Yaangoon) and update resource table and analytic.

And still I found same error which is described me and Nayeem Al Miftah.

Thanks

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mifthah@gmail.com wrote:

Dear Lars

There are monthly datasets on which a data entry operator input 50 in a cell. Analytic shows that same number as 51.7 in those months which have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in February as it have 28 days.

It has happened as the analytic table calculate the data as Ms. Fatema has described.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Nayeem Al Mifthah
HMIS Consultant
Management Information System
Directorate General of Health Services (DGHS), Bangladesh
Email: n.mifthah@gmail.com | nayeem@mis.dghs.gov.bd
Cell:+8801914030574

On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

do you think you could explain a bit more about the data elements and calculation?

Do you think you cold try with 2.18 / 2.19 ?

regards,

Lars

On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatemacse@gmail.com wrote:

Dear All,

Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too

Here i attach screen short of Pivote Table Analysis and Data Entry Screen

In pivote table value shows = 51.7

but originally dataentry screen shows = 50

Calculation

it is dividing daysxvalue / 30 = 50* 31/30 = 51.7

But it should do daysxvalue/daysno = 50*31/31 =50

Please have a look on it.

Thanks

Fatema

------- Forwarded message ----------
rom: Uddin Fatema fatemacse@gmail.com
Date: Tue, May 5, 2015 at 5:56 PM
Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS.
To: Jan Henrik Øverland janhenrik.overland@gmail.com

Dear Jan,

DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping retrieve wrong data from Analytics_2015 or all analytics table.

The problem is in analytics table it store daysxvalue , daysno and value

column but when it retrieve data for pivote table, data-visualizer and gis that time it is dividing daysxvalue / 30

But it should do daysxvalue/daysno

As a result in pivot table, data visualizer and gis mapping shows wrong data.

Could you please solved it additionally, can you please tell me in source code in which file i have to change.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Hi Hannan,

is this for February 2016? If so I suspect this is a leap-year issue (and not an issue for other periods). We can look into it but this might not be critical…

regards,

Lars

···

On Sun, Mar 27, 2016 at 8:56 AM, Hannan Khan hannank@gmail.com wrote:

Dear Lars

The problem in this thread arise again. That problem was fixed in the trunk and suppose to reflect in the later versions. Can you please check this issue and find a solution as soon as possible.

We using version 2.22 build 21827.

Regards

Hannan Khan

On Sat, Jul 4, 2015 at 4:55 PM, Uddin Fatema fatemacse@gmail.com wrote:

Dear Lars,

Thank you very much. I am really happy that 2.19 is working fine. Time zone problem solved and aggregated data problem also solved.

Again thanks a lot for you and core teams hard work.

Best Regards

Fatema

On Wed, Jun 24, 2015 at 4:11 PM, Uddin Fatema fatemacse@gmail.com wrote:

Dear Lars,

Here I attached the Error Log file

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

On Tue, Jun 23, 2015 at 4:30 PM, Uddin Fatema fatemacse@gmail.com wrote:

Dear Lars,

Thanks a lot

I just download 2.18 branch code and build the war file. Now i am running my database with this war file with UTC +6 Dhaka time zone but still shows same error.

Is it cash problem or anything else.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

we have made a fix to prevent time zone issues for resource table generation in 2.18 and 2.19 now.

regards,

Lars

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatemacse@gmail.com wrote:

Yes Lars i found same error in 2.18 too.

Actually I updated version in 2.18 in test server but still time zone error remains for (UTC+60 )Dhaka . You know that some time zone has time zone problem in resource table generation. So I Changes time zone UTC+6:30) Yaangoon) and update resource table and analytic.

And still I found same error which is described me and Nayeem Al Miftah.

Thanks

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mifthah@gmail.com wrote:

Dear Lars

There are monthly datasets on which a data entry operator input 50 in a cell. Analytic shows that same number as 51.7 in those months which have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in February as it have 28 days.

It has happened as the analytic table calculate the data as Ms. Fatema has described.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Nayeem Al Mifthah
HMIS Consultant
Management Information System
Directorate General of Health Services (DGHS), Bangladesh
Email: n.mifthah@gmail.com | nayeem@mis.dghs.gov.bd
Cell:+8801914030574

On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

do you think you could explain a bit more about the data elements and calculation?

Do you think you cold try with 2.18 / 2.19 ?

regards,

Lars

On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatemacse@gmail.com wrote:

Dear All,

Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too

Here i attach screen short of Pivote Table Analysis and Data Entry Screen

In pivote table value shows = 51.7

but originally dataentry screen shows = 50

Calculation

it is dividing daysxvalue / 30 = 50* 31/30 = 51.7

But it should do daysxvalue/daysno = 50*31/31 =50

Please have a look on it.

Thanks

Fatema

------- Forwarded message ----------
rom: Uddin Fatema fatemacse@gmail.com
Date: Tue, May 5, 2015 at 5:56 PM
Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS.
To: Jan Henrik Øverland janhenrik.overland@gmail.com

Dear Jan,

DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping retrieve wrong data from Analytics_2015 or all analytics table.

The problem is in analytics table it store daysxvalue , daysno and value

column but when it retrieve data for pivote table, data-visualizer and gis that time it is dividing daysxvalue / 30

But it should do daysxvalue/daysno

As a result in pivot table, data visualizer and gis mapping shows wrong data.

Could you please solved it additionally, can you please tell me in source code in which file i have to change.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Ok. But can it be solved? It will appear in the next leap-year.

DHIS2 is an excellent work done by all of you (and us) and we are hesitant to say all users that it’s DHIS2’s fault.

Regards

Hannan

···

On Tue, Mar 29, 2016 at 3:58 PM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Hannan,

is this for February 2016? If so I suspect this is a leap-year issue (and not an issue for other periods). We can look into it but this might not be critical…

regards,

Lars

On Sun, Mar 27, 2016 at 8:56 AM, Hannan Khan hannank@gmail.com wrote:

Dear Lars

The problem in this thread arise again. That problem was fixed in the trunk and suppose to reflect in the later versions. Can you please check this issue and find a solution as soon as possible.

We using version 2.22 build 21827.

Regards

Hannan Khan

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

On Sat, Jul 4, 2015 at 4:55 PM, Uddin Fatema fatemacse@gmail.com wrote:

Dear Lars,

Thank you very much. I am really happy that 2.19 is working fine. Time zone problem solved and aggregated data problem also solved.

Again thanks a lot for you and core teams hard work.

Best Regards

Fatema

On Wed, Jun 24, 2015 at 4:11 PM, Uddin Fatema fatemacse@gmail.com wrote:

Dear Lars,

Here I attached the Error Log file

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

On Tue, Jun 23, 2015 at 4:30 PM, Uddin Fatema fatemacse@gmail.com wrote:

Dear Lars,

Thanks a lot

I just download 2.18 branch code and build the war file. Now i am running my database with this war file with UTC +6 Dhaka time zone but still shows same error.

Is it cash problem or anything else.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

we have made a fix to prevent time zone issues for resource table generation in 2.18 and 2.19 now.

regards,

Lars

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatemacse@gmail.com wrote:

Yes Lars i found same error in 2.18 too.

Actually I updated version in 2.18 in test server but still time zone error remains for (UTC+60 )Dhaka . You know that some time zone has time zone problem in resource table generation. So I Changes time zone UTC+6:30) Yaangoon) and update resource table and analytic.

And still I found same error which is described me and Nayeem Al Miftah.

Thanks

Lars Helge Øverland

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mifthah@gmail.com wrote:

Dear Lars

There are monthly datasets on which a data entry operator input 50 in a cell. Analytic shows that same number as 51.7 in those months which have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in February as it have 28 days.

It has happened as the analytic table calculate the data as Ms. Fatema has described.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Nayeem Al Mifthah
HMIS Consultant
Management Information System
Directorate General of Health Services (DGHS), Bangladesh
Email: n.mifthah@gmail.com | nayeem@mis.dghs.gov.bd
Cell:+8801914030574

On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Fatema,

do you think you could explain a bit more about the data elements and calculation?

Do you think you cold try with 2.18 / 2.19 ?

regards,

Lars

On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatemacse@gmail.com wrote:

Dear All,

Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too

Here i attach screen short of Pivote Table Analysis and Data Entry Screen

In pivote table value shows = 51.7

but originally dataentry screen shows = 50

Calculation

it is dividing daysxvalue / 30 = 50* 31/30 = 51.7

But it should do daysxvalue/daysno = 50*31/31 =50

Please have a look on it.

Thanks

Fatema

------- Forwarded message ----------
rom: Uddin Fatema fatemacse@gmail.com
Date: Tue, May 5, 2015 at 5:56 PM
Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS.
To: Jan Henrik Øverland janhenrik.overland@gmail.com

Dear Jan,

DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping retrieve wrong data from Analytics_2015 or all analytics table.

The problem is in analytics table it store daysxvalue , daysno and value

column but when it retrieve data for pivote table, data-visualizer and gis that time it is dividing daysxvalue / 30

But it should do daysxvalue/daysno

As a result in pivot table, data visualizer and gis mapping shows wrong data.

Could you please solved it additionally, can you please tell me in source code in which file i have to change.

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Regards,

Fatema Uddin

Technical Advisor (HIS)-Support to the Health Sector Program II

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

German House

T +880 9666701000

F +880 28823099

M +880 19 6206 4721

Lars Helge Øverland