Dashboards & Visualizations

Search for trellis of Scatter plots

DavidGirsvaldas
Explorer

Hi,
Im trying to create grid of scatter plots. I should be able to pick pairs of ChannelNumbers and display MeanValue comming from them in separate plots. My initial search query was:

index=main  ChannelNumber=10 OR ChannelNumber=11 OR ChannelNumber=12 OR ChannelNumber=13 |  eval chartName=case(ChannelNumber=10, "ChartOne", ChannelNumber=11, "ChartOne", ChannelNumber=12, "ChartTwo", ChannelNumber=13, "ChartTwo")  | eval valueX = if(ChannelNumber=10, MeanValue, valueX) | eval valueY = if(ChannelNumber=11, MeanValue, valueY)| eval valueX = if(ChannelNumber=12, MeanValue, valueX) | eval valueY = if(ChannelNumber=13, MeanValue, valueY) | timechart avg(valueX) avg(valueY) by chartName

this should create Plot named "ChartOne" with ChannelNumber10 on X axis and ChannelNumber11 on Y, plot "ChartTwo" with Channel12 as X and Channel13 as Y.
However this query has a bug if same ChannelNumber gets selected for more than one plot. (for example- "ChartOne"x:10,y:11 "ChartTwo"x:10,y:12). Can anyone help me with either upgrading a query or changing my approach to it?
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 ...

The Splunk Success Framework: Your Guide to Successful Splunk Implementations

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

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

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