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.
    in Beast Mode Calculation Subtotal/Total Comment by Shumilex September 2021
  • @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
    in Division by Zero ETL Formula Comment by Shumilex August 2021
  • 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…
    in Current Date to EOM Filter Comment by Shumilex August 2021
  • 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
    in SLA/Response Time Beast Mode Comment by Shumilex July 2021
  • 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…
    in SLA/Response Time Beast Mode Comment by Shumilex July 2021
  • Hi Guys, thanks, I noticed the missing quotes afterwards an it did work. 🤦
    in Beast Mode - Count Case When with multiple criteria Comment by Shumilex July 2021
  • 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:…
    in Formula to search text Comment by Shumilex April 2021
  • 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…
    in Beast Mode Not Allowing Card to Save - AVG SLA BEAST CALCULATION, HELP? Comment by Shumilex February 2021
  • This worked! I should've come to the Dojo from last week. lol. Thanks so much @GrantSmith 
    in % of Total Comment by Shumilex December 2020
Avatar