I am trying to create a look that will compare the number of orders of the current month with the previous month. The data model has a column that has an active count on which the number of business days has passed in the month, and I want to sync both series to that value. So if today is the 5th business day of March, I would like to see a series only account for days 1-5 in February, then another with days 1-5 in march.
Then the filter will automatically expand to include day 6 for both months. If a month has more business days than the other then it will stop at its max while the other continues until its max.
Is there a way to set this up in looker? Thanks.