Dashboards & Visualizations

how i can display only one value using dropdown?

rajhemant26
New Member

Hello, everyone

I am using one CSV file to display the output. I have added the screenshot for CSV file.

Tags (1)
0 Karma

vnravikumar
Champion

Hi

Check this and modify accordingly

<form>
  <label>Product</label>
  <fieldset submitButton="false">
    <input type="dropdown" token="product">
      <label>Product Type</label>
      <choice value="ProductA">ProductA</choice>
      <choice value="ProductB">ProductB</choice>
    </input>
    <input type="dropdown" token="field2">
      <label>field2</label>
      <fieldForLabel>Version</fieldForLabel>
      <fieldForValue>Version</fieldForValue>
      <search>
        <query>|inputlookup RK.csv | eval date = strptime($product$,"%d/%m/%y") | where date < now() | table Version | sort - Version</query>
        <earliest>-24h@h</earliest>
        <latest>now</latest>
      </search>
    </input>
  </fieldset>
</form>

OR

If you want only the latest value

<form>
  <label>Product</label>
  <fieldset submitButton="false">
    <input type="dropdown" token="product">
      <label>Product Type</label>
      <choice value="ProductA">ProductA</choice>
      <choice value="ProductB">ProductB</choice>
    </input>
    <input type="dropdown" token="field2">
      <label>field2</label>
      <fieldForLabel>Version</fieldForLabel>
      <fieldForValue>Version</fieldForValue>
      <search>
        <query>|inputlookup RK.csv | eval date = strptime($product$,"%d/%m/%y") | where date < now() | table Version | sort 1 - Version</query>
        <earliest>-24h@h</earliest>
        <latest>now</latest>
      </search>
    </input>
  </fieldset>
</form>
0 Karma
Get Updates on the Splunk Community!

.conf23 | Get Your Cybersecurity Defense Analyst Certification in Vegas

We’re excited to announce a new Splunk certification exam being released at .conf23! If you’re going to Las ...

Starting With Observability: OpenTelemetry Best Practices

Tech Talk Starting With Observability: OpenTelemetry Best Practices Tuesday, October 17, 2023   |  11AM PST / ...

Streamline Data Ingestion With Deployment Server Essentials

REGISTER NOW! Every day the list of sources Admins are responsible for gets bigger and bigger, often making ...