Dashboards & Visualizations

How to edit my XML so clicking on a radio button automatically populates drop-down values while not retaining the previous value in the drop-down?

rupandit18
Engager

I am working on a use case where I have 3 radio buttons ( say 2001, 2002 and Today) and one drop-down. Clicking on the 2002 radio button should display all the movie releases occurred in that year ( let's say MovieA , MovieB , MovieC ). Now, in the drop-down, select MovieB so now drop-down displays MovieB. Now, click on other radio button, let's say, 2001. So at this time, the drop-down should populate all the releases that occurred in the year 2001, and it should not retain the previously selected value in the drop-down which in this case would be MovieB. I am fine with having one default value ( which would show up in the drop-down, something like "Please select Value", and when clicking on the drop-down arrow, you can see all movies of that year ) for all radio buttons as long as it does NOT retain the previously selected value in the drop-down.

My code is attached below.


< fieldset submitButton="false">
    < input type="radio" token="event_date_type2" searchWhenChanged="true">
      < default>Today < /default>
      < earliest>-24h< /earliest>
      < latest>now< /latest>
      < populatingSearch fieldForValue="event_date_type2" fieldForLabel="event_date_type2">
        < ![CDATA[| inputlookup file.csv | FIELDS event_date_type2 |
        eval event_date_type2 = substr(event_date_type2,0,4) | dedup
        event_date_type2
        |where event_date_type2!=0 | append [ inputlookup
        Events_Lookup_20141001.csv |stats count |eval event_date_type2="Today"
        | FIELDS event_date_type2] ]]>
      < /populatingSearch >
    < /input>
    < input type="dropdown" token="field2" searchWhenChanged="false">
      < label>Select a Date</label>
      < search>
        < query>|inputlookup Events_Lookup_20141001.csv  | where like(event_date,"%$event_date_type2$%")  | append [ inputlookup Events_Lookup_20141001.csv |stats count |eval event_date_type2="%$event_date_type2$%" | eval title="Today"| eval latest_timestamp =strftime(now(),"%s")       | eval earliest_timestamp = now()-86400 ] | where like(title, "%$event_date_type2$%")
     < /query>
      < /search>
     < fieldForLabel>title< /fieldForLabel>
      < fieldForValue>title< /fieldForValue>
      < default>Please select Value < /default> // This is default value to be shown un in dropdown as soon as radio button pressed.     
      < change>
        < set token="field2.earliest">$row.earliest_timestamp$< /set>
         < set token="field2.latest">$row.latest_timestamp$< /set>
      < /change>

Truly appreciate your help on this fix. Please let me know what am I missing here.

Thank you.

0 Karma

jeffland
SplunkTrust
SplunkTrust

I'm not sure this can be done without Javascript.

In Javascript, you can simply listen to a change of the radio buttons and in that case set the selection of the dropdown to the standard selection. If you are interested, you might want to have a look here and here.

By the way, if you're looking for a way to "clear" the dropdown, you should put something like "Any" as label and use * as value; in most search scenarios, this should have the effect of "nothing selected" on a search (i.e. index = foo movie_title=$dropdown$ with $dropdown$ replaced by * does not filter anything besides events whithout the field movie_title). That way, the user doesn't even have to select something from the dropdown in order to see results.

0 Karma

rupandit18
Engager

Thank you for your response. Yes, I did try that too but did not see expected experience. However, was able to handle this through XML itself. No need of JS.

0 Karma

erritesh17
Path Finder

I am facing the same issue .........can you share the answer..........?

0 Karma

jeffland
SplunkTrust
SplunkTrust

Good - then you could consider sharing your solution for others to see 🙂

0 Karma
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Wondering How to Build Resiliency in the Cloud?

IT leaders are choosing Splunk Cloud as an ideal cloud transformation platform to drive business resilience,  ...

Updated Data Management and AWS GDI Inventory in Splunk Observability

We’re making some changes to Data Management and Infrastructure Inventory for AWS. The Data Management page, ...