Scientific Notation Auto Rounding

I am using ruby and BigDecmial to convert a scientific notation number to decimal, but it's automatically getting rouded to the nearest thousandth. How can I prevent this? I want the full number or at least n^-6 not n^-3.

I have already tried .round(3) and .round(6) at the end of the bigdecimal number, that doens't seem to make any different at all.

Here's my code:

> if [source] =~ "table" {
>     csv{ columns => [  "TIME", "DATE", "START_TIMESTAMP", "STOP_TIMESTAMP", "ELAPSED_TIME", "MVS_SYSTEM_ID", "CICS_SPEC_APPLID", "CICS_GEN_APPLID", "JOB_NAME", "PGM_NAME", "TRANSACTION_ID", "TRANSACTION_NUM", "ORIG_ABEND_CODE", "CURR_ABEND_CODE", "CICS_USER", "SYNCPOINTS", "TERM_WAIT", "DISPATCH_TIME", "CPU_TIME", "RLS_CPU_TIME", "SUSP_TIME", "SYNCTIME", "DISP_CICS_USER", "JAVA_CPU_TIME", "L8_TCB_DISP_TIME", "S8_TCB_DISP_TIME", "RMI_TIME", "RMI_SUSP_TIME" ]
>     separator => "," }
>         ruby {
>            code => "event.set('[CPU_TIME_SECONDS]',BigDecimal(event.get('[CPU_TIME]')))"
>         }
> }

Here's a screen shot of what is happening:

I think this is presentation issue in Kibana. If you expand one of those events and switch to the JSON tab what is the value of CPU_TIME_SECONDS?

1 Like

Oh wow, yea the numbers are all there. How do I change that in Kibana?

I do not run Kibana, but the documentation is here.

1 Like

Thanks! Documentation had what I needed. But if anyone else sees this: search the doc above for duration and then in kibana go to management > index patterns > edit <your field>