Comments
-
I don't recognize where you're doing this from based on your screenshot. Are you not able to accomplish this task through the creation of a card? If not, can you create a "helper column" within the Data Warehouse that evaluates the necessary fields and creates a True/False condition?
-
SUM(IFNULL(DATEDIFF(CURDATE(), 'Start Date'), 0)) / NULLIF(SUM(IFNULL(DATEDIFF('End Date', 'Start Date'), 0)), 0)