Skip to main content

Hi there, 

 

I’ve created a pie chart in my dashboard interface, and I selected a field to group records by (Gross Margin %). It seems to work well, but it sometimes displays multiples of the same value as separate slices (see multiple 14% and 40% in the legend below). Is this a bug, or am I missing something in the chart setup? I’m really confused why the same value wouldn’t group together automatically. 

 

This is what my setup looks like:

 

If anyone has any ideas, I’m all ears! Thanks so much :)

It sounds like it might be a rounding error. For example, one of the values might be something like 14.1% and the other value might be something like 14.2%. Back in your base, I would add a ROUND() function to your formula to force everything to the correct number of decimal points.

- ScottWorld, Expert Airtable Consultant

Thank you, that’s helpful! Appreciate it. 

Terms & ConditionsAccessibility statement