Splunk Search

How to count number of values in multi-valued field , dynamically?

vijay_k
Engager

<input type="multiselect" token="product_token" searchWhenChanged="true">
<label>Product types</label>
<choice value="*">All</choice>
<default>*</default>
<prefix>(</prefix>
<suffix>)</suffix>
<initialValue>*</initialValue>
<valuePrefix>DB_Product="*</valuePrefix>
<valueSuffix>*"</valueSuffix>
<delimiter> OR </delimiter>
<fieldForLabel>DB_Product</fieldForLabel>
<fieldForValue>DB_Product</fieldForValue>
<search base="base_search_Products">
<query>|dedup DB_Product | table DB_Product</query>
</search>
</input>

 

This is my input multi select , thorugh which user select product Types example - All /A,B,C,D etc

I need to count, How many Product types are selcted by user . This info i need for further processing.

Labels (1)
Tags (1)
0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@vijay_k 

Are you looking for something like this? Just try this example.

<form version="1.1">
  <label>Test</label>
  <fieldset submitButton="false">
    <input type="multiselect" token="product_token" searchWhenChanged="true">
      <label>Product types</label>
      <choice value="*">All</choice>
      <default>*</default>
      <prefix>(</prefix>
      <suffix>)</suffix>
      <initialValue>*</initialValue>
      <valuePrefix>DB_Product="*</valuePrefix>
      <valueSuffix>*"</valueSuffix>
      <delimiter> OR </delimiter>
      <fieldForLabel>DB_Product</fieldForLabel>
      <fieldForValue>DB_Product</fieldForValue>
      <search>
        <query>| makeresults count=10 
                | eval a=1 
                | accum a
                | eval DB_Product="DB_PR_"+a | table DB_Product</query>
      </search>
      <change>
        <condition match="$form.product_token$==&quot;*&quot;">
          <eval token="tmp">$form.product_token$</eval>
          <eval token="select_count">mvcount('form.product_token')</eval>
        </condition>
        <condition>
          <eval token="tmp">mvcount('form.product_token')</eval>
          <eval token="select_count">mvcount('form.product_token')</eval>
        </condition>
      </change>
    </input>
  </fieldset>
  <row>
    <panel>
      <table>
        <search>
          <query>| makeresults count=10 
                | eval a=1 
                | accum a
                | eval DB_Product="DB_PR_"+a | table DB_Product 
| search $product_token$
| eval count="$select_count$"</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">none</option>
        <option name="refresh.display">progressbar</option>
      </table>
    </panel>
  </row>
</form>

 

I hope this will help you.

 

Thanks
KV
If any of my replies help you to solve the problem Or gain knowledge, an upvote would be appreciated.

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
<change>
  <eval token="select_count">mvcount('form.product_token')</eval>
</change>

vijay_k
Engager

<input type="multiselect" token="product_token" searchWhenChanged="true">
<label>Product types</label>
<choice value="*">All</choice>
<default>*</default>
<prefix>(</prefix>
<suffix>)</suffix>
<initialValue>*</initialValue>
<valuePrefix>DB_Product="*</valuePrefix>
<valueSuffix>*"</valueSuffix>
<delimiter> OR </delimiter>
<fieldForLabel>DB_Product</fieldForLabel>
<fieldForValue>DB_Product</fieldForValue>
<search base="base_search_Products">
<query>|dedup DB_Product | table DB_Product</query>
</search>

<change>
  <eval token="select_count">mvcount('form.product_token')</eval>
</change>


</input>

 

I added change tag within input but it gives values NULL

Tags (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

How are you using the token?

0 Karma

vijay_k
Engager

index="example" source="Stash_test"|search  $product_token$
|eval countn=$select_count$

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud’s AI Assistant in Action Series: Analyzing and ...

This is the second post in our Splunk Observability Cloud’s AI Assistant in Action series, in which we look at ...

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...