A common data challenge involves accounting for data which may not be current, often due to a lag in upstream data pipelines. For example, you’d like to look at the past X weeks of data, but due to this lag the past X weeks is really X + Y where Y is the time since data was last updated. Here is a recorded walkthrough of one approach!
PS: If you think of other approaches please suggest them, we’d love to hear from you!