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.