View Issue Details

This bug affects 1 person(s).
 10
IDProjectCategoryView StatusLast Update
15980Bug reportsStatisticspublic2020-09-07 11:49
ReporterMazi Assigned Togabrieljenik  
PrioritynoneSeveritypartial_block 
Status closedResolutionfixed 
Product Version3.22.8 
Summary15980: No results shown for selected date questions at statistics
Description

Equation or text display questions are not available to be selected at the statistics feature. But the date questions can be selected. Thing is that even when you are selecting a date question, no results are shown for those questions, they are simply ignored.
You can call that a missing feature, I'd consider it a bug since we can select the question but nothing gets shown for it. We could simply show date question results similar to text input questions (list of text strings) because you can't really put date details into charts.
Brave people would also try adding a min/max date filter similar to the one we have for the submit date.

Steps To Reproduce

Pick an activated survey with a date question.
Select only the data question at the statistics module.
There are no results shown for date questions

Additional Information

This is most probably also an issue at LS 4

TagsNo tags attached.
Attached Files
Bug heat10
Complete LimeSurvey version number (& build)Version 3.17.3+190429
I will donate to the project if issue is resolvedNo
BrowserChrome
Database type & versionMySQL 5
Server OS (if known)?
Webserver software & version (if known)
PHP Version7.x

Relationships

related to 16598 closedgabrieljenik Statistics: Criteria not cleared for text question results 

Users monitoring this issue

There are no users monitoring this issue.

Activities

ollehar

ollehar

2020-03-13 11:07

administrator   ~56441

Please update to the latest version and try again. Thank you.

Mazi

Mazi

2020-03-13 13:53

updater   ~56442

Last edited: 2020-04-01 17:30

@ollehar, just tested with latest Version 3.22.8+200309. There now is a filter for min/max date but no results of the date question are shown at all, even though the question was selected.

image.png (84,755 bytes)   
image.png (84,755 bytes)   
question_selection.png (29,233 bytes)   
question_selection.png (29,233 bytes)   
ollehar

ollehar

2020-03-13 14:15

administrator   ~56443

Last edited: 2020-04-01 17:30

I will assign this to Dorin and he'll have a look on Monday. He's on vacation this week. Thanks for reporting, Marcell!

gabrieljenik

gabrieljenik

2020-08-17 17:56

manager   ~59491

https://github.com/LimeSurvey/LimeSurvey/pull/1553

Date/Time responses are treated as "Answer" when the value is not null, and "No answer" when it's null.
Equation questions are handled as text. It seems they always have a value, so "Not displayed" may always be 0.
Condition had to be updated as to work with dates. It may have an impact on some DB engine (not sure).

Found issue 16598 while reviewing.
Both 16598 and 15980 could be happening on LS4 as well

user225042

2020-08-20 12:38

  ~59552

Tested the issue before pulling the PR, Issue exist. Tested the issue after pulling the PR, below are my findings:
Screenshot 1: Before PR, Date question is not displayed in results
Screenshot 2:After PR, Date question is displayed in results
Please refer the attachment for more details, Working as Expected

gabrieljenik

gabrieljenik

2020-08-25 17:36

manager   ~59612

Fix committed to 3.x-LTS branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=30424

lime_release_bot

lime_release_bot

2020-09-07 11:49

administrator   ~59722

Fixed in Release 3.23.2+200908

Related Changesets

LimeSurvey: 3.x-LTS 90810b8f

2020-08-14 20:32:04

gabrieljenik

Details Diff
Fixed issue 15980: No results shown for selected date questions at statistics

- Date/Time responses are treated as "Answer" when the value is not null, and "No answer" when it's null.
- Equation questions are handled as text. It seems they always have a value, so "Not displayed" may always be 0.
- Condition had to be updated as to work with dates. It may have an impact on some DB engine (not sure).
Affected Issues
15980
mod - application/helpers/admin/statistics_helper.php Diff File
mod - application/views/admin/export/statistics_subviews/_question.php Diff File

LimeSurvey: 3.x-LTS 460a012a

2020-08-25 17:36:06

ollehar1


Committer: GitHub Details Diff
Fixed issue 15980: No results shown for selected date questions at statistics Affected Issues
15980
mod - application/helpers/admin/statistics_helper.php Diff File
mod - application/views/admin/export/statistics_subviews/_question.php Diff File

Issue History

Date Modified Username Field Change
2020-03-12 21:26 Mazi New Issue
2020-03-13 11:07 ollehar Note Added: 56441
2020-03-13 11:07 ollehar Status new => feedback
2020-03-13 13:53 Mazi File Added: image.png
2020-03-13 13:53 Mazi File Added: question_selection.png
2020-03-13 13:53 Mazi Note Added: 56442
2020-03-13 13:53 Mazi Status feedback => new
2020-03-13 14:13 ollehar Product Version 3.19.1 => 3.22.8
2020-03-13 14:14 ollehar Assigned To => cdorin
2020-03-13 14:14 ollehar Status new => assigned
2020-03-13 14:15 ollehar Note Added: 56443
2020-03-13 14:17 ollehar Note Edited: 56443
2020-04-01 17:30 cdorin Zoho Sprints => |Yes|
2020-04-01 17:30 swendrich Zoho Sprints ID => 14469000000017181
2020-08-17 17:26 gabrieljenik Issue cloned: 16598
2020-08-17 17:26 gabrieljenik Relationship added related to 16598
2020-08-17 17:56 gabrieljenik Note Added: 59491
2020-08-20 12:38 user225042 Note Added: 59552
2020-08-20 12:38 user225042 File Added: 15980_Dateques_Statis_Notshowed.png
2020-08-20 12:38 user225042 File Added: 15980_Dateques_Statis_showed.png
2020-08-25 17:36 ollehar1 Changeset attached => LimeSurvey 3.x-LTS 460a012a
2020-08-25 17:36 gabrieljenik Changeset attached => LimeSurvey 3.x-LTS 90810b8f
2020-08-25 17:36 gabrieljenik Note Added: 59612
2020-08-25 17:36 gabrieljenik Assigned To cdorin => gabrieljenik
2020-08-25 17:36 gabrieljenik Resolution open => fixed
2020-09-07 11:49 lime_release_bot Zoho Sprints Yes => |Yes|
2020-09-07 11:49 lime_release_bot Note Added: 59722
2020-09-07 11:49 lime_release_bot Status assigned => closed