dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxx>
> 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
>> Supported by: UNICEF-Bangladesh
>> Email: n.mifthah@xxxxxxxxx  | nayeem@xxxxxxxxxxxxxxx
>> Cell:+8801914030574
>>
>> On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland <larshelge@xxxxxxxxx
>> > 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@xxxxxxxxx>
>>> 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@xxxxxxxxx>
>>>> 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@xxxxxxxxx>
>>>>
>>>>
>>>> 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.
>>>>
>>>> Thanks a lot in advance.
>>>>
>>>> Regards,
>>>> *Fatema Uddin*
>>>>
>>>> Technical Advisor (HIS)-Support to the Health Sector Program II
>>>> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
>>>> German House
>>>> House 10/A-2, Road 90
>>>> Gulshan 2, Dhaka 1212, Bangladesh
>>>>
>>>> T          +880 9666701000
>>>> F          +880 28823099
>>>> M         +880 19 6206 4721
>>>> I           www.giz.de
>>>> <https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.&URL=http%3a%2f%2fwww.giz.de%2f>
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Regards,
>>>> *Fatema Uddin*
>>>>
>>>> Technical Advisor (HIS)-Support to the Health Sector Program II
>>>> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
>>>> German House
>>>> House 10/A-2, Road 90
>>>> Gulshan 2, Dhaka 1212, Bangladesh
>>>>
>>>> T          +880 9666701000
>>>> F          +880 28823099
>>>> M         +880 19 6206 4721
>>>> I           www.giz.de
>>>> <https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.&URL=http%3a%2f%2fwww.giz.de%2f>
>>>>
>>>>
>>>
>>>
>>> --
>>> Lars Helge Øverland
>>> Lead developer, DHIS 2
>>> University of Oslo
>>> Skype: larshelgeoverland
>>> http://www.dhis2.org <https://www.dhis2.org>
>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>
>
> --
> Regards,
> *Fatema Uddin*
>
> Technical Advisor (HIS)-Support to the Health Sector Program II
> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
> German House
> House 10/A-2, Road 90
> Gulshan 2, Dhaka 1212, Bangladesh
>
> T          +880 9666701000
> F          +880 28823099
> M         +880 19 6206 4721
> I           www.giz.de
> <https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.&URL=http%3a%2f%2fwww.giz.de%2f>
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org <https://www.dhis2.org>