Thank you for the tip, I think that’s really close to what I’m looking for.
We track our success against a few Org metrics (in our case, Lives impacted through our cellular therapies) but management wants to exclude the current month from a YOY growth visualization to increase clarity. So we would only show January through October for the current year, but then show January through December for the prior year.
As I’m typing this out, I’m realizing that a merged result set might be more what I’m looking for, with some If statements in table calculations to compare the month(now()) versus month(date()).
This does bring up a new question: Is there some sort of a guideline or a “hitchhiker’s guide” (for lack of a better term) that explains the best time to use each of the features or functions of Looker? I feel like I’m close to changing my middle name to “PDT” based on the number of times I fall back on them as a solution - is this an acceptable use?