jaeW_at_Onyx Coach 
-
Re: Magic ETL | Remove Duplicates Tile | Select all fields option
@Godiepi that's a pretty obscure use case that you'd expect full-on row duplication. you could use MD5() hashing to concatenate all the values together and then use a RowNumber + rank_window tile the…2 -
Re: Subtract Dates
@tobypenn most beast mode functions just use MySQL syntax1 -
Re: Population calculations in beast mode?
@ST_-Superman-_ and @datamatt , typically for anything like headcount data, you'd want data the granularity of one row per client_id per facility per day. if you don't, imagine i have a customer who …2 -
Re: Freezing card at end of Fiscal Year
consider adding a "is_closed_period" column. that way you can filter on transactions that are part of the closed period and functionally "freeze" the data. alternatively, if you l…1 -
Re: Formula for rounding time to nearest minute
my approach would be to try to take a timestamp and date_format( hh:mm) that would always round down. to address round up, i'd use a CASE statement so if second() is 30 then hh:mm + 1 minute.1
