Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Working on a measure that would show me total sales from last full week based on todays date. So far I have this expression but it is not functioning:
sum(aggr(sum(distinct{$<[completed_date.autoCalendar.Week]={"$(=Week(Today(1) )"}>}(order_total)), order_id))
Any help on with this expression is appreciated. Thanks in advance
May be because you are missing a parenthesis
Sum(Aggr(Sum(DISTINCT {$<[completed_date.autoCalendar.Week] = {"$(=Week(Today(1)))"}>} order_total), order_id))
Made that change, but still not functioning. Thanks though, probably not going to hurt to have the correct amount of parenthesis in espression.
Can you show the script for the derived calendar?
Not sure how to do that, maybe I don't have access to it?