dhis2-devs team mailing list archive

["Laura E. Lincks" <laura.lincks@xxxxxxxxxxxxxxxxx>]

Version: 2.18
Lesotho MOH DHIS

We are trying to report on one indicator summed by year broken out by
OrgUnitOwnership.

Attempt # 1: When we run the query in a pivot table we are able to get the
correct data (see below and attached diagram CorrectDataNoBreakdown.png)
When we convert that output to a chart of any kind (we opted for a line
graph) we get the right numbers to appear in the chart but the data is not
a multi-line graph breaking down the 4 different OrgUnitOwnership types. It
just shows one line for the total of all OrgUnitOwners.
[image: Inline image 3]

Attempt # 2: When we change the chart and move Data to a Dimension, we get
the OrgUnitOwnership breakdown but the data itself is vastly incorrectly
increased (see below and attached diagram CorrectBreakdownWrongData.png).
Interestingly, we cannot create a chart or a pivot table with these
settings from scratch. We have to revise the chart we created in Attempt #
1. If we try create a pivot table or a chart with the settings in Attempt
#2, DHIS gives us the error: "The page at hmis.gov.ls says: 0 communication
failure undefined"

[image: Inline image 4]

We can take the table data in Attempt #1 and create a graph in Excel (see
below) but we cannot create the same thing in DHIS. We want to incorporate
this into a dashboard. Any ideas?

[image: Inline image 2]
-- 

*Laura E. Lincks*
Database Manager/Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132

Attachment: CorrectBreakdownWrongData.png
Description: PNG image

Attachment: CorrectDataNoBreakdown.png
Description: PNG image