Upgrade from 3.12 to 4.24 and now when generating statistics, the filter correctly shows the filter shows "number of records in this query" correctly, but the total (gross) value still holds to "Total records in survey" value leading to percentages that extrapolate the real (filtered) number of records and percentages are off.
Tried to find if there is a new setup where is defined and looked at the manual but could not find anything. In version 3.12 it works correctly - total (gross) is calculated correctly. It doesn't seem to matter if "Subtotals based on displayed questions" is checked or not. The same results show up.

Please submit a bug report - www.limesurvey.org/community/bug-tracker .

Thanks, done at: bugs.limesurvey.org/view.php?id=16326

Same issue here. Version 4.2.4+200520 (issue discovered in 4.2.2+200504) running on Windows Server 2012R2 + IIS8 + MSSQL Server 2014 + PHP 7.4.1. Extension to this issue - after hitting View Statistics and getting the error above, click on the Display responses button. The Survey responses will appear showing filtered results. Change the header row filter for 'completed' from All to Yes or No. Error will popup (see attached images).

Error 500: {"success":false,"message":"CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'datestamp'.","error"

mikecouchman wrote: Error 500: {"success":false,"message":"CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'datestamp'.","error"

My opinoion : another issue, must be reported separatly

Yes, please report them separately. I will go through more tickets in the upcoming days.

I cant actually login to the bug tracker. I can login to limesurvey.org (using the account I am posting this with), but when I goto the bug tracker, using the same credentials, its denies me.

Usually the same credentials should work. Send an email to the Limesurvey support, if you are sure that your password is correct. If you have it changed on Limesurvey.org just shortly before trying to login into Mantis, then maybe the dabases haven't been syncronized yet.