3 ms·
Also for Q1 - what if there is gap one or more months? It seems we should first generate a month series based on the min and max months, and left join to the se
by heed 6y ago
Also for Q1 - what if there is gap one or more months? It seems we should first generate a month series based on the min and max months, and left join to the series to account for months with zero activity.
- thomzi12 6y agoSure! Practically speaking, as a data analyst, I would probably notice a missing month when plotting the trend of MAU over time. (You can make "but what if a month is missing?" a latter part of a multi-part interview question) Generally I would assume that data engineers would have a month of no users set to zero or that I could ask them why that's not the case and note that for future reference.