Drill down from pie chart in dashboard studio

[NanSplk01]

I am new to dashboarding drop downs and I'd like to create a drop down for each slice of the pie.  I have created a search as a pie chart and tried to add a drop down that will search for only the slice I have selected.  So far it's not going anywhere.  This is what I have: 

"title": "Demo DCP Levels",

    "description": "",

    "inputs": {

        "input_global_trp": {

            "options": {

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

                "token": "global_time"

            },

            "title": "Global Time Range",

            "type": "input.timerange"

        }

    },

    "defaults": {

        "dataSources": {

            "ds.search": {

                "options": {

                    "queryParameters": {

                        "earliest": "$global_time.earliest$",

                        "latest": "$global_time.latest$"

                    }

                }

            }

        },

        "tokens": {

            "default": {

                "DCP-ERROR": {

                    "value": "ERROR"

                },

                "ERROR": {

                    "value": "ERROR"

                }

            }

        },

        "visualizations": {

            "global": {

                "showProgressBar": true

            }

        }

    },

    "visualizations": {

        "viz_4Ur0ZwMO": {

            "containerOptions": {},

            "dataSources": {

                "primary": "ds_iY2W7D6g"

            },

            "eventHandlers": [

                {

                    "options": {

                        "tokens": [

                            {

                                "key": "row.ERROR.value",

                                "token": "ERROR"

                            }

                        ]

                    },

                    "type": "drilldown.setToken"

                },

                {

                    "options": {

                        "tokens": [

                            {

                                "token": "DCP-ERROR",

                                "value": "ERROR"

                            }

                        ]

                    },

                    "type": "drilldown.setToken"

                }

            ],

            "showLastUpdated": false,

            "showProgressBar": true,

            "title": "DCP Levels",

            "type": "splunk.pie"

        }

    },

    "dataSources": {

        "ds_iY2W7D6g": {

            "name": "Pie chart search",

            "options": {

                "query": "index=\"dcp-np\" level!=INFO \n|  dedup level\n| stats count by level",

                "queryParameters": {

                    "earliest": "-15m",

                    "latest": "now",

                    "sampleRatio": "1"

                }

            },

            "type": "ds.search"

        }

    },

    "layout": {

        "globalInputs": [

            "input_global_trp"

        ],

        "layoutDefinitions": {

            "layout_1": {

                "options": {

                    "gutterSize": 10,

                    "height": 960,

                    "width": 1440

                },

                "structure": [

                    {

                        "item": "viz_4Ur0ZwMO",

                        "position": {

                            "h": 250,

                            "w": 1440,

                            "x": 0,

                            "y": 0

                        },

                        "type": "block"

                    }

                ],

                "type": "grid"

            }

        },

        "options": {},

        "tabs": {

            "items": [

                {

                    "label": "New tab",

                    "layoutId": "layout_1"

                }

            ]

        }

    },

    "applicationProperties": {

        "hideEdit": false,

        "hideExport": false

    }

}

How can I select a piece of the pie to drop down to another search?

[NanSplk01]

This worked perfectly.

[livehybrid · Accepted solution]

Hi @NanSplk01 

Instead of setting a token on click you can link to search, you can either do this in the UI and then specify your value using $row.<fieldName>.value$ (such as $row.ERROR.value$) or you can edit the JSON with something like this:

"eventHandlers": [
        {
            "type": "drilldown.linkToSearch",
            "options": {
                "query": "index=_internal sourcetype=$row.sourcetype.value$ | stats count by sourcetype",
                "earliest": "auto",
                "latest": "auto",
                "type": "custom",
                "newTab": false
            }
        }
    ],

In my example Im clicking on a piechart which has a "stats count by sourcetype" hence I am using $row.sourcetype.value$ in my drilldown search, does that make sense?

🌟 Did this answer help you? If so, please consider:

• Adding karma to show it was useful
• Marking it as the solution if it resolved your issue
• Commenting if you need any clarification

Your feedback encourages the volunteers in this community to continue contributing