-
Forms should allow for filtering the dataset powering the questions
When using a dataset to define the choices in a form question, we should have the ability to apply filters. Otherwise, the wide-open dataset will include far more choices than necessary. For example, if I create a form for approving sales commissions and select the sales transactions dataset, the dropdown will include…
-
Does PDP Automation not work for Dynamic PDP using non-system attributes?
I setup a new Managed attribute called "Region". If I assign a user a value for this attribute and manually create a PDP policy for it, it works as expected. I setup an input dataset to run the PDP Automation on, and while it creates a policy, the user cannot see anything. The policy also looks different. Instead of…
-
Pivot Table - add ability to group columns by values and then dates
In an excel pivot table that includes multiple value fields with a date field as the columns, you can move the "values" field above the "Date" cell in the columns section to group the columns first by metric, and then by date. In Domo, adding two metrics to the "values" section only allows for plotting by date with each…
-
Magic ETL Dataflow Schedule: add trigger for Dataset has not updated
The Dataflow schedule has a setting to trigger when input datasets have updated. It would be helpful if there was a way to schedule it run at a certain time if an input has not updated. There are occasionally issues with Workbench that cause input datasets to not run, but in some cases we have recursive dataflows…
-
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…
