dhis2-users team mailing list archive

Thread
Date

AGGEGRATED DATASET: YES / NO VALUE TYPE DOES NOT COUNT THE NOs - ALTERNATIVE?

To: "dhis2-users@xxxxxxxxxxxxxxxxxxx" <dhis2-users@xxxxxxxxxxxxxxxxxxx>, "dhis2-devs@xxxxxxxxxxxxxxxxxxx" <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
From: Carolyn Tauro <carolyn.tauro@xxxxxxxxxxxxxx>
Date: Fri, 16 Jun 2017 09:46:16 +0000
Accept-language: en-GB, en-US
Authentication-results: lists.launchpad.net; dkim=none (message not signed) header.d=none;lists.launchpad.net; dmarc=none action=none header.from=london.msf.org;
Cc: Theo Krommydakis <theo.krommydakis@xxxxxxxxxxxxxx>, "twoca@xxxxxxxxxxxxxxxx" <twoca@xxxxxxxxxxxxxxxx>
Spamdiagnosticmetadata: NSPM
Spamdiagnosticoutput: 1:99
Thread-index: AdLmhTl37eXSoGw0QgadkNihJ4uMXQ==
Thread-topic: AGGEGRATED DATASET: YES / NO VALUE TYPE DOES NOT COUNT THE NOs - ALTERNATIVE?

Hello,

We have been working on a data set that needs a total scoring on 20 where each Yes = 1. In addition though, we also need to know a count of the items that were scored 0 and those that were not relevant to the project (so there is no value) or not assessed at all.
We've tried the Yes/No value type with an Aggregation type: Count and created three data elements (TEST HS MS DE, TEST HS MS DE 2 and TEST HS MS DE 3). This works quite well for the data entry where we ticked first as Yes, second as No and left the third one blank. However, when trying to visualise this data, the tools counts the number of items with a "Yes", but seems to interpret the "No" as a 0, hence not giving us a count of the same. The second screenshot shows Data viz interprets this. With this kind of interpretation, we are unable to further make indicators to total up some/all of the elements as scores we require.
Is there something we may be missing or perhaps another way of addressing this sort of data set?
Any help is much appreciated.
Thanks,
Carolyn





M?decins Sans Fronti?res/Doctors Without Borders (MSF)
Lower Ground Floor, Chancery Exchange, 10 Furnival Street, London EC4A 1AB
Tel: +44 (0)20 7404 6600 | Fax: +44 (0)20 7404 4466

M?decins Sans Fronti?res/Doctors Without Borders (MSF) is an independent international medical humanitarian organisation that delivers emergency aid in more than 60 countries.

Discuss, debate and get the latest news from MSF:
Online<http://www.msf.org.uk/?utm_campaign=msfemails&utm_source=emailfooter&utm_medium=email&utm_content=home> | Facebook<http://www.facebook.com/msf.english> | Instagram<http://instagram.com/doctorswithoutborders/> | Twitter<http://twitter.com/msf_uk> | Youtube<http://www.youtube.com/channel/UCId9tO5LYlJKgNQKEzgjYOg?sub_confirmation=1> | Subscribe to emails<http://www.msf.org.uk/sign-up-for-msf-uk-emails?utm_campaign=msfemails&utm_source=emailfooter&utm_medium=email&utm_content=emailsignup>

Donate to MSF UK<https://secure.msf.org.uk/Donate/MultiLanding.aspx?type=dd&source=7001&country=000>

MSF (UK) is a company limited by guarantee | English Charity Reg No.1026588 | English Registration No. 2853011

Attachment: HSMS- YesNo Scoring.png
Description: HSMS- YesNo Scoring.png

Attachment: HSMS - YesNo Dat Viz.png
Description: HSMS - YesNo Dat Viz.png