09304: Matrix Question wrong results because of 0 - LimeSurvey bugs and feature requests

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

09304	Bug reports	Statistics	public	2014-10-16 11:38	2014-10-17 14:29

Reporter	kemweb	Assigned To	c_schmitz
Priority	normal	Severity	feature
Status	closed	Resolution	duplicate

Summary	09304: Matrix Question wrong results because of 0
Description	For a matix question with checkboxes "Matrix (Zahlen)" some results are 0 instead of blank. I don't know where the 0 are coming from maybe user unchecked the boxes or browser issue. Anyway those values are not showing up in the report.
Additional Information	DB Query: SELECT 232943X601X5438H01_SQ001, COUNT( 232943X601X5438H01_SQ001 ) FROM `lime_survey_232943` WHERE 1 GROUP BY 232943X601X5438H01_SQ001 DB Result 232943X601X5438H01_SQ001 COUNT(232943X601X5438H01_SQ001) NULL 0 109 0 3 <--- here are the missing 3 1 15 Excel Export Answer Count Percentage 0 (0) 109 46,78% 1 (1) 15 6,44% No answer 109 46,78%
Tags	No tags attached.

Bug heat	4
Complete LimeSurvey version number (& build)
I will donate to the project if issue is resolved
Browser
Database type & version
Server OS (if known)
Webserver software & version (if known)
PHP Version

User List	There are no users monitoring this issue.

Date Modified	Username	Field	Change
2014-10-16 11:38	kemweb	New Issue
2014-10-16 11:40	kemweb	Note Added: 30800
2014-10-17 08:53	DenisChenu	Relationship added	duplicate of 09188
2014-10-17 08:55	DenisChenu	Note Added: 30807
2014-10-17 08:55	DenisChenu	Project	Feature requests => Bug reports
2014-10-17 14:29	c_schmitz	Status	new => closed
2014-10-17 14:29	c_schmitz	Assigned To	=> c_schmitz
2014-10-17 14:29	c_schmitz	Resolution	open => duplicate

kemweb 2014-10-16 11:40 reporter ~30800	Version is: 2.05+ Build 141003

DenisChenu 2014-10-17 08:55 developer ~30807	This was already fixed for the 0 in http://bugs.limesurvey.org/plugin.php?page=Source/view&id=14474 But not for old answers (or statistics with old answers)