Avatar
Nathan Beltran
  • Updated
Follow

How do I remove the decimal point from a Single Value Chart?

Question:

Whenever I display an integer within a Single Value panel type I am seeing a decimal point used when the number is less than 100. How do I remove the decimal point value from the String Single Value Chart?

For example, the chart value for the following query is showing with decimals.

| count as count by status_code

 

Screen_Shot_2017-10-12_at_2.06.11_PM.png

 

Answer:

For integers displayed within a Single Value panel, Sumo Logic will always attempt to display 3 digits. So if the number displayed is less than 100 you will see a decimal place added to the number. If you do not want to see the decimals you will need to convert the integer value to a "String" type within your query. For example 

| count as count by status_code
| tostring(count) as count

 

Screen_Shot_2017-10-12_at_2.11.11_PM.png

 

 

Comments

1 comment

Sort by Date Votes
  • Avatar
    Chris Watson

    But if it's an integer, why show it as a decimal?

    I've got this Single Value Viewer, which will only ever be an integer:

    I don't want to convert to a string because then I can't use the Colours by Value Range feature, which is very handy on a dashboard.

    Any plans to let us choose the number of decimal places to show?

    4
    Permalink

Please sign in to leave a comment.

Related articles