OBI Filter Week To Date
Hello OBI Users,
I was asked recently how to create a filter that would give results based on the week to date and I want to share my solution with you.
Assuming your week starts on a Monday I created an object with the following formula:
TIMESTAMPDIFF(sql_TSI_DAY, TIMESTAMPADD(SQL_TSI_DAY, - DAYOFWEEK(MIN("Requisition Dates"."Req. Creation Date")) + 2 , MIN("Requisition Dates"."Req. Creation Date")), NOW())
Here is the calculation for the start of the week. If your work week doesn't start on monday the +2 can be modified to move the start date: +3 would be Tuesday, + 3 would be Wednesday, etc.