Dashboards & Visualizations

Status Matrix Custom Viz is not working as expected

gs
Engager

I have installed Status Matrix Custom Viz on my stand-alone search head, radius part is not working as expected. Your help would be highly appreciable.

Labels (2)
0 Karma

gs
Engager

@niketn  I have seen your post earlier but the radius part is not working.. 
Please suggest me on this.
Thanks in advance!

 

0 Karma

niketn
Legend

@gs for the community to assist you better please provide more details on what do you mean by it is not working as expected. What is your use case? If you can add a screenshot of what is wrong vs what is expected and some sample data of what you are working with along with SPL/Simple XML code used would be great. Please mock/anonymize any sensitive information before posting.

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

gs
Engager

Status Matrix.PNG

@niketn  SPL I used:
| makeresults
| eval data="1,1,1,0;10,5,15,5"
| makemv data delim=";"
| streamstats count as column
| mvexpand data
| makemv data delim=","
| eval addtocart=mvindex(data,0), ordered=mvindex(data,1), shipped=mvindex(data,2), delivered=mvindex(data,3)
| table ordernum addtocart ordered shipped delivered
| transpose header_field=column
| rename "row 1" as "order1_status", "row 2" as "order1_duration"

0 Karma

niketn
Legend

@gs  as per the example on Splunkbase you need to add radius column values for each metric you are trying to plot on Status Matrix. For example order_status and order_duration in your case need two additional columns for respective Radius to be plotted. Try following search instead:

| makeresults
| fields - _time
| eval data="addtocart,1,1,5,2;ordered,1,1,3,2;shipped,,1,10,7,;delivered,0,1,0,2;"
| makemv data delim=";"
| mvexpand data
| makemv data delim=","
| eval stage=mvindex(data,0),order_status=mvindex(data,1),order_duration=mvindex(data,2),order_status_radius=mvindex(data,3),order_duration_radius=mvindex(data,4)
| table stage order_status order_duration order_status_radius, order_duration_radius

  Following is a run anywhere example for you to try out!

Screen Shot 2020-09-30 at 10.51.33 PM.png

 

<dashboard>
  <label>Status Matrix</label>
  <row>
    <panel>
      <viz type="cuviz_status_matrix.status_matrix">
        <search>
          <query>| makeresults
| fields - _time
| eval data="addtocart,1,1,5,2;ordered,1,1,3,2;shipped,,1,10,7,;delivered,0,1,0,2;"
| makemv data delim=";"
| mvexpand data
| makemv data delim=","
| eval stage=mvindex(data,0),order_status=mvindex(data,1),order_duration=mvindex(data,2),order_status_radius=mvindex(data,3),order_duration_radius=mvindex(data,4)
| table stage order_status order_duration order_status_radius, order_duration_radius</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="cuviz_status_matrix.status_matrix.before_label">Status</option>
        <option name="cuviz_status_matrix.status_matrix.enable_scalable_radius">true</option>
        <option name="cuviz_status_matrix.status_matrix.max_radius">26</option>
        <option name="cuviz_status_matrix.status_matrix.min_radius">10</option>
        <option name="cuviz_status_matrix.status_matrix.radius">24</option>
        <option name="cuviz_status_matrix.status_matrix.show_flaky_metrics">false</option>
        <option name="drilldown">none</option>
        <option name="refresh.display">progressbar</option>
      </viz>
    </panel>
  </row>
</dashboard>

 

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma
Get Updates on the Splunk Community!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...