Dashboard table panel decimal rounding?

Follow

Cameron Besse

• August 17, 2020 21:20

Am I correct that I can't modify the decimal rounding in a dashboard table panel?

All of the decimal values in my table (which are being rounded to 3 decimal places in the backing query) have at most 2 decimal places, and trailing zeroes are also being truncated.  This creates a rather haphazard looking column in my opinion.

I'm not sure I understand why the format specified in the query is not preserved?  I understand imposing a reasonable maximum number of digits, but this seems silly...

Thanks in advance!

0

• 

  Harinder Bhandari

  • August 18, 2020 05:07

  You can use the format operator. Search for "format" operator in Sumo Logic documentation.

  1. Use the "format" operator to reformat the values. For example

  | 5.2342234 as val
  | format("%.3f", val) as val

  However this will again simply drop the last x number of digits and does not round these up/down to the proper decimal, so this could lead to some inaccuracy.

  2. A more precise way to get the decimal spaces is to use the round operator along with the format operation.

  | | 5.2342234 as val
  | val*100 as val
  | round(val)/100 as val
  | format("%.3f", val) as val

  0

  Comment actions Permalink
• 

  Cameron Besse

  • August 18, 2020 14:18
  • Edited

  Hi Harinder,

  Thanks for your reply.  I actually tried the format operator as well as the round operator, and neither seems to affect the number of decimals displayed in the table...  The result from the query is correct, but the table still displays 0-2 decimal digits depending on trailing zeroes.

  0

  Comment actions Permalink
• 

  Harinder Bhandari

  • August 19, 2020 19:32

  Hi Cameron,

  Since it needs more investigation, It would be best if you open a support ticket with Sumo Logic providing the dashboard and panel name. we will help you with the solution.

   

  Thanks,

  Harinder

  1

  Comment actions Permalink
• 

  Cameron Besse

  • August 27, 2020 16:35

  Thanks, I've opened a ticket.  I just wanted to make sure it wasn't user error first.  :P

  0

  Comment actions Permalink

Please sign in to leave a comment.