Hello,
I have a list report that a user would like to be in chart form. I'm facing a strange problem, because the list and the chart show completely different values, even though they are based on the same query
List values, with supplier N** being the first with 464 800 units. This is the correct number.
(https://i.imgur.com/bKNyTdp.png)
Chart values, this time supplier N** is second with 12 549 600 units.
(https://i.imgur.com/qPOIYp8.png)
As you can see, both items are based on the same query :
(https://i.imgur.com/FOVJfrc.png)
(https://i.imgur.com/VydNyYi.png)
What am I missing ?
That looks like an aggregation problem to me
Indeed it is, the agregation was set to Default and it worked when I put it as Minimum. But why were the values different in the list and in the chart ?