Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

Learning Center Articles
, , ,
79

@prkgupta Great! To only take same days of last week (aka Last WTD, vs full last week) you can add one more condition. Ill add it to the article too.

Last WTD:
ifelse(truncDate(‘WK’, {order date})= addDateTime(-1, ‘WK’, truncDate(‘WK’, now())) AND {order date}<=addDateTime(-1, ‘WK’, now()), sales, 0)

1 Like