| Thread Previous • Date Previous • Date Next • Thread Next |
Hello, We have been working on a data set called Health Structures: Minimum Standards. This 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. Although we initially made DEs with a validation rule that the number should be either 0 or 1, the data entry allowed a number other than these to be entered. The next thing we did then was to use the Yes/No value type with an Aggregation type: Count - Screenshot 1 (attached). We 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 Carolyn Tauro OCA HIS Medical Content Officer Manson Unit - UK Médecins Sans Frontières OCA 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
| Thread Previous • Date Previous • Date Next • Thread Next |
