Drill-down for mySQL time series data via data link

What Grafana version and what operating system are you using?
Grafana v9.5.1

What are you trying to achieve?
I want to display time series data stored in mySQL with a time series panel. My table contains test results of 2 different products, A or B. In the future, there will be more products. A test result contains an unique ID, a timestamp, the name of the corresponding product, and an integer value for the actual result. The table looks like the follows:

Every product should have its own line in the time series panel. The X-axis should be used for the time, the Y-axis should be used for the result:


When you click on a point, a data link should be available, which redirects the user to another dashboard, which contains a detailed view on the selected test result. For the redirection to the other dashboard, the ID of the test result is needed.


How are you trying to achieve it?

I created the time series panel. I added a multi-frame time series transformation. Then I added this SQL query:


What happened?

The time series panel displays the data correctly. But I’m not able to add the data link, because my time series panel does not contain the IDs of the test results. When I add ID to the select statement, the panel adds more lines to the plot.

How can I achieve the desired behavior?