Chart Strangeness

Liberty Create - Build Advice
1

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.

image
image1232×758 25.8 KB

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 ?

image

image

Thanks

Haydn

2

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.

H

3

OK so doing this seems to have resolved the issue …

image

Traversing the relationship path then back again.