Forgive the rookie question (I’ve been a Looker user for about a week now) but I’m trying to make a Prior YTD Measure (summing values from the start of the previous calendar year until today’s day in the previous calendar year) and am getting strange results.
- I started with a number-type dimension called sales
- I also have a time-type dimension group called posting_date to track sales dates
- From there, I’ve created a sum-type measure called sales_pytd
- I have two filters applied to sales_pytd: posting_date value = “before 365 days”, and posting_date value = “last year”
In practice, what I’m seeing is the “before 365 days” seems to be ignored, and the only filter which applies is “last year”. Any help on this would be appreciated.
As an aside, thanks to anyone who’s been posting here - I have already learned a ton from you all.