topic Remove decimal values in a table in Dashboards & Visualizations https://community.splunk.com/t5/Dashboards-Visualizations/Remove-decimal-values-in-a-table/m-p/688610#M56385 <P>Hi all, I have table where the values are showing as</P><P>234.000000</P><P>56.000000</P><P>But we want to remove zeros and shown only</P><P>234</P><P>56</P><P>How we do this???</P> Fri, 24 May 2024 13:50:06 GMT vishwa 2024-05-24T13:50:06Z Remove decimal values in a table https://community.splunk.com/t5/Dashboards-Visualizations/Remove-decimal-values-in-a-table/m-p/688610#M56385 <P>Hi all, I have table where the values are showing as</P><P>234.000000</P><P>56.000000</P><P>But we want to remove zeros and shown only</P><P>234</P><P>56</P><P>How we do this???</P> Fri, 24 May 2024 13:50:06 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Remove-decimal-values-in-a-table/m-p/688610#M56385 vishwa 2024-05-24T13:50:06Z Re: Remove decimal values in a table https://community.splunk.com/t5/Dashboards-Visualizations/Remove-decimal-values-in-a-table/m-p/688614#M56386 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/251452">@vishwa</a>,</P><P>use eval round (<A href="https://docs.splunk.com/Documentation/SCS/current/SearchReference/MathematicalFunctions#round.28.26lt.3Bnum.26gt.3B.2C_.26lt.3Bprecision.26gt.3B.29" target="_blank">https://docs.splunk.com/Documentation/SCS/current/SearchReference/MathematicalFunctions#round.28.26lt.3Bnum.26gt.3B.2C_.26lt.3Bprecision.26gt.3B.29</A><span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><LI-CODE lang="markup">| eval your_field=round(your_field,0)</LI-CODE><P>Ciao.</P><P>Giuseppe&nbsp;</P> Fri, 24 May 2024 13:55:17 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Remove-decimal-values-in-a-table/m-p/688614#M56386 gcusello 2024-05-24T13:55:17Z Re: Remove decimal values in a table https://community.splunk.com/t5/Dashboards-Visualizations/Remove-decimal-values-in-a-table/m-p/688633#M56387 <P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/161352">@gcusello</a>&nbsp;,@Thank&nbsp; you</P> Fri, 24 May 2024 17:28:04 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Remove-decimal-values-in-a-table/m-p/688633#M56387 vishwa 2024-05-24T17:28:04Z