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!

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...