AnsweredAssumed Answered

Summation Report bug?

Question asked by Francesca Shiekh on Mar 16, 2016
Latest reply on Apr 11, 2016 by Caim Astraea

I have a summation report with bar chart number of cases by date (day).

The results table shows duplicate and missing dates.

I did a show query and when I cut and paste the sql in mysql workbench on the same database instance I get different results from what I see in the report.

 

Any thoughts on why reports does not have the correct data?

 

Note 3/10 has 43 cases and 3/9 has 65 cases in MySql

while on the report

3/10 is there twice with 50 and 43 cases respectively

 

Similarly for 3/5 and 3/6.

From MySql:

cases.jpg

 

From Report:

fromReport.jpg

 

thanks,
FrancescaS

Outcomes