Getting Data In

How to create a dashboard studio chain search with dropdown token?

anewuser
Loves-to-Learn

Background I would like to create a dashboard with dropdowns that allow underlying queries to create chart to filter differently depending on dropdown values. For performance reasons, I'd also want the dashboard's to be powered by saved searches.

Setup:

- Drop downs

- Saved searches on unfiltered queries,

- Chain searches to referencing saved searches and filter by drop down value

 

Problem: 

When I did the chain search with the drop down token value, the token does not get translated into a value. For instance: My dropdown's token is called "dd". When I did my chain search by " | search myfield="$dd$", the query does not return anything. If I open the entire search query, it shows I am trying to do:

<saved search query>
| search myfield="$dd$"

The expectation would be instead

<saved search query>
| search myfield="<my dd value>"

Is this not supported?

0 Karma

VatsalJagani
SplunkTrust
SplunkTrust

@anewuser - Have you tried using the savedsearch command. - https://docs.splunk.com/Documentation/SplunkCloud/latest/SearchReference/Savedsearch

 

An example could be:

| savedsearch mysearch replace_me="value"

Here your savedsearch itself would have token in it like:

index=xyz event_id=$replace_me$ ......

 

I hope this helps!!!

0 Karma

anewuser
Loves-to-Learn

It seems like it is indeed not supported: https://docs.splunk.com/Documentation/DashApp/0.9.0/DashApp/dsChain

In that case, what's the recommended approach to create a dashboard with saved searches that are filtered by dropdown? I'd imagine that is a very common use case.

0 Karma
Get Updates on the Splunk Community!

Splunk Mobile: Your Brand-New Home Screen

Meet Your New Mobile Hub  Hello Splunk Community!  Staying connected to your data—no matter where you are—is ...

Introducing Value Insights (Beta): Understand the Business Impact your organization ...

Real progress on your strategic priorities starts with knowing the business outcomes your teams are delivering ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...