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

[Kyle_Dylan]

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.

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

[renjith_nair]

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>