Add option to dashboard cells, to open their queries in the data explorer

[mark-rushakoff]

Proposal:

In this dropdown on dashboard cells:

There should be an option to open the query or queries for that cell in the data explorer.

Use case:

I often need to drill down further from what I see in a dashboard cell, without any intent of changing the cell. Most of the time when I am doing this, I am looking at a cell that I configured with the script editor. For example, I may be looking at a cell with dozens of series in a line graph, but I may want to modify a filter call to focus on a smaller subset of those series.

Because there is no option to copy queries to the data explorer, I have to:

1. Choose to configure the cell (which worries me that I may I somehow accidentally modify the cell).
2. Copy the content of the query I want to explore further.
3. Carefully click the X button, not the check, to close the cell editor.
4. Click over to the data explorer view.
5. Change from the query builder to the script editor.
6. Paste in the query I copied 4 steps ago.
7. Start editing the query, which is what I wanted to do in the first place.

Steps 1-6 should be done in a single click.

[jbp4444]

+1 to this -- this could be a fairly straight-forward way to providing some basic interactivity to dashboards.

A related/drill-down request: #23742 -- perhaps naming that menu-entry "Drill-down" would make it clear that it is not modifying the dashboard query/not cloning it.