Comments
-
This is great! Thank you!
-
checking in for LocumTenens.com @DanHendriksen
-
@trafalger I tried that and no luck
-
Looks like I have to create this change in the Dataflow because SELECT a.* ,COUNT(DISTINCT(case WHEN a."Status__c"='Booked' and (a."Status__c" = 'Booked' > 111 THEN 'TIER 4')) FROM "sfdc_travel_raw" a I am getting an error
-
@GrantSmith Thank you for your help!!
-
Thank you for your help. Now I'm trying to find the results of a survey only for the dates of 2021 CASE WHEN `end_date__c` >= '1/01/2021' and `end_date__c` <= '12/31/2021' then `answer value` *1' else '0' end