English follows Japanese

Numeral system macros for Splunk

こんにちは。
数字を言語固有の表現で文字列に変換するマクロを作りましたのでお知らせします。
splunkbaseで公開されました。
https://splunkbase.splunk.com/app/6595
ダッシュボードで巨大な数値を表示する際に、その大きさを理解しやすくするのに役立つかも知れません。

Hello,
Just an announcement.
I have created macros that converts a number into a string with a language specific expressing.
It was released on splunkbase.
https://splunkbase.splunk.com/app/6595
Language-specific expressions may be useful when displaying huge numbers on a dashboard to make their size easier to understand.

使用例 / Example of Use:

Sample for Japanese speakers

| makeresults
| eval val=1234567890123, val=`numeral_jp(val)`
| table val

1兆2345億6789万123

Sample for English speakers

| makeresults
| eval val=1234567890123, val=`numeral_en(val)`
| table val

1 trillion 234 billion 567 million 890 thousand 123

このAdd-onで提供されるマクロ / Provided macros:

numeral_en(1) : Short Scale for English speaker
numeral_metric_prefix(1) : Metric prefix. kilo, mega, giga, tera, peta, exa, zetta, yotta
numeral_metric_symbol(1) : Metric symbol. K, M, G, T, P, E, Z, Y
numeral_jp(1) : 万進法 for Japanese speaker. 千, 万, 億, 兆
numeral_kr(1) : for Korean speaker. 千, 萬, 億, 兆
numeral_cn_t(1) : Chinese with Traditional Chinese characters. 千, 萬, 億, 兆
numeral_cn(1) : Chinese with Simplified Chinese characters. 千, 万, 亿, 兆
numeral_in_en(1) : for India, South Asia English. thousand, lakh, crore, lakh crore
numeral_in_en2(1) : for India, South Asia English. thousand, lakh, crore, arab
numeral_nl(1) : Long Scale for Nederland. duizend, miljoen, miljard, biljoen
numeral_fr(1) : Long Scale for French. mille, million, milliard, billion
numeral_es(1) : Long Scale for Spanish speaker. mil, millón, millardo, billón
numeral_pt(1) : Long Scale for Portuguese speaker. mil, milhão, bilhão, trilhão

ver1.1.1から下記マクロも使用可能になりました。 / Followings also provided since v1.1.1

numeral_binary_symbol(1) : Binary symbol. KiB, MiB, GiB, TiB, PiB, EiB, ZiB, YiB, RiB, QiB
numeral_binary_symbol(2) : Binary symbol with arg for rounding digits.

参考 / ref
次の記事 "Splunkで大きな数のBytesを人が見やすい単位（KiB, MiB, GiB）に変換する方法"
Next article "How to convert large bytes to human readable units (e.g. Kib, MiB, GiB)"

詳細 / More details

詳細は、 https://splunkbase.splunk.com/app/6595 の「details」タブをクリックしてご確認下さい。
See details tab on https://splunkbase.splunk.com/app/6595

なお、インストール先はサーチヘッドです。
Install this add-on into your search heads.

より高度な活用例 / Advanced examples

すべての提供マクロの使用例 / Sample usage for using all provided macros.

6桁を超える場合は、下3桁を四捨五入して表示する。
With rounding lowest 3 digit if over 6 digit.

| makeresults count=35
| streamstats count as digit
| eval val=pow(10,digit-1), val=val+random()%val.".".printf("%02d",random()%100)
| foreach metric_prefix metric_symbol binary_symbol en es pt in_en in_en2 jp kr cn_t cn nl fr [eval <<FIELD>>=val]
| table digit val metric_prefix metric_symbol binary_symbol en es pt in_en in_en2 jp kr cn_t cn nl fr
| fieldformat val=tostring(val,"commas")
| fieldformat metric_prefix=`numeral_metric_prefix(if(log(metric_prefix,10)>6,round(metric_prefix,-3),metric_prefix))`
| fieldformat metric_symbol=`numeral_metric_symbol(if(log(metric_symbol,10)>6,round(metric_symbol,-3),metric_symbol))`
| fieldformat binary_symbol=printf("% 10s",`numeral_binary_symbol(binary_symbol,2)`)
| fieldformat en=`numeral_en(if(log(en,10)>6,round(en,-3),en))`
| fieldformat es=`numeral_es(if(log(es,10)>6,round(es,-3),es))`
| fieldformat pt=`numeral_pt(if(log(pt,10)>6,round(pt,-3),pt))` 
| fieldformat in_en=`numeral_in_en(if(log(in_en,10)>6,round(in_en,-3),in_en))`
| fieldformat in_en2=`numeral_in_en2(if(log(in_en2,10)>6,round(in_en2,-3),in_en2))`
| fieldformat jp=`numeral_jp(if(log(jp,10)>6,round(jp,-3),jp))`
| fieldformat kr=`numeral_kr(if(log(kr,10)>6,round(kr,-3),kr))`
| fieldformat cn_t=`numeral_cn_t(if(log(cn_t,10)>6,round(cn_t,-3),cn_t))` 
| fieldformat cn=`numeral_cn(if(log(cn,10)>6,round(cn,-3),cn))`
| fieldformat nl=`numeral_nl(if(log(nl,10)>6,round(nl,-3),nl))`  
| fieldformat fr=`numeral_fr(if(log(fr,10)>6,round(fr,-3),fr))`

2025/01/21追記

ver3.x.x では新たな機能も追加されました。
下記記事もぜひご確認ください。