I am creating a Canvas with a visualization in Timelion. I am able to get accurate time buckets, and when I look at the
datatable the graph is based on, I can see that @timestamp is being stored as local time with the correct offset. However, the x-axis will only display UTC times, and I can't simply use a fixed offset because of DST. My timezone in both Kibana settings and the
timelion function is set to my region.
I've been able to hack this in
essql by getting
DATEPART('tz', @timestamp) and then doing a
mapColumn to add this offset to @timestamp. However, my boss would really like a moving average , and it seems either very difficult or impossible to do this in Elasticsearch SQL. I have also tried saved visualisations but if I use a Canvas expression for the timerange, it automatically evaluates to a static timerange (or throws an error when I try to pipe it in).
Has anyone managed to handle this issue, and could I see your solution?