jaeW_at_Onyx Coach 
-
Re: How do I parse column data into separate row for each unique sets of values?
looks like you could split your data using a comma delimiter. have a look at the split_part() function in MagicETL > Formula tile from there you can use the same techniques laid out in this video,…1 -
Re: Clickable email link to Beast Mode field
concat( '<a href="mailto:' , case when rand()> .5 then 'someone@example.com' else 'hello@example.com' end ,'?Subject=Hello%20again" target="_BLANK">Send Mail</a>' )…1 -
Re: Is it possible to pass custom parameters to a card and merge them into a report?
@GrantSmith you forgot to link the video! https://www.youtube.com/watch?v=wmMrnPO9ivY&t=2s @user052485 this is the design pattern Grant was referring to.1 -
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: 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
