Showing results for 
Search instead for 
Did you mean: 

Replicating DIFFPASTWEEK logic in BigQuery

9 - Travel Pro
9 - Travel Pro

My current view has a date column and a column with metric 1 (as shown in screenshot). In the Sisense widget front-end, I aggregate the dates as weeks. This sums up metric 1 for all the dates in a week.

I then use the DIFFPASTWEEK function to create a metric that shows the difference between each week. However, I do not understand the DIFFPASTWEEK function well enough and want to recreate this logic in BigQuery. Can anyone please advise on this? Thanks!



Voice of Customer
Impact Business Intelligence (BI) and Analytics Market Research

Click Here & Complete Dresner's Wisdom of Crowds® Market Study Survey Today!

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request

Don't miss out:

Earn a BETA Launch Challenge Badge!