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!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Get the T-shirt to Prove You Survived Splunk University Bootcamp

As if Splunk University, in Las Vegas, in-person, with three days of bootcamps and labs weren’t enough, now ...

Wondering How to Build Resiliency in the Cloud?

IT leaders are choosing Splunk Cloud as an ideal cloud transformation platform to drive business resilience,  ...