Canvas Time sets

[Min_Mah]

Hello
i have a question to canvas timezone

first. in table visual - ISOTime is UTC+09:00 so it is 2019-06-27T15:59:11
but in chart that Time is UTC so it is 2019-06-27T06:59:11

how can i set that time to UTC+09:00 ??

thanks.

[tims (Tim Schnell)]

Hi @Min_Mah,

Unfortunately this looks like an example described in this issue:

Issue: [Canvas] Display timestamp in the browser's timezone

[Min_Mah]

Thanks for reply
i was tried to set tz="UTC+9" but it doesn't work for me

filters
| essql query="SELECT * FROM "nx*" order by ISOTime desc" tz="UTC+9"
| pointseries x="ISOTime" y="size(level)" color="level"
| plot defaultStyle={seriesStyle bars=0.75} legend="ne"
palette={palette "#01A4A4" "#CC6666" "#D0D102" "#616161" "#00A1CB" "#32742C" "#F18D05" "#113F8C" "#61AE24" "#D70060" gradient=false}
font={font family="'Open Sans', Helvetica, Arial, sans-serif" size=14 align="left" color="#FFFFFF" weight="normal" underline=false italic=false} yaxis=false
| render

[dgonzalezp]

Hi @Min_Mah
I have solved it adding manually the hours that need.
Check my topic: Wrong Canvas timezone