-
Using Regex in ETL to check if a string ONLY contains digits?
I found that using the expression REGEXP_LIKE(field,'^[0-9]') will check if a string contains any digits. What I'm struggling to figure out is how to flag whether it ONLY contains digits and no other characters.
-
How can I create an alert for when a new transaction of a certain amount enters the dataset?
I've only used alerts to notify when the total sum of a dataset field changes. Is there a way to setup an alert to send when a new record appears in the data that meets a criteria? For example, when a new order > $100K appears in the dataset.
-
Trying to create vertical bar chart that shows Count of Jobs based on Hours of each Job?
Hello, I am trying to create a distribution that shows the count of transactions ("jobs") grouped into buckets of hours. I thought using a window function to partition the hours buckets by Job (X-axis) and then doing a count(distinct) of jobs as the Y-axis would work, but it's not grouping correctly. When I set the Hours…
-
Trying to calculate turnover % using window functions in beast mode - total row issue
Hello all, I am trying to calculate a monthly turnover % where the numerator is the count of terminations in the prior 12 months and the denominator is the average headcount over the last 12 months. If I create two separate beast modes for both parts of it, the output including the total row works correctly. However, when…
-
Magic ETL Append Tile - show full list of columns added to each input
In the Append tile, it shows you the count of how many columns will be added to each input (columns present in other input(s) that aren't in that one input). When you hover over the number, it lists the first 20 columns. It would be nice if it would display the entire list of columns and not just the top 20. When combining…
-
Option to delay sending new user invitation email to allow admin to finish user setup
When we set up a new Domo user, it immediately sends them an email invite to set their password and login. At the same time, after creating the user we have to add them to the appropriate group(s) for page access, and configure their PDP rules and run the custom script to apply PDP to their account. This process takes 5-10…
-
Ability to sort Webforms in edit mode and save sorting
When you view a Domo webform on the data tab, you can sort each column just like any other dataset. It would be nice if you could sort the columns in edit/input mode and save it that way. We use Webforms for several rosters and when adding new rows to the bottom of the table, it would be nice to then sort the updated table…
-
How to change the date range for a card in the Android app?
In the iOS app in the full screen view of a card there's a button underneath the card title to change the date range, but the Android app doesn't seem to have this. One of our users on an android phone somehow changed the date range to "all time" but can't seem to reset it. Is there another way to reset it to the default…