Dashboards & Visualizations

How to convert epoch time field when using it as value in chart command

mah
Builder

Hi,

I have a table built with a chart command : 

| stats count  by _time Id statut
| xyseries Id statut _time

Before using xyseries command, _time values was readable but after applying xyseries command we get epoch time like this :

mah_0-1632154167797.png

Can you help me to transform the epoch time to readable time ?

Labels (1)
0 Karma
1 Solution

ashvinpandey
Communicator

@mah use the below command :

| convert ctime(field_name1) ctime(fieldname2) ctime(fieldname3)

Also, If this reply helps you, an upvote would be appreciated

View solution in original post

ashvinpandey
Communicator

@mah use the below command :

| convert ctime(field_name1) ctime(fieldname2) ctime(fieldname3)

Also, If this reply helps you, an upvote would be appreciated

View solution in original post

mah
Builder

@ashvinpandey thanks a lot ! It works properly

0 Karma
Did you miss .conf21 Virtual?

Good news! The event's keynotes and many of its breakout sessions are now available online, and still totally FREE!