API (Power BI / Looker) - Overdue Logic To my knowledge, the API doesn’t have a specific field for whether or not a work order is overdue, so we need to create a new value in order to expand on the existing reports.This is the base formula I’m using: OverdueState = // Work order is considered overdue if [Completed On] > [Due Date] IF( 'WorkOrders'[Completed on] > 'WorkOrders'[Due Date] , TRUE , FALSE )I’ve tried filtering by various combinations of work order creation, close, & updated timestamps and Status=CANCELED/SKIPPED. The numbers are always close to what shows up on MaintainX reporting, but are always slightly off. Has anyone had any luck recreating the overdue logic that MaintainX reporting uses?