Return Visualization and table from one search

[Tachikoma]

Apologies if this has been asked before. 

Essentially, I have a Single-value visualization in a dashboard that just displays a number. This dashboard was built in Dashboard Studio, and the search tied to the visualization is a simple:

Index="my_index"
| stats count

What I want to accomplish is that when people open this search from the visualization, instead of displaying the | stats count, it will display a table of the data.

If I add a table command at the end, I lose the stats for the visualization. Is there any way to have both a table and stats from one search? Or is there a way to have a different search open when somebody clicks this visualization?

[Tachikoma · Accepted solution]

I found the answer. I added an interaction to my dashboard visualization, and linked a custom URL to the search I wanted. So now when users click on the number in the dashboard, it takes them to a table of the data.