Splunk Search

In my search query, why is my scatter plot empty with unlabeled axes?

casswell
Explorer

I have a fairly simple search that returns a table of values - the number of processors used vs the number of jobs with that assigned number of processors. I can make a line plot but I don't want the lines because this implies a false relationship between the points. I just want to make a plot of the points, but I don't see any way to turn off the lines. I tried a scatter plot but I am clearly doing it wrong because I get unlabeled axises and no data on the plot.
my search string is qid= | stats count as #jobs by numproc | sort numproc
I get a statistics table of 2 columns (numproc and #job)
This generates a reasonable line plot but I can't turn off the connecting lines.

any advice would be appreciated.

0 Karma
1 Solution

casswell
Explorer

I added

qid= | stats count as #jobs by numproc | **table nmpi #jobs |**sort numproc

and now the scatter plot shows up. Adding table nmpi #jobs before the sort command, makes the scatter plot to show up with correctly labeled axises.

View solution in original post

0 Karma

casswell
Explorer

I added

qid= | stats count as #jobs by numproc | **table nmpi #jobs |**sort numproc

and now the scatter plot shows up. Adding table nmpi #jobs before the sort command, makes the scatter plot to show up with correctly labeled axises.

0 Karma
Get Updates on the Splunk Community!

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer at Splunk .conf24 ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...

Share Your Ideas & Meet the Lantern team at .Conf! Plus All of This Month’s New ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...