dhis2-devs team mailing list archive

[Nayeem Al Mifthah <n.mifthah@xxxxxxxxx>]

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
>
>