{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Data Science Tech Brief By HackerNoon","title":"On November 1, Your 24/7 Dashboard Will Report a 25-Hour Day","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/b14b59bd\"></iframe>","width":"100%","height":180,"duration":353,"description":"\n        This story was originally published on HackerNoon at: https://hackernoon.com/on-november-1-your-247-dashboard-will-report-a-25-hour-day.\nMalek Damiri on why 24/7 dashboards report a 25-hour day when clocks fall back on Nov 1, and a calendar-table SQL fix for DST.\nCheck more stories related to data-science at: https://hackernoon.com/c/data-science.\n            You can also check exclusive content about #data-analytics, #sql, #daylight-saving-time, #time-zones, #business-intelligence, #data-engineering, #crypto, #dashboards,  and more.\nThis story was written by: @malekdamiri. Learn more about this writer by checking @malekdamiri's about page,\n            and for more stories, please visit hackernoon.com.\nAny business that runs around the clock but reports by local calendar day gets a 25-hour day when clocks fall back (November 1 in the US, October 25 in Europe) and a 23-hour day in March. Revenue operations lead Malek Damiri shows the 4% phantom swing it creates, three bugs that make it worse, and a calendar table with hours_in_day that fixes it, using runnable DuckDB and Snowflake SQL.","thumbnail_url":"https://img.transistorcdn.com/8VxAgS1Ll3FJEERcAdhFdqqXJMnE7OfD2RUvrjauLt0/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzQxMjY4LzE2ODM1/ODI1ODUtYXJ0d29y/ay5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}