topic Re: [box plot] How could I delete "trace 0" data not declared? in Splunk Search

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

Questioner — Wed, 17 Jan 2024 09:11:52 GMT

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.

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

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

richgalloway — Wed, 17 Jan 2024 15:58:46 GMT

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")

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

bowesmana — Wed, 17 Jan 2024 23:50:06 GMT

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?

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

Questioner — Thu, 18 Jan 2024 01:19:57 GMT

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