Dashboard table panel decimal rounding?
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!

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 valHowever 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 
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 02 decimal digits depending on trailing zeroes.
Please sign in to leave a comment.
Comments
4 comments