Dashboards & Visualizations

Dashboard Studio: How to create a input dropdown from datasource?

squared_away
Engager

Hello,

I have a number of unique searches for various infrastructure resources. I would like to create a dashboard that builds a chart based on the chosen entry from a dropown. Unfortunately, there's no easy way to create a base search and use tokens.

In other words, I would like each input title to reference a specific search in datsources.

example dropdown: 

input selected value 1= "dataSources": "search_1"

input selected value 2 = "dataSources": "search_2"

input selected value 3 = "dataSources": "search_3"

I could not find any documentation with examples of something similar.

Thanks in advance.

Labels (1)
Tags (2)
0 Karma
1 Solution

squared_away
Engager

I solved the challenge on my own.

I created multiple input items and used the search as the value. Then, I used the token from the input as the primary datasource.

Example

"input_1": {
"options": {
"items": [
{
"label": "Metric 1",
"value": "| mstats ***unique-search-string1******"
},
{
"label": "Metric 2",
"value": "| mstats ***unique-search-string2******"
},
{
"label": "Metric 3",
"value": "| mstats ***unique-search-string3******"
}
],
"defaultValue": "",
"token": "hosts_tok"
},
"dataSources": {
"primary": "$hosts_tok$"
},
"title": "Hosts",
"type": "input.dropdown"
}

If there's a better way please let me know.

View solution in original post

squared_away
Engager

I solved the challenge on my own.

I created multiple input items and used the search as the value. Then, I used the token from the input as the primary datasource.

Example

"input_1": {
"options": {
"items": [
{
"label": "Metric 1",
"value": "| mstats ***unique-search-string1******"
},
{
"label": "Metric 2",
"value": "| mstats ***unique-search-string2******"
},
{
"label": "Metric 3",
"value": "| mstats ***unique-search-string3******"
}
],
"defaultValue": "",
"token": "hosts_tok"
},
"dataSources": {
"primary": "$hosts_tok$"
},
"title": "Hosts",
"type": "input.dropdown"
}

If there's a better way please let me know.

muhammad_luthfi
Path Finder

Amazing!, thanks brother @squared_away , got your idea, i'm prefer using saved search because applicable for form.token , instead of put SPL query under value because required add backslash \

 it's very simple we just create simple form

{
    "type": "input.dropdown",
    "title": "Testing Multi Query",
    "options": {
        "items": [
            {
                "label": "Query 1",
                "value": "| makeresults | eval key=\"value\" | table *"
            },
            {
                "label": "Query 2",
                "value": "| loadjob savedsearch=\"admin:itsi:sla_availability\" artifact_offset=0"
            },
            {
                "label": "Query 3",
                "value": "| savedsearch \"AWS - IPs available\""
            }
        ],
        "token": "tos",
        "defaultValue": ""
    }
}

 

And create the visualization with my example token $tos$ bellow :

muhammad_luthfi_0-1749174627981.png

 

0 Karma

VatsalJagani
SplunkTrust
SplunkTrust

@squared_away - Kindly approve your own answer by clicking on the "Accept as Solution" button.

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Can’t Make It to Boston? Stream .conf25 and Learn with Haya Husain

Boston may be buzzing this September with Splunk University and .conf25, but you don’t have to pack a bag to ...

Splunk Lantern’s Guide to The Most Popular .conf25 Sessions

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Unlock What’s Next: The Splunk Cloud Platform at .conf25

In just a few days, Boston will be buzzing as the Splunk team and thousands of community members come together ...