I'm working with the Detect Numeric Outliers assistant from the Splunk Machine Learning Toolkit 2.3.0. When I use the Toolkit's built-in data in the Showcase, I get a lovely Outliers Chart-style visualization in the "Visualizations" tab. The SPL used is as follows:
| inputlookup supermarket.csv | head 1000 | eventstats avg("quantity") as avg stdev("quantity") as stdev | eval lowerBound=(avg-stdev*exact(5)), upperBound=(avg+stdev*exact(5)) | eval isOutlier=if('quantity' < lowerBound OR 'quantity' > upperBound, 1, 0) | fields _time, "quantity", lowerBound, upperBound, isOutlier, *
When I try to use my own data in the assistant, I get an empty Visualizations tab with the message "Your search isn't generating any statistic or visualization results." (I'm running the search in Smart Mode both times.) The SPL I'm using is:
index=xxx source=xxx reactionTime | eventstats avg("reactionTime") as avg stdev("reactionTime") as stdev | eval lowerBound=(avg-stdev*exact(2)), upperBound=(avg+stdev*exact(2)) | eval isOutlier=if('reactionTime' < lowerBound OR 'reactionTime' > upperBound, 1, 0) | fields _time, "reactionTime", lowerBound, upperBound, isOutlier, *
When I replace the fields above with table , I get a graph in the Visualizations tab, but the graph is blank with the error message "No data to Display."
Adding to my confusion is the fact that the documentation for the table command says not to use it for charts, as it strips away the internal fields, but the Toolkit's User Guide says to use the syntax | table _time, outlier_variable, lowerBound, upperBound for the Outliers Chart.
So now I'm stuck - I'd like to display an Outliers Chart with my own data, but I don't know how to do that. Has anyone run into this problem before, or can anyone point me to where I'm doing something wrong?
Thank you!
... View more