Chart Strangeness

lets say I have 2 simple objects - Quote and Reason … they are a Many (Quote) to One (Reason) relationship.

I want to display a chart that shows the number (of quotes) for each reason code I have.

So far so good.

So the image shows 4 reason codes in the pie chart despite the fact that the table only has 3. The table is actually sorted by an aggregate (count) across the relationship above.

Why I am even seeing a 4th (0) value in my pie chart ?





The 4th zero item - isn’t random (its always showing the same reason type) but if I fiddle the figures then I get another different zero item instead.


OK so doing this seems to have resolved the issue …


Traversing the relationship path then back again.