Sum columns selected from a dropdown menu

[ravikumar_sri20]

I have a multi select drop down menu with field names as values.   

When i one or mone values from the drop down menu, those fields/columns need to totaled.

I tried the below code as sugged by Meta AI..But it is not producing any result. Please help me

<dashboard>
  <label>Sum Selected Fields</label>
  <row>
    <panel>
      <input type="dropdown" token="selected_fields">
        <label>Select Fields</label>
        <choice value="field1">Field 1</choice>
        <choice value="field2">Field 2</choice>
        <choice value="field3">Field 3</choice>
      </input>
      <chart>
        <search>

          | eval sum_fields="$selected_fields$"
          | stats sum(eval(split(sum_fields, ","))) as Total by Jobname
        </search>
      </chart>
    </panel>
  </row>
</dashboard>

[ravikumar_sri20]

Thank you so much Victor!!

[victor_menezes · Accepted solution]

Hi Ravi,

The strategy is to configure your multivalue input with using prefix, sufix and delimiter, like this:

<fieldset submitButton="false">
<input type="multiselect" token="field1">
<label>field1</label>
<choice value="value1">value1</choice>
<choice value="value2">value2</choice>
<choice value="value3">value3</choice>
<delimiter>,</delimiter>
<prefix>| stats sum(</prefix>
<suffix>)</suffix>
</input>
</fieldset>

Via UI it will look like this:

Screenshot 2024-10-17 161730.png

So in your search you'll simply do:

|makeresults $field1$

where |makeresults is your actual search. The token will append | sum(<selected_values>)

Then you can add the proper grouping fields and etc to make that happen as you want it to. (like add the "as Total by Jobname" after the ")" suffix