I have a simple bar chart I want to show the total count (Y axis) for a given formula field. My view grouping does this very well, but when represented as X-axis in my chart, the chart app adds a parenthesis value to the label unexpectedly, growing the number of X-axis values significantly. Attached is view of values (only 7 unique values for X) and how they’re being messed with in the chart. Chart settings added as well.
Any advice is greatly appreciated in advance, thanks!
Hey Bryan, I think this is happening because, even though the “KG/DAY ROUNDED” field is displaying values to one decimal place, it actually contains values that are more than one decimal place.
May I see the
ROUND() function you’re using? It should have a precision of 1 for your situation
Thank you Adam_C!
This was exactly it. I had the ‘Format’ of the function set for 1 decimal, but when I wrapped my whole function with round(X,1), the chart now works as it should.
This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.