-
Dynamic CAGR formula?
I know how to do a basic CAGR formula between two static years: power((sum(CASE WHEN Fiscal Year = 2024 THEN Amount else 0 end) / sum(case when Fiscal Year = 2020 then Amount end)), 1 / 4) -1 Is there a way to construct a CAGR calculation that responds to user filtering or changing the timeframe? I am trying to think of a…
-
Gradient colors needs a midpoint setting
The recent gradient color addition to Analyzer has the potential to eliminate the need for setting up a bunch of color rules for variance colors, but it needs the ability to set a midpoint value like the heatmap color setting on table cards. Currently the gradient colors are relative to the bars displayed on a chart…
-
Table card column borders and padding/empty columns for visual enhancement
In excel, financial statements and schedules often include empty columns to visually separate or group together columns showing different metrics. It would be great if Domo had the ability to insert padded columns in the same way. Currently when you have a table card that displays multiple metrics and variances, it all…
-
Regex formula works in ETL preview but doesn't show up in dataset output?
I'm using the Dataset from Email connector to push a weekly email into Domo. The body of the email contains an account balance, which I'm trying to extract into a new field. The body of the email will always contain "Amount: USD 123,456.00" I created a regex to match what comes after the "USD " and before the next…
-
JSON Connector that allows for entire dynamically constructed url?
I am trying to use the JSON No Code connector to dynamically pull data from another website. I've used this for other purposes successfully, but am running into an issue with the way the Domo connector inserts a "/" or "?=" in the url under the dynamic url and dynamic parameters settings. If I use the static url option, it…
-
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…
