How to insert hyperlink to the values of a column in Dashboard Studio.

[Sharma21]

I have a visualization of type splunk.table in Dashboard Studio (version 9.0.2). The source table contains columns "id" from which I have derived the column "link".

sourcetype="x"
| eval link = "https://xyz.com/" + id
| table id, link 

I want the "link" column be visible as hyperlink (blue and underlined) in the dashboard, such that, each value of the column when clicked, opens the respective link in a new tab.

I tried making below changes, not sure what am i doing wrong here:

        "viz_jZKnPQQG": {

            "type": "splunk.table",

            "title": "x",

            "dataSources": {

                "primary": "ds_GresBkrN"

            },

            "options": {

                "tableFormat": {

                    "rowBackgroundColors": "> table | seriesByIndex(0) | pick(tableRowBackgroundColorsByTheme)"

                },

                "count": 8,

                "backgroundColor": "> themes.defaultBackgroundColor",

                "showRowNumbers": true,

                "fontSize": "small",

                "showInternalFields": false

            },

            "eventHandlers": [

                {

                    "type": "drilldown.customUrl",

                    "options": {

                        "url": "$row.link$",

                        "newTab": true

                    }

                }

            ]

        },

[Sharma21]

It worked. Thank you.

[renjith_nair · Accepted solution]

@Sharma21 ,

try adding the drill down

            "eventHandlers": [
                {
                    "type": "drilldown.customUrl",
                    "options": {
                        "url": "$row.link.value$",
                        "newTab": true
                    }
                }
            ]

Please find a run anywhere example

{
    "visualizations": {
        "viz_CIUVl7ST": {
            "type": "splunk.table",
            "options": {},
            "dataSources": {
                "primary": "ds_rMaj17sl"
            },
            "eventHandlers": [
                {
                    "type": "drilldown.customUrl",
                    "options": {
                        "url": "$row.link.value$",
                        "newTab": true
                    }
                }
            ]
        }
    },
    "dataSources": {
        "ds_rMaj17sl": {
            "type": "ds.search",
            "options": {
                "query": "| makeresults count=5\n|streamstats count\n| eval link=\"https://community.splunk.com/t5/Splunk-Answers/ct-p/en-us-splunk-answers/page/\" + count"
            },
            "name": "Search_1"
        }
    },
    "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": {
            "width": 1440,
            "height": 960,
            "display": "auto"
        },
        "structure": [
            {
                "item": "viz_CIUVl7ST",
                "type": "block",
                "position": {
                    "x": 0,
                    "y": 0,
                    "w": 1250,
                    "h": 300
                }
            }
        ],
        "globalInputs": [
            "input_global_trp"
        ]
    },
    "description": "",
    "title": "Studio_Link"
}