Blog

After initially hiding the Time Series feature within the Explorations section of their Forward platform, the team responded to user feedback by reinstating it as a standalone feature and rebuilding it from scratch. This revitalized Time Series tool enables users to transform selections into SQL queries, facilitating the analysis of data over time by allowing for the selection of data sources, time columns, and aggregation methods. The blog post details the challenges faced in generating accurate SQL queries, such as handling missing data and aligning timestamps, as well as the adaptive granularity mechanism to ensure appropriate data point distribution. Additional UI enhancements include schema inspection, query cancellation, and workspace sharing, along with the ability to switch between line and bar charts. Furthermore, an integration with Observability charts allows users to explore data more interactively, bridging the gap between monitoring and investigation. The tool is designed to streamline the investigation process following alerts, enabling users to quickly analyze and share findings without needing to manually write SQL queries.