Local timestamp in charts

0
Hi, I am wanting to visualized time series data in a line chart. From an API query I got the data with a UTC timestamp. In debugging mode, I can see, that the local and the UTC time is available. But the UTC timestamp will be shown on the fronted/chart widget. On other widget, like the grid view, an automatic conversion will be done. The timestamp attribute is configured as localized timestamp. Is there a way to select the correct timestamp or do an easy conversion? Thanks and regards, Ingo
asked
2 answers
0

Hi Ingo, 

Have you tried using a formatDateTime function. Maybe you could display the date as a string in the correct format instead of a DateTime

answered
0

Hi Moiz,

thanks for the advice. I have checked the configuration possibilities of the time series widget and it’s not possible to select a string variable as x-axis value, only date time variables are possible. Afterwards I have check the Any Chart widget and it could work, but I have to convert the whole timeseries to the plotly JSON.

answered