Question

Pivot by 2 fields from 2 different explores


There is a ‘company’ table. This view joins to a ‘content’ dt that includes the number of content that a company created each week from the day the company created. I used the ‘date_diff’ function to calculate the week duration between the ‘company_create_date’ to the ‘content_create_date’:

The ‘company’ table is also joined to a ‘view’ table that includes all the number of views that a company has in the contents they created, each week from the day the company created. I used the ‘duration’ function to calculate the week duration between the ‘company_create_date’ to the ‘view_ts’:

 

I want to create one table including these 2 tables. When I tried to do that, this is what happened:

The week numbers are not synched.

 

Please help me to think of another way to create this table


This topic has been closed for comments