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 😊
To make the pie chart, do
| table FET ddbET buildAndTearDownTime
| transpose 0
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
Thanks that was so silly of me, could you please help me on the pie chart part too
To make the pie chart, do
| table FET ddbET buildAndTearDownTime
| transpose 0
You have spelt buildAndTearDownTime incorrectly
| eval buildAndTearDowTime=(tonumber(FET)) + (tonumber(ddbET))
missing n in Down