Best Of
Re: Calculate % of Repeat Customersvia Beast Mode
To do aggregate (as opposed to row-level) calculations in a BeastMode, you'll need to use FIXED functions:
Yours would be something like:
(case when sum(count(Distinct `Customer Name`) fixed())>=2 then 1 else 0 END)/sum(count(distinct `Customer Name`) fixed())
Re: HELP with Case When Statement
Thanks for picking this up @MarkSnodgrass & @ST_-Superman-_ - great solution! :)
Samuel.
Re: How to extract Date from TimeStamp1, Time from TimeStamp2, and then combine the two?
Try this:
Use the DATE() function to extract the date from the field you want just the date
Use the TIME() function to extract the time from the field you want just the time
Use the ADDTIME() function to add the two together ADDTIME('dt','tm')
I did a quick test in Magic ETL and it worked for me. I had them each separated for testing, but you should be fine wrapping it all into one like this:
ADDTIME(DATE('datefield',),TIME('timefield'))
Re: How to work a dynamic textbox
Ahh... I think I see the issue. Put your actual event date field in your sorting field and not the beast mode formatted field. I failed to notice in my own configuration that I have the actual date field in the sorting. Sorry I didn't catch that earlier.