Format timestamp Timelion into date

Elastic Stack Kibana
1

Hi, Using the Timelion, I would like to know how to format the timefield ='time' <- timestamp into days, something like this 'dd-mm-yyyy' in order to show the trend with big periods of time avoiding the split by hour.Thanks

2

Hi @Eduardo_De_Zulueta, I'm not completely sure I fully understand your request but I will try to give you some hints:

  • have you tried to use the Interval dropdown just above the timelion expression? you can specify here that you want 1d intervals so the data is aggregated in a daily basis
  • if the problem is with the tooltip on the top-left side of the visualization, you can format the date displayed with the following function .es(*).legend(timeFormat=DD-MM-YYYY) following the format convention of moment.js https://momentjs.com/docs/#/displaying/format/

If none of these are what you were looking, please could you specify a bit more your usecase and what you want to achieve? anything useful to understand better the request is welcome

Thanks

1 Like
3

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