-
Multiple targets on Radial Fill Gauge
A great feature would be the ability to have multiple targets with labelling on radial fill gauges. Whilst there are a number of other ways to visualise this, the radial fill gauges can be popular, and having the ability to have multiple targets would enable consistent styling when radial gauges are being used. A…
-
NetSuite Connector
Due to privacy I cannot share any records, nor can I simulate it. This is going to take familiarity with the NetSuite connectors to answer. This connector does not work like other APIs. We have tried two of the NetSuite connectors recommended to us by Domo. When we validate the information we find a couple records missing…
-
Sharepoint Connector - Error rectifying Excel File
Hi. We have a sharepoint Excel file that we bring into Domo via the sharepoint connector. Today I got an error I've never seen before and couldn't find anything on Google about. "Error rectifying Excel file. Please try again later." I double checked that the file has not moved or changed names or tab names and that the…
-
Troubleshoot: Domo is ready, but an email was received that did not contain the specified file type
Domo is ready, but an email was received that did not contain the specified file type. Ensure the File Location and File Type settings are correct then try again. I am getting the above error message for a dataset that is coming into Domo via Email attachment. Here are the settings: skip empty rows is also unchecked at the…
-
Has anyone used the new feature that sends scheduled reports when an alert triggers?
In the highlighted features for May 2024, the ability to send scheduled reports when an alert triggers was created. Based off the information here looks like it should be available under the alert menu - however, below is what im seeing. Is this a feature that needs to be enabled by a CSM?
-
Beast mode calculation: Last compared to past average?
Hi - I'm trying to figure out the calculation to identify an action needed. I know how to do in Excel, but still learning the SQL / Beast Mode equivalent. I have a count of total items. If the count of total items from last week is 20% less than the average count of total items from the past 6 weeks, I want it to be marked…
-
creating a field for sum of annual premium?
-
Using beast mode to compare strings
Hi, I am trying to compare the values of 2 fields using a CASE WHEN statement. "field1" contains an email address e.g. "bob@test.com" "field2" may contain a name and email, e.g. "Bob Smith, bob@test.com" The outcome I would like from my beast mode is to check if the value in field1 is contained within the value of field2.…
-
String Operations
Hi all, I have a column that either has 7 or 8 digits in it. I need it to have exactly 10 everytime I am working in magic ETL and am wondering how I can create logic to see if the column has 7 or 8 then add 2 or 3 leading 0s to the column depending on which case is true. Any suggestions?
-
Get timestamp from workflow step
Hi, I need to get (or calculate) timestamp from a workflow step to insert it later on a dataset as a column value. Right now I'm invoking a dataflow with a SQL function but I think that have to be a better way. Thanks in advance.
-
Division By Zero - Be Aware - Failed IFERROR, IFNULL, and GROUPBY
When you're performing calculations over 100s of millions or records sometimes you come across division by zeros in which you're hoping the software you're using would manage accordingly, I ran into a scenario in an ETL scenario where it lead to having more than a 10% revenue shortfall in my numbers. Generally in Domo if…
-
Multiple Level of Detail Tables From One Dataset
Hello, I have a product data set that has product sales with fields for store and city. From this data set, I want to create three tables at each level of the hierarchy, product, store, and city. The only way I can think of doing this is by creating a bunch of aggregate beastmode calculations for each field. For example,…
-
Setting up specific Alerts
Hi all, My company is working with a webform. Two different departments are responsible for filling out two different pieces of the webform to make it complete. Department A has to go first. I do not want to set up an alert that everyone gets each time the dataset updates. I do want to set up an alert when column A has…
-
Does Beast Mode support using "Contains" to Identify Value Count
Hey there… I have a field called PresentationName where we (unfortunately) use a text string as part of the PresentationName to identify a Type of presentation. Clearly we need to pull that out into its own metadata and will in the future. But for now, I need to find a way to create a calculated field that lets me get a…
-
Data sharing rules
Once data is shared to a group, we currently have the situation where users in that group can share data to individuals. Thereby 'breaking' the concept of having the group. We need a way to stop that from being able to happen. I know current way of working is standard DOMO, but for us (particularly in relation to any…
-
AppStudio - Import Page to Tabs
It would be super great to be able to import a page to a tab, will that become possible at some point?
-
App Studio: Ability to remove filter icons from cards
Same functionality that exists in classic dashboard cards. These icons obscure the view of the card by putting a small blue 'filter' icon over the bottom left of the card when a filter is selected.
-
Custom date range in a App Control
Hello, I'm working on a App with multiple cards, all with the same date column in the data. I would like to take the custom date range that's available in the filter options: And add this to a Control at the top of the App: Thegoal being the users can filter all the cards by any date range they want. I figured out how to…
-
Continue with Workflow execution after form assignment
Hi, I'ts there a way that a workflow execution can continue with next step after assign a form? For example, if I need to assign a form to 10 persons, the workflow assings the first one and wait until complets (form submit) to continue with the assignment to the rest of the users in the list. Thanks in advance.
-
Facebook Advanced Ads Connector - Add back Id Columns
Add Ad Id, Ad Set Id, Campaign Id metrics back into the Object Insights - New report. Previously you were able to pull these values as their own columns so you could report out on Facebook performance down to the Ad Id level. You can still select the "Object" (Ad, Ad Set, Campaign, etc) breakdown level for Domo to gather…
-
Facebook Ads Advanced Connector
Hello Everyone, In Facebook Ads Manager there is column called Website Conversions. I am trying to find this column in the Facebook Ads Advanced Connector. I did a custom insights for report and did try to search for it. Can you please help which column should I choose in the connector? Thanks
-
Rolling Averages Feature
I was looking for a more flexible way to create rolling averages. Of course possible in a Domo Dataflow/Magic ETL → but then you need to fix it on the periods you want to "roll over". Is it possible in a beast mode or is there maybe a card type/feature that makes it even easier?
-
Deleted the parent Page and the child dashboard got deleted. Is there a way to reverse/restore it?
-
Webform in App Studio
Anyone successfully embed a editable webform into an App Studio app? I'm totally lost and feel like I'm going in circles.
-
Filtering inside a DDX Brick
Hi, I am currently trying to filter on the date inside my DDX brick to only give me the current month data. The date Column I am using to filter is called Fiscal Months. How would I do that? Im assuming it has to do with the way im querying the dataset. I attached my JS below. One thing to Note is that date column is…
-
Card rendering problems in Chrome
Hi, Is anyone experiencing rendering problems in domo when returning to a domo tab in Google Chrome latest version after leaving it idle for a while? We are having issues where the cards are empty and only render when you hover the mouse over them, Some still don't show correctly even after that.
-
access page embed applied filters in brick to pre-select filters
Hi, We have an invisible brick inside a page embed. It's only job so far is to notify the host through a postMessage when a filter has been applied ( using domo.onFiltersUpdate() ). The host then listens for this postMessage and stores the chosen filters in session storage. This is all working well. When the modal is…
-
Beast mode referencing
Hello, I wonder why this won't work. I get that the CASE WHEN can't have MAX() within it, but I thought by referencing the beast mode that uses the MAX() would process it as a subquery that references the output value instead of the formula MAX(). If this wouldn't work, is there an alternative to this? I needed the…
-
How can I add a new date column to an existing data set?
I bring a sales data set weekly, and started this about 6 weeks ago. This week my file had a new date column, but the new date column is not visible when I want to add to a card on my dashboard. I am assuming it is due to the past files not having this column. Anything I can do besides re-adding all the past files with the…
-
FIXED BY referenced in another beast mode
Hello everyone, I am trying to reference a beast mode (streak) to another (streak_breaker) that's using a FIXED (BY) function, but it keeps on returning an error. Is this not feasible? Here's my example data and calculations: streak_breaker = MAX(MAX(CASE WHEN status = 'draft' THEN campaign_idEND) FIXED (BY account_id)) »…