topic How to create a pie chart after applying math on column values extracted? in Splunk Search

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

sjs — Fri, 13 Jan 2023 04:12:04 GMT

Hey people, my requirement is as such

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.

Another question I have is why is

This statement

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

is giving me null value

Thanks 😊

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

bowesmana — Fri, 13 Jan 2023 04:20:29 GMT

You have spelt buildAndTearDownTime incorrectly

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

missing n in Down

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

bowesmana — Fri, 13 Jan 2023 04:22:43 GMT

To make the pie chart, do

| table FET ddbET buildAndTearDownTime | transpose 0

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

sjs — Fri, 13 Jan 2023 04:23:35 GMT

Thanks that was so silly of me, could you please help me on the pie chart part too

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

sjs — Fri, 13 Jan 2023 04:28:26 GMT

OMG, that worked as charm

can I add any legends about the time on to the right side or somewhere because ddbET is so small, it is not visible