I can change the unit to date or even duration, but cannot filter because cannot use variables on “transform data”.
My data source is zabbix plugin, so I cannot apply the filter in the query.
Try thinking of breaking the original time series table and then transforming it on a new time series that can use the global time filter on the duration column (A.K.A - Use “duration” column as the “time” column).
I’d try playing around starting on “Prepare Time Series” and with some “Rename by Regex” and “Format Time” to achieve it. (Transform data | Grafana documentation)