jaeW_at_Onyx Coach 
-
Re: has anyone had any luck creating dynamic columns in mysql
@BeastMode since you're asking a mysql question, stack overflow would probably be your best bet. but... let's close the loop here. why you trying to dynamically add 'missing columns'? how are you def…1 -
Re: How can prevent aggregation when graph by quarter
Dali did you want COUNT(DISTINCT) instead of COUNT? If so, you cannot COUNT DISTINCT across rows in a table card or graph. You might UNION a dataset to your dataset of just distinct customers.2 -
Re: Right way to utilize string operation on long date.
oh goodness... defo use @MarkSnodgrass method. it's easier to read and stores the data as type DATE which will have more flexibility in cards than type TEXT2 -
Re: Looking up values from secondary data source but for multiple columns in primary data source
@MarkSnodgrass + @pstrauss before you pivot, make sure to assign a value to how to prioritize the match. i.e. matchValue =1 if JOIN on Name matchValue = 2 if JOIN on Description matchValue =3 if JOIN…1 -
Re: Best Practice: ETLs Vs SQL ETLs
@imelendez Stacker was built back in Magic 1.0 era. Magic 2.0 should outperform virtually every ETL engine EXCEPT Adrenaline Dataflows and in some cases Data Set Views. UNLESS you are doing something…1
