Dashboards & Visualizations

How to change the group by clause in timechart command depending on selected value in drop-down?

praspai
Path Finder

I want to change the group by clause in search command depending upon selected value in drop-down box in dashboard

e.g. Selected value is "All" then group by clause should look like timechart sum(x) group by host
else
Selected value is "Environment" then group by clause should look like timechart sum(x) group by environment

Thanks,
Prashant

0 Karma
1 Solution

rjthibod
Champion

You can easily do this with the <change> option on your input dropdown.

    <input id="split_field" searchWhenChanged="true" token="split_field" type="dropdown">
      <label>Split-by Field</label>
      <choice value="all">All</choice>
      ...
      <choice value="env">Environment</choice>
      <default>all</default>
      <change>
        <condition label="All">
          <set token="split_field_opt">host</set>
        </condition>
       ...
        <condition label="Environment">
          <set token="split_field_opt">environment</set>
        </condition>        
      </change>
    </input>
    ...
    <panel>
      <chart>
        <search><query>YOUR SEARCH | timechart sum(x) group by  $split_field_opt$</query></search>
      </chart>
    </panel>

View solution in original post

rjthibod
Champion

You can easily do this with the <change> option on your input dropdown.

    <input id="split_field" searchWhenChanged="true" token="split_field" type="dropdown">
      <label>Split-by Field</label>
      <choice value="all">All</choice>
      ...
      <choice value="env">Environment</choice>
      <default>all</default>
      <change>
        <condition label="All">
          <set token="split_field_opt">host</set>
        </condition>
       ...
        <condition label="Environment">
          <set token="split_field_opt">environment</set>
        </condition>        
      </change>
    </input>
    ...
    <panel>
      <chart>
        <search><query>YOUR SEARCH | timechart sum(x) group by  $split_field_opt$</query></search>
      </chart>
    </panel>
Get Updates on the Splunk Community!

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...