Splunk Search

[box plot] How could I delete "trace 0" data not declared?

Questioner
Path Finder

I try to do box plot using viz.
But I can see the "trace 0" data graph in box plot. ( I don't have any data called "trace 0")

 

This is my code,

<row>
<panel>
<viz type="splunk_plotly_collection_viz.boxplot">
<search>
<query>
.....
| eval total_time=case(time<= 8, "8", time<= 9, "8~9", time<= 10, "9~10", time<= 11, "10~11", time<= 15, "11~15", time<= 20, "15~20")
| table total_time init_dt
</query>
</search>
<option name="drilldown">all</option>
<option name="refresh.display">progressbar</option>
<option name="trellis.enabled">0</option>
</viz>
</panel>
</row>

 and this is the current state of my graph.

Questioner_0-1705482672829.png

How could I delete "trace 0" in the graph?

 

Labels (1)
Tags (1)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

If you're using the Box Plot viz at https://splunkbase.splunk.com/app/3157 then it's an archived app that probably is outdated and may have compatibility issues.  Consider trying the box plot viz available in https://splunkbase.splunk.com/app/5730.

That said, does the time field have values greater than 20?  If so, the lack of a default condition will cause the case function will set total_time to null, which might generate the "trace 0" graph points.

| eval total_time=case(time<= 8, "8", time<= 9, "8~9", time<= 10, "9~10", time<= 11, "10~11", time<= 15, "11~15", time<= 20, "15~20", 1==1, ">20")

 

---
If this reply helps you, Karma would be appreciated.

View solution in original post

Questioner
Path Finder

@richgalloway  
It work! That 'trace0' show out of condition data like > 20.
Thank you for your help!

bowesmana
SplunkTrust
SplunkTrust

I see you are already using the Plotly boxplot charts.

I can't confirm, but it seems it may be something inside the Plotly code itself - that viz is made by Splunk Works, but I'm not sure who looks after that.

Can you check in your browser develop tools to see if there is anything reported in the Console log?

 

0 Karma

richgalloway
SplunkTrust
SplunkTrust

If you're using the Box Plot viz at https://splunkbase.splunk.com/app/3157 then it's an archived app that probably is outdated and may have compatibility issues.  Consider trying the box plot viz available in https://splunkbase.splunk.com/app/5730.

That said, does the time field have values greater than 20?  If so, the lack of a default condition will cause the case function will set total_time to null, which might generate the "trace 0" graph points.

| eval total_time=case(time<= 8, "8", time<= 9, "8~9", time<= 10, "9~10", time<= 11, "10~11", time<= 15, "11~15", time<= 20, "15~20", 1==1, ">20")

 

---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

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 ...

Introducing the Splunk Community Dashboard Challenge!

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

Wondering How to Build Resiliency in the Cloud?

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