topic Re: How to format large number to display millions? in Dashboards & Visualizations

How to format large number to display millions?

mihir_hardas — Wed, 18 May 2022 16:53:32 GMT

I created a table visualization in dashboard studio. Search query has large numbers. How to format that number to display millions as 1.28M i.e with letter M

Not a mini-program with eval please. Need a good function, format specifer

Re: How to format large number to display millions?

richgalloway — Wed, 18 May 2022 17:24:35 GMT

There's no Dashboard Studio option or function that do what you ask. Consider asking for it at https://ideas.splunk.com.

In the meantime, you can get the same effect with a little more SPL. Use fieldformat to convert millions into a smaller number. Use fieldformat instead of eval to preserve the original field value.

| fieldformat value = value / 1000000

Then set these visualization options (as well as any others you need):

"options": { "unit": "M", "numberPrecision": 3 }

Re: How to format large number to display millions?

mihir_hardas — Mon, 23 May 2022 05:40:41 GMT

Hi,

somehow this does not work ! 😞

Re: How to format large number to display millions?

richgalloway — Mon, 23 May 2022 15:57:18 GMT

Tell us more, please. What results do you get? Can you share the XML for that part of the dashboard?

Re: How to format large number to display millions?

mihir_hardas — Mon, 30 May 2022 13:45:57 GMT

If I get number as output, 163,282,548 then a function should be able to convert it to International units of millions, billions by a symbol = M. So the above should read as 163.3 M

There should be arguments for number of digits for rounding etc

Re: How to format large number to display millions?

mihir_hardas — Mon, 30 May 2022 13:50:41 GMT

Example :

index=log-13120-nonprod-c laas_appId=qbmp.prediction-engine ("current predicted as" OR "predicted as Prediction")

| lookup freq_used_jobs_bmp_3months.csv jobname output jobname local=true
| stats count(predictionStatus) | fieldformat count=tostring(count,"commas")

This results into a large number of 163,071,022.
If we have a good function for converting into million, billion dynamically as per the result. Also a format specifier if we want the result in million or billion.

Eg above can be 163.1 M or 0.1B like that.

Re: How to format large number to display millions?

richgalloway — Mon, 30 May 2022 14:59:12 GMT

There is no function that does what you describe. Feel free to write one or suggest it at https://ideas.splunk.com.

You still haven't explained what you meant by "somehow this does not work" in response to my first answer.

Re: How to format large number to display millions?

tfujita_splunk — Sat, 04 Feb 2023 01:36:52 GMT

Perhaps this could be a solution.

How to convert a large number to string with expressions of long and short scales, or neither.

https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-large-number-to-string-with-expressions-of-long/m-p/629383

Numeral system macros for Splunk

https://splunkbase.splunk.com/app/6595