Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Any way that Range Sum can be used to sum up the previous Calendar weeks sales? I have an expression, but it does not provide the desired data.
Expression I have:
RangeSum(Distinct{$<[completed_date.autoCalendar.Date]={">=num(today())-7<=num(today())"}>}(order_total), (order_id))
Maybe using week, weekstart, or weekend functions, but not sure. Any help? Thanks in advance.
Have you tried with Sum() instead? like:
Sum(Distinct{$<[completed_date.autoCalendar.Date]={">=num(today())-60<=num(today())"}>} order_total)