topic Re: How to create a dashboard with a drop-down populated with extracted field headers from a CSV file? in Dashboards & Visualizations

How to create a dashboard with a drop-down populated with extracted field headers from a CSV file?

cdstealer — Thu, 05 Mar 2015 11:52:15 GMT

Hi,

I have imported a CSV file which has auto extracted the column heading and values 🙂 The task I have now is to create a dashboard where the user can select the time period (done) and then select the the field header they are interested in. Is this possible and how do I get the extracted headers into the drop-down?

Cheers

Re: How to create a dashboard with a drop-down populated with extracted field headers from a CSV file?

muebel — Sat, 07 Mar 2015 02:32:52 GMT

Seems like you will want to setup a Form with with dropdown fieldset:

<form>
  <fieldset>
    <input type="dropdown">
      <search>
        <query>source=csv | fields field1,field2</query>
      </search>
    </input>
  </fieldset>
</form>

Something like this will populate a dropdown with the results from the search you specify.

Re: How to create a dashboard with a drop-down populated with extracted field headers from a CSV file?

cdstealer — Mon, 28 Sep 2020 19:06:03 GMT

Hi Muebel,
Thanks for the reply.. unfortunately I've already done that (kind of).. Specifying individual fields is not realistic due to the amount of them. The query I used is index=storage_csv sourcetype=storage_csv | fields "CLASS*" but it complains of "duplicate labels" of which there are none. This is a very basic XML that I've used:

<form>
  <fieldset>
    <input type="time" token="field1">
      <label></label>
      <default>
        <earliest>0</earliest>
        <latest></latest>
      </default>
    </input>
    <input type="dropdown">
      <search>
        <query>index=storage_csv sourcetype=storage_csv | fields "CLASS*"</query>
          <earliest>$field1.earliest$</earliest>
          <latest>$field1.latest$</latest>
      </search>
    </input>
  </fieldset>
</form>

Running the query manually returns the fields as expected.

Re: How to create a dashboard with a drop-down populated with extracted field headers from a CSV file?

muebel — Sat, 07 Mar 2015 09:14:04 GMT

Ah, I left a bit out. You will need to add a couple more elements to the dropdown input:

  <fieldForLabel>CLASS</fieldForLabel>
  <fieldForValue>CLASS</fieldForValue>

Re: How to create a dashboard with a drop-down populated with extracted field headers from a CSV file?

cdstealer — Mon, 28 Sep 2020 19:06:06 GMT

Hi Muebel,
Thanks again.. unfortunately I still get the "Duplicate labels" error. I ran the query index=storage_csv sourcetype=storage_csv | transpose | rename column as class | sort -class to ensure there were no duplicates being returned. Which of course there aren't. I am utterly stuck on this one 😞

Re: How to create a dashboard with a drop-down populated with extracted field headers from a CSV file?

somesoni2 — Sun, 08 Mar 2015 20:37:52 GMT

You just want the CSV header names (e.g. field1, field2) into the dropdown? If yes try below query:

<form>
   <fieldset>
     <input type="time" token="field1">
       <label></label>
       <default>
         <earliest>0</earliest>
         <latest></latest>
       </default>
     </input>
     <input type="dropdown">
       <search>
         <query>index=storage_csv sourcetype=storage_csv | head 1 | transpose | fields column | search column=CLASS* </query>
           <earliest>$field1.earliest$</earliest>
           <latest>$field1.latest$</latest>
       </search>
<fieldForLabel>column</fieldForLabel>
   <fieldForValue>column</fieldForValue>
     </input>
   </fieldset>
 </form>

Re: How to create a dashboard with a drop-down populated with extracted field headers from a CSV file?

cdstealer — Mon, 09 Mar 2015 07:30:00 GMT

somesoni2.. you sir, are a life saver! Thank you very very much 🙂

Re: How to create a dashboard with a drop-down populated with extracted field headers from a CSV file?

saura1312 — Mon, 21 Nov 2016 08:17:50 GMT

Where do i keep this XMLs? please explain in detail