Dashboards & Visualizations

splunk if else

Mohsin123
Path Finder

Hi,

I have a drop down with list of components . i want to a have a panel which will show stats count by service if component=A is selcted and stats count by component if rest components are selected from the drop down menu .

Is it posiible ?
I tried using

Thanks

0 Karma

renjith_nair
Legend

@shraddhamuduli,

You could do it by conditional token. Please find below the run anywhere example.

<form>
  <label>Conditional Drop Down</label>
  <fieldset submitButton="false">
    <input type="dropdown" token="component">
      <label>component</label>
      <fieldForLabel>component</fieldForLabel>
      <fieldForValue>component</fieldForValue>
      <search>
        <query>|tstats count where index=_* by component|fields - count|append [|stats count|eval component="the_special_component"]</query>
        <earliest>-15m</earliest>
        <latest>now</latest>
      </search>
      <change>
        <condition value="the_special_component">
          <set token="service_or_component">sourcetype</set>
        </condition>
        <condition>
          <set token="service_or_component">component</set>
        </condition>
      </change>
    </input>
  </fieldset>
  <row>
    <panel depends="$component$">
      <title>This panel is group by $service_or_component$</title>
      <table>
        <search>
          <query>index=_*|stats count by $service_or_component$</query>
          <earliest>-15m</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">none</option>
      </table>
    </panel>
  </row>
</form>

Main elements are below

         <condition value="the_special_component">
           <set token="service_or_component">sourcetype</set>
         </condition>
         <condition>
           <set token="service_or_component">component</set>
         </condition>

When the value of component is the_special_component, it sets the token as sourcetype (service in your case) and token is set to component in all other cases. Finally you will be using the token service_or_component in group by statement.

Hope it helps!

---
What goes around comes around. If it helps, hit it with Karma 🙂

Mohsin123
Path Finder

Hi Renjith

Thanks. But, your first query sets the dropdown to only one value i.e APIX
Here APIX is my "the_special_component"

0 Karma

Mohsin123
Path Finder

what i mean is, this line is setting the drop down to only one value i.e the_special_component

     <query>|tstats count where index=idx_apix by component|fields - count|append [|stats count|eval component="the_special_component"]</query>
0 Karma

renjith_nair
Legend

You could just do the normal search instead of above and populate the dropdown. However , logic in the dashboard should work for you.
Or do you mean that you have multiple values which needs to be compared?

---
What goes around comes around. If it helps, hit it with Karma 🙂
0 Karma
Get Updates on the Splunk Community!

Automatic Discovery Part 1: What is Automatic Discovery in Splunk Observability Cloud ...

If you’ve ever deployed a new database cluster, spun up a caching layer, or added a load balancer, you know it ...

Real-Time Fraud Detection: How Splunk Dashboards Protect Financial Institutions

Financial fraud isn't slowing down. If anything, it's getting more sophisticated. Account takeovers, credit ...

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...