cancel
Showing results for 
Search instead for 
Did you mean: 

Replicating DIFFPASTWEEK logic in BigQuery

amelia
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!

 

 

0 REPLIES 0
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!