How to add 9 HOURS manually with timelion-based canvas line graph

Elastic Stack Kibana
,
1

Hi. I need some Help.

Is it possible to add 9 hours manually to hourly line graph?

Definitely, I'm drawing Today's hourly success-rate for specific action.
So, I set up the timeFilter "Today" and add "1h" interval condition my timelion query.
I want to make line graph starting with "2020-08-12 00" on x-axis but my graph start with "2020-08-11 15". Is there anyone who can help me add 9 hours to each date on X-axis?

image001 (1)

Graph
Graph1444×252 21.7 KB
Expression Editor
Expression Editor2511×219 23.5 KB

2

Do you want to do this because you want to show the chart in your local timezone? If yes, then you should be able to just omit the mapColumn function in your expression turning the @timestmp column into a formatted string. When you pass the date directly to the chart, it will use the local timezone of your browser and apply a nice formatting by default.

3

Thank you for your advice:)

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.