BigQuery SQL: Evolution of the running total on a dataset with missing dates

Handling missing values, window functions and nested queries with BigQuery SQL

One recent requirement that arrived in our Data and Analytics team was in the form of the question: “What is the number of year-to-date listed articles per shop, and how did this number evolve?”

Finding the total number of listed year-to-date articles was not a complex analytical task. However, the problem started when we wanted to present how this number increased over time. …

bigquery dataset evolution handling-missing-values sql window-functions