dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Paul,
You can export these reports to Excel no problem as they are BIRT reports.

These reports (and associated SQL) analyze the ratio of blank data
values to a numeric value, including zeroes. It would be simple enough
to alter the SQL to analyze NULLS, zeros and actual data values, but
it would require modification to the SQL that produces the
materialized view.

The issue of NULLS and zeroes, has a number of long and winding
threads on this mailing list.  It might be good to search the archives
and see if any of the discussion helps to clarify things.

Regards,
Jason




On Tue, Jan 26, 2010 at 5:23 PM, Paul Amendola <Paul.Amendola@xxxxxxxxxx> wrote:
> Hi Jason
>
> Thank you for the response and for the reports. Do you know if this has been looked at in terms of exporting the report tables to Excel? When exported to excel, all of the data elements are zero (both true zeros and incomplete data).
>
> Thanks again
> Paul
>
> -----Original Message-----
> From: Jason Pickering [mailto:jason.p.pickering@xxxxxxxxx]
> Sent: Monday, January 25, 2010 11:25 PM
> To: Paul Amendola
> Cc: dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Subject: Re: [Dhis2-devs] Question about Data Completeness
>
> Indeed, a topic dear to my heart and one that we have spent some time
> working on.
>
> You can take a look at this...
>
> http://bazaar.launchpad.net/~dhis2-devs-core/dhis2/trunk/files/head%3A/resources/zm_hmis
>
> In side are both SQL as well as BIRT reports that may give you, after
> modification, what you want.
>
> Best regards,
> Jason
>
>
>
> On Tue, Jan 26, 2010 at 12:35 AM, Paul Amendola
> <Paul.Amendola@xxxxxxxxxx> wrote:
>> When report tables are generated, the tables are populated with a zero,
>> which makes it difficult to determine if the user had entered a zero into
>> the database or left the data element blank. Is there a report that can be
>> generated within DHIS that could be used to analyze data completeness by
>> data element, instead of by report?
>>
>>
>>
>> Thanks,
>>
>> Paul
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>