Shumilex Member

Comments

  • @GrantSmith this wouldn't fix the subtotal though? I've had other calculation that calculated using an HTML code. I'm just not sure why this isn't doing it.
  • @GrantSmith Thank you. I did the below as well, both seem to give the same results: case when `ServiceName` like '%Manual_Only%' then (`InCallMin`)/ NULLIF(((`ReadyMin`+`InCallMin`+`NotReadyMin`+`WrapUpMin`) -(`LunchMin`+`BreakTimeMin`+`TrainingMin`+`MeetingMin`)),0) End
  • Hey Guys, Thanks for the assistance @MarkSnodgrass and @GrantSmith, the below is what I used: CASE WHEN `Date_Arrangment_Set_for` >= CURRENT_DATE() AND `Date_Arrangment_Set_for` <= LAST_DAY(CURRENT_DATE()) THEN 'Include' ELSE 'Exclude' END Not sure why but when I was using BETWEEN based on Grant's suggestion it did not…
  • The calculations seem to work when the time is over 24 hours however there are some response time that are <1, 1, 2, 3, 4, 5, 6, 7, etc. hours and that's the issue I'm having because it is not calculating based on the hours, minutes, or seconds. @jaeW_at_Onyx @GrantSmith
  • Hi @GrantSmith Here is an excel with sample data of the closed and created times. I started using the below to get the response time: Closeddate - Createddate I cross checked with excel and it was matching, then I was turning the result to a whole decimal number which can be seen in the screenshot below the column "Total…
  • Hi Guys, thanks, I noticed the missing quotes afterwards an it did work. 🤦
  • Thanks! I thought I tried LIKE and it didn't work at the time, but maybe with the recent updates since Domopalooza it works now. I do have one follow up question because I'm getting some text as the below example: "Bankruptcy Record Miscellaneous Customer sent notice of impending dismissal." When I utilize the below:…
  • Hi, @jaeW_at_Onyx The beast mode saves - but adding the beast mode as a field in the pivot table card is when it doesn't allow the card itself to save. The beast mode validates and I have tried renaming several time with no change. I even tried it without double nesting and it does not allow it to save. I created the time…
  • This worked! I should've come to the Dojo from last week. lol. Thanks so much @GrantSmith