Dashboards & Visualizations

Building a dashboard with dynamic drop-down filters?

AmruthaSK
Loves-to-Learn Lots

I have 3 drop downs added,

Timeframe, Report Name, Path Category

Timeframe is fine.

I have added 5 options including All under Report Name which is hardcoded under static values (All, Moovweb, SFCC, Akamai, SFCC core)

Under Path Category I have added hardcoded static values with name and value. (All, PDP, PLP, MW api, MW Search, Cart api, Akamai search, Akamai checkout flow, Akamai account flow, SFCC Core search)

With static option, if I select Moovweb, I get all results under path category drop down. but what Iam looking for is just 5 values: All, PDP, PLP, MW Api, MW Search, Cart Api

same way: for Akamai: All, PDP, PLP, Akamai search, Akamai checkout flow, Akamai account flow

How can I achieve this, with one report name, I need specific path categories?

One more point: in the above dashboard I have included 19 panels (different sites) where Splunk query has been added, where the result change according to the above selections)

Can anyone please check this on priority and revert.

Thanks in advance!!

 

Labels (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Use a search for the third dropdown which uses the token from the second dropdown to filter the options. This search can be made using makeresults and your "static" choices.

| makeresults
| fields - _time
| eval category=case($report|s$ = "All",mvappend("All", "PDP", "PLP", "MW api", "MW Search", "Cart api", "Akamai search", "Akamai checkout flow", "Akamai account flow", "SFCC Core search"), $report|s$ = "Moovweb", mvappend("All", "PDP", "PLP", "MW Api", "MW Search", "Cart Api"), $report|s$ = "Akamai", mvappend("All", "PDP", "PLP", "Akamai search", "Akamai checkout flow", "Akamai account flow"))
0 Karma

isoutamo
SplunkTrust
SplunkTrust

Hi

can you share what you currently have? Please use </> editor element to ensure that we got what you add to post!

r. Ismo

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...