Best Of
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!
Re: DOMO Regex Extraction ETL
Hi @rwalsh25
If you're wanting to keep the original text and split work order number into a new column you'd need to split your dataset, pull just the key fields and the note field, then use the regex and then join the data back together using your key fields. If you're using ETL 1.0
If you're using ETL 2.0 you can just use a formula tile to define your new column name and run the regex_replace function on your notes field.
REGEXP_REPLACE(`note`, '^.*(W\d{15}).*$', '$1')
^ = start of the string
.* = 0 or more of any characters
(W\d{15}) - Captures the work order number in the format of W followed by 15 digits.
$ = end of the string
Simply match the entire string and replace it with only the work order number
Re: How do I remove the "Warning: Not All the Data is Shown" from a filter?
Adding a sort and count aggregation seems to have removed the issue.
Side note: not being able to remove your own posts is a real bummer.
Re: Column Masking
I'm not sure this counts as an idea since it has already been announced. But I'll upvote because I am excited about the feature







