Dashboards & Visualizations

How to display values in a CSV Lookup based on a selected time

Kyle_Dylan
New Member

Hi, I was asked to create a simple dashboard as part of my task.

I created a CSV Lookup as source and i want to display the values when i choose a specific "Reporting Date" 

For example, I choose in a drop down a Reporting Date of  Oct 23 2020.... then it should only display in the dashboard the values in the lookup being associated in that date. And if i choose another reporting date it should do the same.

Sample.PNG

i only pasted a portion of my lookup since it has several columns.  i would like to get a simple idea on how before i get to put it in a dashboard. Hope someone can provide some insights into this. Thank you

Labels (4)
0 Karma

renjith_nair
SplunkTrust
SplunkTrust

Please check this run anywhere example for reference

<form>
  <label>LookUp</label>
  <fieldset submitButton="false">
    <input type="dropdown" token="country">
      <label>Country</label>
      <default>Aruba</default>
      <initialValue>Aruba</initialValue>
      <fieldForLabel>country</fieldForLabel>
      <fieldForValue>country</fieldForValue>
      <search>
        <query>|inputlookup geo_attr_countries|fields country</query>
        <earliest>-15m</earliest>
        <latest>now</latest>
      </search>
    </input>
  </fieldset>
  <row>
    <panel>
      <table>
        <search>
          <query>|inputlookup geo_attr_countries where country="$country$"</query>
          <earliest>-15m</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">none</option>
      </table>
    </panel>
  </row>
</form>

 

0 Karma
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!