I want all your help. I have a time series panel showing Phase 1 voltage trends. DateTime column is of format : ‘YYYY-MM-DD HH:mm:ss’. What I want to do I when I click at a particular data point in time series panel, then that DateTime value should be stored in the variable. My issue is incorrect time is being stored in the variable.
Let me explain in detail. I have added a data link in time series panel :
‘/d/bc81fd2a-1cbc-4416-be49-5886a7ceda53?var-select_time=${__value.time:date:YYYY-MM-DD HH:mm:ss}&from=${__from}&to=${__to}’
Variable Name is ‘select_time’ and it is of Text Box type.
Earlier I have written var-select_time=${__value.time} only. Then the DateTime was stored in milliseconds (Unix epoch time in ms).
So I have made changes in data link and wrote : var-select_time=${__value.time:date:YYYY-MM-DD HH:mm:ss}
This part ‘&from=${__from}&to=${__to}’ is written so that upon clicking on a data point, the dashboard time range doesn’t change.
The issue is when I click on a data point in time series panel, lets say I click on point having DateTime value as ‘2025-01-01 16:06:47’, the value that is stored in select_time variable is ‘2025-01-08 13:18:44’. The DateTime stored is almost 7 day ahead in future.
Your help will be appreciated.