topic Display 6 digit number with decimal in Dashboards & Visualizations

Display 6 digit number with decimal

MGlass — Thu, 08 Aug 2024 17:56:36 GMT

I am trying to create a dashboard that uses a search that has a 6 digit number but need the a decimal on the last 2 numbers.

This is the result I get.

index=net Model=ERT-SCM EM_ID=Redacted | stats count by Consumption

199486

I would like it shown like this.

1994.86 Kwh

I have tried this but only gives me the last 2 numbers with a decimal

| rex mode=sed field=Consumption "s/(\\d{4})/./g"

richgalloway — Thu, 08 Aug 2024 19:00:08 GMT

Have you tried math? 🙂

index=net Model=ERT-SCM EM_ID=Redacted | stats count by Consumption | eval Consumption = exact(Consumption/100)

MGlass — Thu, 08 Aug 2024 20:03:53 GMT

Math is cool, I did try /100 but did not use exact. doh.

Thanks for the reply.