Hello.
I was able to set the data link whose value is from the query(url column) to only the first series on the time series graph, but I want to set it to all series as well. There is a “about:blank” link on the plot of every other series.
For example, there is a data link in the plot of the green series, but not in the others.
How can I solve this problem?
settings:
- I’m using “grafana/grafana:11.1.0”
- Visualization: Time series
- Query
- “SELECT timestamp, name, numeric_value, url FROM table ORDER BY timestamp ASC”
- timestamp is for X axis, numeric_value is for Y axis.
- I want to use the value of “url” as data link
- “SELECT timestamp, name, numeric_value, url FROM table ORDER BY timestamp ASC”
- Format: Table
- Transform data
- Partition by values: name
- This is to draw multiple series partitioned by name on one panel.
- Partition by values: name
- data link
- ${__data.fields[url]}
Query result sample:
| timestamp | name | numeric_value | url |
| 2024-07-17 09:00:00 | aaa | 10 | https://.aaa1… |
| 2024-07-17 09:00:00 | bbb | 15 | https://.bbb1… |
| 2024-07-18 09:00:00 | aaa | 20 | https://.aaa2… |
| 2024-07-18 09:00:00 | bbb | 25 | https://.bbb2… |
| 2024-07-19 09:00:00 | ccc | 10 | https://.ccc1… |
| 2024-07-20 09:00:00 | ccc | 15 | https://.ccc2… |
The value of url is different from each other.
Thank you.