Canvas Time sets

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 ??


Hi @Min_Mah,

Unfortunately this looks like an example described in this issue:

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

| 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

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

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