Question

Sync series in Period over Period on different column

  • 30 March 2021
  • 1 reply
  • 5 views

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
Badge

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

Reply