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!

Accelerate Service Onboarding, Decomposition, Troubleshooting - and more with ITSI’s ...

Accelerate Service Onboarding, Decomposition, Troubleshooting - and more! Faster Time to ValueManaging and ...

New Release | Splunk Enterprise 9.3

Admins and Analyst can benefit from:  Seamlessly route data to your local file system to save on storage ...

2024 Splunk Career Impact Survey | Earn a $20 gift card for participating!

Hear ye, hear ye! The time has come again for Splunk's annual Career Impact Survey!  We need your help by ...