View Issue Details

This bug affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
19647Bug reportsStatisticspublic2024-09-26 21:48
Reporterlozam Assigned Totibor.pacalat  
PrioritynoneSeverityminor 
Status feedbackResolutionopen 
Product Version6.5.x 
Summary19647: Statistics calculation error for number tables with free fields
Description

When using tables of numbers with a text field and not a drop-down list going from 1 to 10, this poses a problem when generating statistics since the code goes from 0 to 10 maximum. If a user puts a different value not between 0 and 10, the statistics generated are therefore false.

Steps To Reproduce

Step 1 :
Create a questionnaire. Create a question group. Create a “Table (numbers)” type question. Create subquestions to create a table of 2 rows * 3 columns. Keep advanced question options as default. Duplicate this question which will serve as a reference for the bug. Modify a single advanced option (hidden menu on the right): set “text entry” to yes.

Step 2 (normal behavior):
Activate the questionnaire. Run the questionnaire. Operate the questionnaire as a respondent and enter answers between 1 and 10 3 or 4 times. Put the same answers in both questions in order to have a comparison. Edit the statistics: we will see that they are correct. This provides a baseline for normal software behavior.

Step 3 (abnormal behavior):
Duplicate the questionnaire. Run the questionnaire again, skip only in the answers with free number areas, put different numbers from 1 to 10. (For example 20, 50...). Edit the statistics: we will see that the histograms are false by omitting values ​​outside the range 1 to 10.

TagsNo tags attached.
Bug heat8
Complete LimeSurvey version number (& build)CE 6.5.11+240605
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySQL5
Server OS (if known)UBUNTU 20.04
Webserver software & version (if known)
PHP VersionPHP 7.4

Users monitoring this issue

lozam

Activities

tibor.pacalat

tibor.pacalat

2024-07-11 18:09

administrator   ~80609

@lozam if you are referring to this screen, then you are correct (see screenshot).

lozam

lozam

2024-07-16 11:17

reporter   ~80628

Hello @tibor.pacalat

Thank you for confirming the bug I reported on LimeSurvey. I would like to inquire about the next steps we should take to address this issue.

Could you please advise if we are responsible for correcting this bug? If so, do you have any recommendations regarding the functionality or approach we should follow to implement the fix effectively? Alternatively, if you have a proposed solution or a patch available, we would greatly appreciate your guidance on how to proceed.

Your expertise and advice would be invaluable in ensuring we handle this correctly.

tibor.pacalat

tibor.pacalat

2024-07-17 14:25

administrator   ~80646

@lozam I assigned it to Gabriel and it should be fixed soon.

lozam

lozam

2024-07-17 15:37

reporter   ~80650

@tibor.pacalat Thank you for your feedback. If you need any help, I am a PHP developer and I can assist you to fix it

gabrieljenik

gabrieljenik

2024-07-18 22:14

manager   ~80662

So, when the dropdown appears, evertything is working ok, right? Each cell is treated as a single choice question (1-10).

When the dropdown doesn't show up, should we make each cell of the numeric array to be trated (and its stats shown) as a single numeric input?

lozam

lozam

2024-07-19 12:13

reporter   ~80667

Indeed when the drop-down list is in place it works, but when we set up the free fields (input) it does not take into account the results above 10 and this is linked to this code https://github .com/LimeSurvey/LimeSurvey/blob/9ae2df4d3fdf2afe01b56ac68714c6c3b201c4c4/application/helpers/qanda_helper.php#L3964

gabrieljenik

gabrieljenik

2024-07-19 13:34

manager   ~80669

Last edited: 2024-07-19 13:36

Yes, the problem is how shall those values above 10 be treated when processing stats

lozam

lozam

2024-07-19 15:11

reporter   ~80675

I think there are several solutions:

  • Show the values ​​on the graph.
  • Show that only values ​​between 0 and 10 will be taken into account in the calculation, and that values ​​greater than 10 will not be included in the calculation of statistics.

I don't know if other people use this feature and can give their opinion?

tibor.pacalat

tibor.pacalat

2024-07-19 16:32

administrator   ~80677

I don't know how often this feature is used, but I am also wondering why are we only showing values between 0-10.
IMO we should be able to plot charts that show arbitrary values, not being restricted by something.

gabrieljenik

gabrieljenik

2024-07-19 21:29

manager   ~80678

@c_schmitz thoughts?

gabrieljenik

gabrieljenik

2024-07-19 21:30

manager   ~80679

When dropdown is not shown, I would make each cell of the numeric array to be trated (and its stats shown) as a single numeric input

Issue History

Date Modified Username Field Change
2024-07-09 08:58 lozam New Issue
2024-07-09 08:58 lozam Issue Monitored: lozam
2024-07-09 08:58 lozam Bug heat 0 => 2
2024-07-11 18:09 tibor.pacalat Note Added: 80609
2024-07-11 18:09 tibor.pacalat File Added: Screenshot 2024-07-11 at 18.07.47.png
2024-07-11 18:09 tibor.pacalat Bug heat 2 => 4
2024-07-11 18:09 tibor.pacalat Status new => confirmed
2024-07-16 11:17 lozam Note Added: 80628
2024-07-16 11:17 lozam Bug heat 4 => 6
2024-07-16 16:47 tibor.pacalat Assigned To => gabrieljenik
2024-07-16 16:47 tibor.pacalat Status confirmed => assigned
2024-07-17 14:25 tibor.pacalat Note Added: 80646
2024-07-17 15:37 lozam Note Added: 80650
2024-07-18 22:14 gabrieljenik Status assigned => feedback
2024-07-18 22:14 gabrieljenik Note Added: 80662
2024-07-18 22:14 gabrieljenik Bug heat 6 => 8
2024-07-19 12:13 lozam Note Added: 80667
2024-07-19 12:13 lozam Status feedback => assigned
2024-07-19 13:34 gabrieljenik Note Added: 80669
2024-07-19 13:36 gabrieljenik Note Edited: 80669
2024-07-19 15:11 lozam Note Added: 80675
2024-07-19 16:32 tibor.pacalat Note Added: 80677
2024-07-19 21:29 gabrieljenik Note Added: 80678
2024-07-19 21:30 gabrieljenik Note Added: 80679
2024-09-26 21:48 gabrieljenik Assigned To gabrieljenik => tibor.pacalat
2024-09-26 21:48 gabrieljenik Status assigned => feedback