Splunk Search

How to create a pie chart after applying math on column values extracted?

sjs
Path Finder

Hey people, my requirement is as such

sjs_0-1673428861777.png

I have extracted these columns from my data using the query 

 

my query | rex "filterExecutionTime=(?<FET>[^,]+)" | rex "ddbWriteExecutionTime=(?<ddbET>[^)]+)" | rex "EXECUTION_TIME : (?<totalTime>[^ ms]+)" | eval buildAndTearDowTime=(tonumber(FET)) + (tonumber(ddbET)) |table totalTime FET ddbET buildAndTearDownTime

 

 

I want to have buildAndTearDown as totalTime - (FET+ ddbET)

 

once I have all the three values required (FET, ddbET, buildAndTearDown) I want to put these values in a pie chart.

 

Thanks 😊 

Labels (2)
0 Karma

scelikok
SplunkTrust
SplunkTrust

Hi @sjs ,

You have a typo in your eval , you are missing in buildAndTearDown, please try below;

my query 
| rex "filterExecutionTime=(?<FET>[^,]+)" 
| rex "ddbWriteExecutionTime=(?<ddbET>[^)]+)" 
| rex "EXECUTION_TIME : (?<totalTime>[^ ms]+)" 
| eval buildAndTearDownTime=(tonumber(FET)) + (tonumber(ddbET)) 
| table totalTime FET ddbET buildAndTearDownTime

 

If this reply helps you an upvote and "Accept as Solution" is appreciated.

sjs
Path Finder

Hey people, Can I get some help

0 Karma

sjs
Path Finder

This statement 

eval buildAndTearDowTime=(tonumber(FET)) + (tonumber(ddbET))

is giving me null value

0 Karma
Get Updates on the Splunk Community!

Monitoring Postgres with OpenTelemetry

Behind every business-critical application, you’ll find databases. These behind-the-scenes stores power ...

Mastering Synthetic Browser Testing: Pro Tips to Keep Your Web App Running Smoothly

To start, if you're new to synthetic monitoring, I recommend exploring this synthetic monitoring overview. In ...

Splunk Edge Processor | Popular Use Cases to Get Started with Edge Processor

Splunk Edge Processor offers more efficient, flexible data transformation – helping you reduce noise, control ...