Best Of
how do I convert data time field to yyyy-mm-ddThh:mm:ss
so that when i export the file shows 2020-09-14T11:56:43 instead of 14-Sep-20 11:56:43 ?
Re: HeatMap Chart Colored by Columns
Agree with @execdata. Column based formatting is to cohort tables as Patagonia vests are to finance bros.
Re: Smart Text - Add "Limit Rows"
BVK,
I think you are going to need to elaborate on your idea a bit more in order to get it voted up. :)
Re: Smart Text - Add "Limit Rows"
You are too fast @MarkSnodgrass! It accidentally submitted mid-word, haha
Re: Congratulate our newest Community Coach, Colemen Wilson!
Big congrats @colemenwilson. I want to be you when I grow up.
Re: Earn a badge and 20 easy points by updating locations in your profile!
Done… but not as fast as Grant and Michelle (unsurprisingly) 😁
Re: ETL not running
I opened this and I thought I was looking at a map of the game Risk.
Re: Beastmode subtotal not calculating correctly
@Anna_Otake could you do a COUNT(DISTINCT LY Email Sends) to ensure your getting unique email sends and not total sends per day?
Edit: @MichelleH beat me to it :)
Re: How to add parameter into Beast Mode
Hi @user034162
Not directly on the card itself sadly. The way to do this is to utilize a webform and join that to a data fusion. If the user needs to change the parameters they'd change the values in the webform. Not ideal but the best solution we have at this time.
@jaeW_at_Onyx has done a video which outlines this process here: https://www.youtube.com/watch?v=wmMrnPO9ivY
Re: Undo button in Magic ETL
I hit ctrl+z all the time forgetting that it will do NOTHING!



