How can I show average values on charts with decimal places?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I have a bar chart showing averaged values. The values are displayed as labels with up to 13 decimal places, making them unreadable as they overlap. Is there a way to show values with a defined number of decimal places?

Photo of Jeremy

Jeremy

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
If you can't find a solution, a work around is to make a new mirror field with a formula of just your original field, and use the Round() function.

e.g. Round([my field], 0.1)
Photo of Jeremy

Jeremy

  • 0 Points
Thanks. The field I have on the y-axis of the chart is set up with 'summarize by: averaged', so QB is doing the work in calculating averages. I'll give your suggestion a go.