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’:

cb07df3c-3e71-4004-b1cc-a0749e448659.png

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’:

2c291f68-1c0a-4961-8926-7da6e288ead2.png

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

1647a870-82d2-4b55-a49c-903d5ba1221f.png

The week numbers are not synched.

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

1 0 44
0 REPLIES 0
Top Labels in this Space
Top Solution Authors