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"
}