Calendar heatmap dates shifted by one (converting to local time zone)

[ghost]

@hyperborea commented on Jan 8, 2019, 5:17 PM UTC:

Make sure these boxes are checked before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if there are any.
• I have reproduced the issue with at least the latest released version of superset.
• I have checked the issue tracker for the same issue and I haven't found one similar.

Related to #3326, which is closed but has not been resolved.

Superset version

0.28.1

Expected results

Time is displayed consistently in the same time zone on the calendar heat map as for the data queried. The January day view should start with the 1st of January for example.

Actual results

The January day view starts with the 31st of December 23:00 for setups using CET. The data is queried correctly in UTC, but somehow seems to be displayed in local time zone instead.

Steps to reproduce

• create calendar heatmap
• configure with "day" time grain, "month" domain and "day" subdomain
• observe months starting with the previous months day for time zones east of GTM and all days shifted accordingly

This issue was moved by kristw from apache/incubator-superset#6619.

[ghost]

stale[bot] commented on Apr 10, 2019, 9:59 AM UTC:

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[lewlh]

I have the same problem。

[priyajos]

I have the same problem。

[karbofoko]

have the same problem, any plans to fix this?

[karbofoko]

it seems dates are shifting only in the tooltip, rest logic works fine (days of the week, values by dates).
Shifting date back before formatting in the tooltip fixed problem for us:
${self.options.timeFormatter(d.t + 24*60*60*1000)}:...

superset-ui-plugins/packages/superset-ui-legacy-plugin-chart-calendar/src/vendor/cal-heatmap.js

Line 28 in a69b859

${self.options.timeFormatter(d.t)}: <strong>${self.options.valueFormatter(d.v)}</strong>

don't forget to reset browser cache

[dofine]

Any progress on this, please?

[ghost]

This issue was moved by kristw to apache-superset/superset-ui#409.