saghatelian opened a new issue, #23167: URL: https://github.com/apache/superset/issues/23167
In Dataset Settings there is an option called "HOURS OFFSET". When you have only one time column, it's working as expected: it adds the corresponding number of hours to the time column while outputting it on the chart. However, when you have more than one temporal columns, the number of hours is logically expected to be added to all of them. Now it adds to only the one column that is selected as the "TIME COLUMN" in the chart. #### How to reproduce the bug 1. Create a dataset with more than one temporal field (e.g. Creation and expiration dates, as in the screencast), 2. Add "HOURS OFFSET" to the dataset settings (e.g. 4) and save the dataset, 3. Choose a "TIME COLUMN" in the Time settings of the chart and click Update, 4. Choose another "TIME COLUMN" and click Update ### Expected results X hours (set in "HOURS OFFSET") should be added to all temporal fields, regardless of the "TIME COLUMN" selected. ### Actual results X hours are added to only one column, the one that is selected as the "TIME COLUMN" in the chart. Note, that in the screencast, the "Expire Date" of the bottom row is actually equal to the "Agreement Creation Date" of the top row, but they are displayed with a 4-hour difference either way, because of the "HOURS OFFSET" option set. #### Screenshots https://user-images.githubusercontent.com/43491361/220833739-32950223-19ba-40e4-be12-d09804c40fde.mp4 Note, that the "Expire Date" of the bottom row is actually equal to the "Agreement Creation Date" of the top row, but they are displayed with a 4-hour difference either way, because of the "HOURS OFFSET" option set. ### Environment (please complete the following information): - browser type and version: Version 110.0.5481.112 (Official Build) (64-bit) - superset version: `latest` (checked on `latest-dev` too) - any feature flags active: "DASHBOARD_CROSS_FILTERS": True, "ALERT_REPORTS": True, "ENABLE_TEMPLATE_PROCESSING": True, "ENABLE_TEMPLATE_REMOVE_FILTERS": True, "GENERIC_CHART_AXES": True ### Checklist Make sure to follow these steps before submitting your issue - thank you! - [x] I have checked the superset logs for python stacktraces and included it here as text if there are any. - [x] I have reproduced the issue with at least the latest released version of superset. - [x] I have checked the issue tracker for the same issue and I haven't found one similar. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
