Sync series in Period over Period on different column

  • 30 March 2021
  • 1 reply

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.

1 reply

Userlevel 6

I use dimensions so called “is_before_current_time_of_xxxxxx”


Basically I have a view called “current_time” that has SQL in my dialect (BigQuery) to calculate current second of day, week, month, quarter, and year.


I do the same in the destination view, like orders and order_created_at. And then create yes/no dimension by comparing those two values