What Grafana version and what operating system are you using?
9.1.6
What are you trying to achieve?
I wish to display “_time” value on url.
using for slack alert.
ex)
http://grafana.staged-by-discourse.com/testdash?time=1673935490620-3600000&time.window=3600000
How are you trying to achieve it?
like…
What happened?
I could not able to get _time value, because not labelize.
is it possible to get unixtime on message?
I managed by following method with flux.
I added following line inside query.
|> set(key: "atime", value: strings.substring(v: string(v: uint(v: now())), start: 0, end: 13))
Query will be…
import "strings"
from(bucket: v.defaultBucket)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["_measurement"] == "data")
|> set(key: "atime", value: strings.substring(v: string(v: uint(v: now())), start: 0, end: 13))
|> filter(fn: (r) => r["_field"] == "state" or r["_field"] == "atime")
|> aggregateWindow(every: 1m, fn: last, createEmpty: false)
|> group(columns: ["jigloc","SN","atime"])
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
Updated image 2023/01/28
Thank you for sharing solution with us! It will be of great help for me since I wanted to do the same. 
Best regards,
ldrascic