david_cunningham Coach 
-
Re: Custom Date & Timestamp Formatting in Analyzer View of Cards
This is a fantastic write-up @Jonathan53891 ! Thank you so much for all your work pulling this together 😎2 -
Re: Random Number
@Ashleigh in that case, what if you did something with DENSE_RANK()? DENSE_RANK() over (order by SUM(value) desc) You could then do something like this CONCAT('Customer ',DENSE_RANK() over (order by …2 -
Re: Is it possible to upload many google sheets at the same time?
With the Google sheets connector, you have to specify which sheet you want to upload, so unfortunately there isn't a built in way to do this. Here is what I would recommend Assuming these sheets all …2 -
Re: Rolling 12 Month Average in Magic ETL
@MarkSnodgrass has a fantastic YouTube video on this exact topic! Check it out 😁 The video covers 30/60/90 day rolling windows, but you can adapt this to your particular requirements. Thanks Mark for…1 -
Re: How to extract a substring from an URL
SUBSTRING_INDEX(url,'/',2)3
