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

[mah]

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 :

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

[ashvinpandey · Accepted solution]

@mah use the below command :

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

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

[mah]

@ashvinpandey thanks a lot ! It works properly