Avatar
Nathan Beltran
  • Updated
Follow

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

 

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.

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

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

3 comments

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?

    8
    Comment actions Permalink
  • Avatar
    Rajesh Goel
    • Edited

    Moreover the aggregate functions cannot be plotted as graph if it is not a number. So please suggest a viable solution if I want to show only 2 decimals.

    I did the below but now it is not showing me it as graph:

    • | round(_avg, 1) as _avg
    • | format("%.1f", _avg) as _avg

    If I add the below (to the above):

    • | num(_avg) as _avg

    then it enables the graphing option (like chart) but it displays the trailing 3 zeros, which I do not want

    • 47.90000

    Any suggestion?

    0
    Comment actions Permalink
  • Avatar
    Phil Cutajar

    Format allows you do specify the decimal places you want. To eliminate decimal places, format the output with zero decimal places...

    • | sum(Received) as Received, sum(Processed) as Processed
    • | (Processed / Received)*100 as Percent | format("%.0f",Percent) as Percent

    If you want two decimal places, then... 

    • | format("%.2f",Percent) as Percent

     

    0
    Comment actions Permalink

Please sign in to leave a comment.

Related articles