ggenovese Coach 
-
Re: Error with String to Date
there's a FUZZY_PARSE_DATE() function in Magic ETL, I tested with the string '/3/31/24/' and it converted it to date without an error2 -
Re: Count the number of upper case letters in a string
I think you have to do this in an ETL, because REGEXP_REPLACE() doesn't work for me inside of a card. LENGTH(REGEXP_REPLACE(`sample`,'[^A-Z]',''))2 -
Re: Convert time to decimal
there is actually a TIME_TO_SEC() function that will convert to seconds, in order for it to be a decimal you have to determine if you want your value to be a fraction of a minute, an hour, or a day2 -
Re: Removing Duplicates and making sure only the one with the most recent move in stays
If you use a Rank & Window tile in your ETL you can apply the DENSE RANK function to rank on MoveDate descending and partition by the Unit Id. This should give you a Rank of 1 for the most recent…1 -
Re: Highlight Filter Functionality
Highlighting doesn't work on all card types unfortunately. You can see in my screenshot below when I hover over "Friday" in my upper left table card, it highlights the Friday bar on th…1
