dhis2-kenya team mailing list archive

[samuel cheburet <samuelcheburet@xxxxxxxxx>]

Dear all,


This is still a lot followup on the subject of pivot table and i still stand
the  pivot still does not work and if work 20%. My question is

How can we improve on this area? It the development of Pivot outsource  by
HISP making it challenge??

I have use the send dhis2ke pivot i n office 2007 and 2010 and it work in
some cases. Also, it is not comprehensive like MOH 717 have only inpatient
and lack general outpatient. Can it be show on how to design from initial so
that district can develop or create one without fixed dataset or reports
also if we have to use pre created than it should be capturing all areas
with or without data.

Let continue testing until it is full mature to say deploy to district. it
is a major flow irrespective of success download and refresh. and also can
we have version number for tracking purpose.

In the area of web pivot district real appreciate and they opt to use than
excel but still room for improvement.


Lars, In dataset report, there is need to improve on outpatient download
because it contraction of the function. if download MOH705A the result have
< and > data which eliminate data element in addition in MOH705B and vie.
could it be possible to have either same format added missing data element
or remain sole function if its under five it is only under five data.

Also, is it possible to provide total for download like if downloading data
for January-october the next sheet should be total summary and each sheet
should have total summary.


Cheers to all. the sky is the limit





On Sun, Oct 9, 2011 at 1:54 PM, samuel cheburet <samuelcheburet@xxxxxxxxx>wrote:

> Dear all,
>
>
> On the above subject. I have tested the pivot table and have some deficit.
>
> one the pivot table is fixed to .xlsx and not xls. This mean all the Ms
> office for window require upgrade to office 2007 and above.Also the pivot
> table does not capture all the dataset as it apper in the database even if
> the data is there and grouped.
>
> i proposed one to create pivot based on the existing format of Ms office
> e.g dhis2ke_pivots.xlsx or dhis2ke_pivots.xls. Also it should be auto
> generate pivot.
>
>
> Cheers
>
> --
> Samuel Cheburet
> Ministry Of Health
> P.O. Box 20781
> Nairobi, Kenya
> Mobile- 0721624338
>
> *Don't Compromise The Quality! Don't Risk It! apply Available Standards to
> Achieve Your/organizational Goal.*
>



-- 
Samuel Cheburet
Ministry Of Health
P.O. Box 20781
Nairobi, Kenya
Mobile- 0721624338

*Don't Compromise The Quality! Don't Risk It! apply Available Standards to
Achieve Your/organizational Goal.*