-
Removing Future Dates in ETL
Hello, I have data that has start dates in the future, that I want to remove. I can do so using a Beast Mode filter; CASE WHEN StartDate > NOW() THEN 1 ELSE 0 END. I would prefer using a filter in ETL. I am trying the below but doesn't seem to work. What am I doing wrong?
-
Dataset Archiving
We would like to be able to see whether a dataset is archived or not within domostats datasets, and we would like the option to 1) manually set a dataset into archived state, or 2) prevent a dataset from going into archived state.
-
Deploying Snowflake - MagicETL as a MySQL export?
Hi Community, We're deploying Snowflake at our company. A part of this will be moving MagicETLs from Domo to Snowflake SQL transformations. Is there a way to export a Magic ETL dataflow and the underlying logic as a MySQL query?
-
Incorrect total when the field used is a beast mode using a case statement
I have the below beast mode that is created using fields that are all fixed by their various dimensions. `Expected Cost` CASE WHEN SUM(Revised Estimate (fixed by Estimate)) = 0 AND SUM(Cost to Date (fixed by GL)) <> 0 THEN SUM(Cost to Date (fixed by GL)) WHEN SUM(Cost to Date (fixed by GL)) > SUM(Revised Estimate (fixed by…
-
How to periodically REPLACE in addition to APPEND jobs?
I have a VERY large dataset that I've uploaded to Domo. I initially did a REPLACE to load the whole dataset. I then changed the workbench job to APPEND and use an 'update date' in the table to run HOURLY while checking back the past couple days for any new/missed data. Due to some bugs on our side, sometimes very old data…
-
Multiple Sync Schedules
It would be great if we could add multiple schedules for any dataset or Magic ETL. For example, being able to run a dataset every 30 minutes on Monday from 8am-11am, and then running one per day the rest of the week. Advanced scheduling doesn't allow for different times or different active hours on different days.
-
Prompts and User Input Workarounds
Curious to know how others are handling the lack of prompts? I know filters are often mentioned but that doesn't help when a different set of data needs to be pulled or a calculation is dependent upon a user input. This is creating some friction with end users. The web form is not a user friendly work around.
-
Run Specific Outputs vs All
I would love to see an option when you click run on a MagicETL that there would be a drop down where I can choose to run all the outputs or only specific outputs. This would be an absolute game changer for credit usage and consumption model management. Some of our ETLs have 10 outputs and we are making a small change to…
-
What is controlling the expand background in App Studio?
I recently noticed that when expanding a card in App Studio the background has a color. However, it is a dark color with black lettering. I have tried looking for something in the theme color settings and couldn't find anything for the expanded section. What is controlling that color? I would like to make this color lighter
-
Form pop up button filter interactions
I see that app studio has a button that enables to open a form in a pop up. I have a drop down that filters my dashboard, I have a form on my dashboard that contains a drop down, my selected value from drop down is filtered on the form field ( drop down) as well. I like this filtering, However , when I enable the form to…
-
Is there a native way to review and approve form submissions in a table format?
We’re building a workflow that starts with a form submission (e.g. "Add New Person"). We’d like an admin to later review submitted records in a table view where they can approve, request edits, or mark for follow-up — ideally updating a status field directly from that table. We’re currently exploring Domo Workflows, Forms,…
-
standard drill down for dataset
I have many use cases that for a specific dataset I create visuals and end up making the same drill-down for each visual. It would be nice to be able to create a standard drill down per dataset that syncs to all the visuals to that dataset.
-
PDP policies not working for a user
I am currently testing PDP policies for a dataset and dashboard using a column filter. I have used this feature before. While creating the PDP policies, I initially assigned them to a test user by default. I then removed the test user from all policies and assigned them to just one. However, when I tested my dashboard, I…
-
Default Filters at Domo App
Hi Everyone, I’m trying to set up default filters in a Domo App, but I don’t see an option to do this at the app level. I know it works on dashboard pages using Filter Views, but I’m not sure how (or if) it can be done across the whole app. Has anyone figured out a way to apply default filters in a Domo App? Would love to…
-
Dynamically retrieve dashboard where card is saved
Hello, Is there a way of dynamically retrieving the dashboard which a particular card is saved? So if I create a beast mode upon a DataSet which powers a card, how can I then retrieve the dashboard ID?
-
Request: New Shape for Shape Gauge
Context: I'm making an App in Domo that will (hopefully) drive more sustainable actions within my organization. I've just finished creating a Workflow that sends invoices via email - a process that was previously done by mail. So we are saving lots of paper each month now. Yay! Ask: I want to show the saved paper on an app…
-
New Domo Office Add-In – Dataset Import Filtering, Preview, and Row Count Enhancements
Our Finance team relies heavily on the New Domo Office Excel Add-In when using the Dataset Import function to pull large datasets from Domo. The add-in works well for basic imports, but there are critical gaps that limit efficiency and accuracy for financial workflows: No indication of how many rows will be imported once…
-
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…
-
Control Font Size Options
For customization, our team ran into a use case where the font size of the body of a control in an app was needed. Things like the size of a textbox input or of radio buttons. Some of our clients and internal users reported difficulty reading controls because the font size was too small.
-
How can I get null/empty string fields to appear as zeros in my ETL?
Hi all, I am running into an issue where I am trying to convert null/empty string fields to zeros. I have tried multiple different methods with no luck. The fields continue to appear blank. I need zeros so I can use them in Beastmode calculations and conditional formatting. For context, this ETL is used to show quantity on…
-
Enable Joins in Views on published datasets
The Problem My company publishes datasets to all subscribers on Domo Everywhere. Customers often need to manipulate these datasets (filtering, renaming, adding columns), which works fine in Dataset Views. They also frequently need to join datasets. While Views can handle joins for materialized datasets, joins on the…
-
Hide features users don't have permissions for
A recurring issue I have in Domo is that users can see and access pages for features they don't have permission to do anything with. For example, a user with no permissions for the mobile app can still see and click into Mobile in the admin menu; they just can't make any changes. This comes up over and over: Users with no…
-
Digital Chatter Challenge Winners 🎉
Thank you to everyone that participated in the Digital Chatter Challenge! Here are the top five winners and prizes: 🥇1st place: @DashboardDude (83 points), Domopalooza pass and $1000 Amazon gift card 🥈2nd place: @KM_Eccles (61 points), $500 gift card 🥉3rd place: @GrantSmith (54 points), $500 gift card 🏅4th place: @NRT (27…
-
Exporting data into formatted report?
Hello, Currently I've created a number of tables cards in my dashboards that my users like to export into excel, the issue is that the formatting of the exported file isn't great and my users aren't happy with how limited the export is. Is there a way I can create export options through the dashboards or Apps that format…
-
Google Analytics Not Matching
The data i'm seeing in Domo is not matching with the data in Google Analytics. I'm using the Google Analytics 4 connector and have the following metrics and dimensions: Metrics: - Conversions - Engagement rate - Sessions Dimensions: - Page path + query string - Page referrer - Date - Session default channel group - 4…
-
Forcing Alerts on Users?
Hi gang! Fairly new to alerts. We've been testing a few things with some cards using the Card Options > Alert Me option. I haven't seen any way to achieve what we're looking for though, so wondering if anyone could tell me if this is possible: On a resource planning dashboard, we have a card that shows what % of a…
-
SharePoint list and lookup value field
Hello, Is there any way to overcome/ workaround to get DOMO to return the lookup value (and not ID) when ingesting a SharePoint list with lookup value fields? I have tried creating a new field with JSON formatting (which exports as blanks although displays correctly in the SharePoint) and can't seem to get the lookup value…
-
Beast Mode Folders
Hi, It's been more than a year since this post (https://community-forums.domo.com/main/discussion/66358/navigation-q-a-from-domopalooza?utm_source=community-search&utm_medium=organic-search&utm_term=beast+mode+folder ), I'd like to check if the folder functionality for beasts mode has been implemented. At my organisation,…
-
beast mode below works but is erratic
((SUM(CASE WHEN Disconnects IS NULL THEN 0 ELSE Disconnects END)) / (SUM(SUM(CASE WHEN ServiceStatusValue IS NULL THEN 0 ELSE ServiceStatusValue END)) OVER (ORDER BY BillingPeriod) + SUM(CASE WHEN Unique Count ServiceID IS NULL THEN 0 ELSE Unique Count ServiceID END))) * -1
-
News on the New Semantic Layer/Model feature
Does anyone know when are we receiving the new Semantic Layer/Model feature for our Data Model in DOMO? We have been working on building our data model here but without a Semantic Layer, like the one in PowerBI, would make us double the data for lots of columns, since we can't centralize the parameters of our model in…