Currently, the zoom-in.timeseries drill thru is only available when the user clicks on an aggregated cell value, and the drill selects the first timeseries dimension it finds in the query's breakout columns.

Consider also making the drill available when a user a clicks on a cell value for a timeseries breakout column, and use the clicked column as the selected dimension.

For example, given a table result like

| Created At: Month | Created At: Year | Count |
|-------------------+------------------+-------|
| July 2022         |             2022 |    11 |

If the user clicks on the cell with value "2022", show "See this year by quarter" in the drill through context menu.
If the user clicks on the cell with value "July 2022", show "See this month by week", etc.

Context

https://metaboat.slack.com/archives/C0645JP1W81/p1733772025429769