Dashboards & Visualizations

How to setup Table Drilldown Link in Dashboard Studio from a hidden table column?

edgarrity
Path Finder

I want to create a table in Dashboard Studio that will open up another dashboard when the user clicks on a row in the table.  However, I cannot figure out how to provide the name of the dashboard to link to in a hidden field (see code below).  How do I create a table drilldown to a dashboard based on the name in a hidden column?

 

{

    "visualizations": {

        "viz_15E2DDQP": {

            "type": "splunk.table",

            "dataSources": {

                "primary": "ds_HsTRSmYx"

            },

            "title": "Fleet Status"

        }

    },

    "dataSources": {

        "ds_HsTRSmYx": {

            "type": "ds.search",

            "options": {

                "query": "| makeresults\r\n| eval ITEM = \"Operator Logins\"\r\n| eval STATUS = \"Good\"\r\n| eval _hot_link = \"operator_logins_dashboard\"\r\n| append [\r\n| makeresults\r\n| eval ITEM = \"Revenue Service\"\r\n| eval STATUS = \"Fair\"\r\n| eval _hot_link = \"revenue_service_dashboard\"\r\n]\r\n| append [\r\n| makeresults\r\n| eval ITEM = \"Announcements\"\r\n| eval STATUS = \"Poor\"\r\n| eval _hot_link = \"announcements_dashboard\"\r\n]\r\n| append [\r\n| makeresults\r\n| eval ITEM = \"Navigation\"\r\n| eval STATUS = \"Warning\"\r\n| eval _hot_link = \"navigation_dashboard\"\r\n]\r\n| append [\r\n| makeresults\r\n| eval ITEM = \"Available Resources\"\r\n| eval STATUS = \"Error\"\r\n| eval _hot_link = \"resources_dashboard\"\r\n]\r\n| table ITEM STATUS _hot_link"

            },

            "name": "Fleet Status"

        }

    },

    "defaults": {

        "dataSources": {

            "ds.search": {

                "options": {

                    "queryParameters": {

                        "latest": "$global_time.latest$",

                        "earliest": "$global_time.earliest$"

                    }

                }

            }

        }

    },

    "inputs": {

        "input_global_trp": {

            "type": "input.timerange",

            "options": {

                "token": "global_time",

                "defaultValue": "-24h@h,now"

            },

            "title": "Global Time Range"

        }

    },

    "layout": {

        "type": "absolute",

        "options": {

            "display": "auto-scale"

        },

        "structure": [

            {

                "item": "viz_15E2DDQP",

                "type": "block",

                "position": {

                    "x": 0,

                    "y": 0,

                    "w": 690,

                    "h": 260

                }

            }

        ],

        "globalInputs": [

            "input_global_trp"

        ]

    },

    "description": "",

    "title": "Dashboard Studio Hotlink POC"

}

 

Labels (3)
0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

🍂 Fall into November with a fresh lineup of Community Office Hours, Tech Talks, and Webinars we’ve ...

Transform your security operations with Splunk Enterprise Security

Hi Splunk Community, Splunk Platform has set a great foundation for your security operations. With the ...

Splunk Admins and App Developers | Earn a $35 gift card!

Splunk, in collaboration with ESG (Enterprise Strategy Group) by TechTarget, is excited to announce a ...