We have a customer who is experiencing wrong values when using the statistics module in Dynamiweb and I've identified an issue:
This is the query which is executed (TotalProductSale.cs) as of now:
The first rows ProductAmount should be 4 and not 8. If I remove the left join from the query I get the correct result:
I've verified this manually by going through the orders in the administration and I believe the left join is causing the issue resulting in the count getting doubled.