Splunk Search

Why Splunk is telling me that my eval expression is malformed?

tcmarquesi
Explorer

I'm trying to evaluate the normal distribuiton's PDF into my search as follows:

... | eval prob=(1/sqrt(2*pi()*sigma^2))*exp(-((x-mi)^2)/(2*sigma^2))

And I'm getting this error message:

Error in 'eval' command: The expression is malformed. Expected ).

What am I doing wrong? I tested the expression on Excel and it works fine...

Tags (2)
0 Karma
1 Solution

sundareshr
Legend

I haven't tested this, but at first glance, it could be because of the the power of function. Change all occurences of sigma^2 to pow(sigma, 2). So your formula s/b written like this

(1/sqrt(2*pi()*pow(sigma,2)))*exp(-(pow((x-mi),2))/(2*pow(sigma, 2)))

View solution in original post

sundareshr
Legend

I haven't tested this, but at first glance, it could be because of the the power of function. Change all occurences of sigma^2 to pow(sigma, 2). So your formula s/b written like this

(1/sqrt(2*pi()*pow(sigma,2)))*exp(-(pow((x-mi),2))/(2*pow(sigma, 2)))

tcmarquesi
Explorer

Thank you!

0 Karma
Get Updates on the Splunk Community!

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...