topic Re: decimal in Dashboards & Visualizations https://community.splunk.com/t5/Dashboards-Visualizations/decimal/m-p/555128#M38594 <P>i am not using the&nbsp;| addtotals col=t row=f but the format visualization on the dash</P> Wed, 09 Jun 2021 16:24:10 GMT simo 2021-06-09T16:24:10Z decimal https://community.splunk.com/t5/Dashboards-Visualizations/decimal/m-p/554518#M38527 <P>Hi All,</P><P>I have a Dashboard,&nbsp;with the count of completed requests</P><TABLE width="145"><TBODY><TR><TD width="64">&nbsp;</TD><TD width="81"><A href="https://192.169.2.11:8000/en-US/app/H3G-Operation/detailed_report__completed_billable__msisdn_authentication_test?form.tok_partner=*&amp;form.tok_customer=*&amp;form.tok_data_period.earliest=%40mon&amp;form.tok_data_period.latest=%40d&amp;form.tok_month=1d&amp;form.tok_opco=*" target="_blank" rel="noopener">COMPLETED</A></TD></TR><TR><TD>&nbsp;</TD><TD>46018</TD></TR><TR><TD>&nbsp;</TD><TD width="81">12003</TD></TR><TR><TD>&nbsp;</TD><TD>1889</TD></TR><TR><TD>&nbsp;</TD><TD>1</TD></TR><TR><TD>&nbsp;</TD><TD>4</TD></TR><TR><TD>&nbsp;</TD><TD>7</TD></TR><TR><TD>TOTAL</TD><TD>59922</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>if I add the separator</P><P>| eval COMPLETED= tostring(COMPLETED, "commas")</P><TABLE width="145"><TBODY><TR><TD width="64">&nbsp;</TD><TD width="81"><A href="https://192.169.2.11:8000/en-US/app/H3G-Operation/detailed_report__completed_billable__msisdn_authentication_test?form.tok_partner=*&amp;form.tok_customer=*&amp;form.tok_data_period.earliest=%40mon&amp;form.tok_data_period.latest=%40d&amp;form.tok_month=1d&amp;form.tok_opco=*" target="_blank" rel="noopener">COMPLETED</A></TD></TR><TR><TD>&nbsp;</TD><TD>46,018</TD></TR><TR><TD>&nbsp;</TD><TD width="81">12,003</TD></TR><TR><TD>&nbsp;</TD><TD>1,889</TD></TR><TR><TD>&nbsp;</TD><TD>1</TD></TR><TR><TD>&nbsp;</TD><TD>4</TD></TR><TR><TD>&nbsp;</TD><TD>7</TD></TR><TR><TD>TOTAL</TD><TD>12</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>the total of Dashbord&nbsp;becomes 12. I would like it to become on the total&nbsp;59,922</P><P>how can i solve?</P><P>&nbsp;</P><P>by</P><P>Simone</P> Fri, 04 Jun 2021 17:26:17 GMT https://community.splunk.com/t5/Dashboards-Visualizations/decimal/m-p/554518#M38527 simo 2021-06-04T17:26:17Z Re: decimal https://community.splunk.com/t5/Dashboards-Visualizations/decimal/m-p/554519#M38528 <P>Try this:</P><LI-CODE lang="markup">| fieldformat COMPLETED=tostring(COMPLETED, "commas")</LI-CODE> Fri, 04 Jun 2021 17:28:55 GMT https://community.splunk.com/t5/Dashboards-Visualizations/decimal/m-p/554519#M38528 ITWhisperer 2021-06-04T17:28:55Z Re: decimal https://community.splunk.com/t5/Dashboards-Visualizations/decimal/m-p/555122#M38591 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/225168">@ITWhisperer</a>&nbsp;</P><P>now I'm in this situation</P><TABLE width="145"><TBODY><TR><TD width="64">&nbsp;</TD><TD width="81"><A href="https://192.169.2.11:8000/en-US/app/H3G-Operation/detailed_report__completed_billable__msisdn_authentication_test?form.tok_partner=*&amp;form.tok_customer=*&amp;form.tok_data_period.earliest=%40mon&amp;form.tok_data_period.latest=%40d&amp;form.tok_month=1d&amp;form.tok_opco=*" target="_blank" rel="noopener nofollow noreferrer">COMPLETED</A></TD></TR><TR><TD>&nbsp;</TD><TD>46,018</TD></TR><TR><TD>&nbsp;</TD><TD width="81">12,003</TD></TR><TR><TD>&nbsp;</TD><TD>1,889</TD></TR><TR><TD>&nbsp;</TD><TD>1</TD></TR><TR><TD>&nbsp;</TD><TD>4</TD></TR><TR><TD>&nbsp;</TD><TD>7</TD></TR><TR><TD>TOTAL</TD><TD>59922</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Is it possible to add formatting to the total as well?</P><P>&nbsp;</P><P>Simone</P> Wed, 09 Jun 2021 16:00:19 GMT https://community.splunk.com/t5/Dashboards-Visualizations/decimal/m-p/555122#M38591 simo 2021-06-09T16:00:19Z Re: decimal https://community.splunk.com/t5/Dashboards-Visualizations/decimal/m-p/555125#M38592 <P>It should have already worked</P><LI-CODE lang="markup">| makeresults | eval _raw=" COMPLETED 46018 12003 1889 1 4 7" | multikv forceheader=1 | table COMPLETED | addtotals col=t row=f | fieldformat COMPLETED=tostring(COMPLETED,"commas")</LI-CODE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ITWhisperer_0-1623254863036.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/14561iDA27D8DF2EAA7FFC/image-size/medium?v=v2&amp;px=400" role="button" title="ITWhisperer_0-1623254863036.png" alt="ITWhisperer_0-1623254863036.png" /></span></P><P>Which version of splunk are you using?</P> Wed, 09 Jun 2021 16:08:39 GMT https://community.splunk.com/t5/Dashboards-Visualizations/decimal/m-p/555125#M38592 ITWhisperer 2021-06-09T16:08:39Z Re: decimal https://community.splunk.com/t5/Dashboards-Visualizations/decimal/m-p/555128#M38594 <P>i am not using the&nbsp;| addtotals col=t row=f but the format visualization on the dash</P> Wed, 09 Jun 2021 16:24:10 GMT https://community.splunk.com/t5/Dashboards-Visualizations/decimal/m-p/555128#M38594 simo 2021-06-09T16:24:10Z