Best Of
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
Re: Apple watch widget for displaying a Card
:) How big is your watch? I have a hard enough time viewing some cards on my phone.
Domo Variables Use Cases
A customer is seeking access to access to a page called "Domo Variables Use Cases" that provides examples of variables and appears in the below video:
BGomez
Re: Magic ETL Dynamic Pivot
Is there already somewhere to upvote a dynamic pivot tile in magic ETL?? I would love to upvote that bad boy :)
Re: Is there a way to change the labels in a legend?
How to Create Monthly Averages for Headcount?
Hi All,
I'm in the process of building an attrition model in Domo in the form:
Total Terms / Average headcount
Terms is easy, that's just a count of everyone with a term status for that time period. Headcount is where I'm getting stuck. My headcount numbers are currently aggregated based on headcount at the end of each month. I've just been using this number so far, but I'm about 1/10% off in terms of accuracy.
In order to get average headcount, it should be:
((Current Month's headcount + Last Month's headcount) / 2)
I could write this manually for each month for the last decade, but that would take a lot of time and require I update the code every month, which I would prefer not to do. Is there a way to do this in Beast Mode with a couple of lines instead of a line for every month?
Thanks
nshively
How to set filter with scheduled reporting
I have a master domo card that has information pertaining to every single employee. I want to set up an automated schedule report that gets sent to each employee on a daily basis. How do I set the scheduled report so that when an employee receive it the filter is already applied? I do not want to create a seperate card for every single empoloyee. some of the employees are social users.