How to convert a timestamp in Grafana from a formatted string to epoch milliseconds and create a time range URL parameter?
I am currently working with Grafana and trying to create a link that redirects to another dashboard with a specified time range, which is 5 minutes before and after a certain timestamp. I have the timestamp details in a formatted string (e.g., "2023-09-20 16:00:20") and I am trying to convert it to epoch milliseconds to use in a URL parameter (like 1695218420000, which seems to be in UTC+02:00).
The time from the log entry is captured in a variable ${__data.fields.Time} which gets substituted into the URL. However, Grafana seems to be unable to interpret the formatted date-time string in the URL parameters for 'from' and 'to' fields to set a correct time range.
For example, using the link structure: https://localhost:8443/d/XtPc_riIk/fehler-kontrolle?orgId=1&var-hostname=${__data.fields.hostname}&from=${__data.fields.Time:epochmillis-300000}&to=${__data.fields.Time:epochmillis+300000} translates to: https://localhost:8443/d/XtPc_riIk/fehler-kontrolle?orgId=1&var-hostname=mrs2-11&from=2023-09-19%2006:55:49&to=2023-09-19%2006:55:49 which is not the correct format for the 'from' and 'to' parameters in Grafana.
I attempted to use the epochmillis function to convert the formatted date-time string to epoch milliseconds directly within the URL, expecting Grafana to be able to interpret and translate it into the correct time range. Additionally, I tried adding and subtracting 300000 milliseconds (5 minutes) to create a time range around the timestamp. However, Grafana seems to not be interpreting the formatted date-time string correctly and is not converting it to epoch milliseconds as expected.
My current Setup:
As @markalex recommended, I employed transformations to introduce additional columns with dates. Regrettably, concealing them disrupts the link functionality, so I have to retain their visibility.
- Timestamp Difference In Hours for PostgreSQL
- NonExistentTime error caused by pandas.Timestamp.floor with localised timestamp
- Prepend timestamp to each line received from stdin
- Convert timestamp to date in Spark dataframe
- How to do dbt_tests on timestamp data type?
- How can one change the timestamp of an old commit in Git?
- Plotting timestamps (hour/minute/seconds) with Matplotlib
- In Ruby on Rails, what's the difference between DateTime, Timestamp, Time and Date?
- Why most API use ISO-8601 timestamp format over epoch?
- Reading date from .xlsx file returns 5 digit timestamp, what is this?
- Selecting today's rows based on UTC time
- How to convert PostgreSQL timestamp with time zone to DateTime?
- Is there a way that i store timestamp with time zone in Postgres and not converting it to UTC
- Get timestamp of today and yesterday in php
- For timestamp with timezone, the internally stored value is always in UTC
- Error while trying to insert data into timestamp field using plpgsql
- Get timestamp in PySpark from GregorianCalendar
- Select rows for a specific date using TIMESTAMP datatype
- How to get the current time in seconds since the epoch, in Bash on Linux?
- Python code output to a file and add timestamp to filename
- convert mysql timestamp into actual date and time?
- R calculate timestamp of earliest sequential prior message based on user ID of who sent message
- R calculate timestamp of last message based on user ID of who sent message
- Reading back a datetime in sqlite3
- qDebug Console output with Timestamp
- How to create a tar file that omits timestamps for its contents?
- Difference between CURRENT_TIMESTAMP and CURRENT_DATE
- How to convert HH:mm:ss.SSS to milliseconds?
- Sqllite query convert timestamp to date
- Insert time fields in timerange