View Issue Details

IDProjectCategoryView StatusLast Update
14462Bug reports[All Projects] Statisticspublic2019-03-08 14:53
ReportercdorinAssigned ToMazi 
PrioritylowSeverityminor 
Status resolvedResolutionopen 
Product Version3.15.x 
Target VersionFixed in Version 
Summary14462: Statistics - SUM not calculated correctly for Single Choice Question
Description

I am not sure what column SUM is supposed to display (see screenshot). I cannot understand how those numbers are calculated.

I have also attached a .lsa file.

TagsNo tags attached.
Complete LimeSurvey version number (& build)irrelevant
I will donate to the project if issue is resolvedNo
Browser
Database & DB-Versionirrelevant
Server OS (if known)
Webserver software & version (if known)
PHP Versionirrelevant

Activities

cdorin

cdorin

2019-01-29 16:49

manager  

Test_single_choice.lsa (4,038 bytes)
Selection_076.png (25,799 bytes)
Selection_076.png (25,799 bytes)
cdorin

cdorin

2019-02-11 15:25

manager   ~50499

Will mark it with low priority since Statistics needs to be redone.

Mazi

Mazi

2019-03-04 15:26

partner   ~50755

@cdorin, I introduced that feature for the 5pt scale questions about 10 years ago. The goal is to sum up items 1+2 and 4+5 because when analyzing data of such rating questions these answers are often grouped like "X percent LIKE" and "Y percent DISlike" item ABC.

The numbers look correct to me :
1+2 = 2 of 4 answers = 50%,
3 = 1 of 4 = 25%
4+5 = 1 of 4 = 25%

cdorin

cdorin

2019-03-04 16:12

manager   ~50757

@Mazi, that's fantastic. Now I can finally understand those numbers :D

Isn't the column name, sum, a bit misleading?

Mazi

Mazi

2019-03-04 16:20

partner   ~50760

@cdorin, I agree, I think back then it was originally named "Aggregated values". Feel free to adjust this as it makes sense.

Mazi

Mazi

2019-03-07 08:33

partner   ~50818

@cdorin, please close this one once you updated the documentation. Thanks!

cdorin

cdorin

2019-03-08 14:53

manager   ~50852

Updated it now: https://manual.limesurvey.org/Statistics#FAQs

Issue History

Date Modified Username Field Change
2019-01-29 16:49 cdorin New Issue
2019-01-29 16:49 cdorin Status new => assigned
2019-01-29 16:49 cdorin Assigned To => LouisGac
2019-01-29 16:49 cdorin File Added: Test_single_choice.lsa
2019-01-29 16:49 cdorin File Added: Selection_076.png
2019-02-11 15:25 cdorin Priority none => low
2019-02-11 15:25 cdorin Note Added: 50499
2019-03-04 15:26 Mazi Note Added: 50755
2019-03-04 15:29 Mazi Assigned To LouisGac => Mazi
2019-03-04 16:12 cdorin Note Added: 50757
2019-03-04 16:20 Mazi Note Added: 50760
2019-03-07 08:33 Mazi Note Added: 50818
2019-03-08 14:53 cdorin Status assigned => resolved
2019-03-08 14:53 cdorin Note Added: 50852