-
MTD and YTD TOGGLE
HI Team, I have a date field and what I'm trying to do is write a beastmode that looks at YTD and MTD without years. I have successfully done that in 2 separate beastmodes to give my a 'Y' or 'N' toggle. However when I try to combine them into one where the user can toggle 'YTD' or 'MTD' the 'MTD' isn't the issue.. it's my…
-
Analyzer Double Click to Add Dimensions/Measures
When creating a card in analyzer, it would be useful where if you double click the dimension/measure in the left-hand list it would automatically be added to the next open column space. For example, when I'm creating a mega table and need to add in tons of columns, I could just double click down the list and add them much…
-
Cannot use Domo to create cards because field edit (pencil or drop down) does not work
Cannot use Domo to create cards because field edit (pencil or drop down) does not work. Same issue using Chrome or Edge. Still cannot navigate to multiple screens using taskbar thumbnails (I can navigate using ALT+TAB). Chrome pages take long to load. Seems like page gets stuck but loads if I click on URL bar. The 2 last…
-
Connect Intercom Surveys data to Domo
I'm trying to get a data connection set up with Intercom and Domo to retrieve data on Surveys we're setting up in Intercom. The "Surveys" aren't available via the out of the box Intercom connector, so I believe we'll need to connect via JSON, Webhook, or other. What would be the best way to do this? they've given us two…
-
CTRL + Z undo in Magic ETL
Love the new undo/redo in Magic! Would love to have undo/redo keyboard shortcuts.
-
Magic ETL - 'REM' out work streams or individual Block from production
An ETL can have several workstreams. We may have a workstream we do not want to remove, but do not want running anymore. Today this is a challenge solved with copy or versioning, but what if you could 'REM' out a workstream or block. Example: I have a temporary filter I set or testing. Hate adding and deleting every single…
-
Magic ETL - Selectable Preview OR EXCLUDE from Preview
The ability to select specific blocks to run as a preview. Case: In an ETL we have several workstreams and outputs. I want to be able to select a specific area to exclude or include from a preview. Considerations: Will always need to have the source data to preview, but select a path to only preview.
-
Request Access Button
If there is a way to update the "request access button" (see attached screenshot) to do any/all of the following:- -display the client internal support email in a text box -redirect to clients internal support email Currently when a user hits this button, the card owner gets a domo BUZZ message. Client could better track…
-
Replicating multiple Excel Calculations as rows of data - Beast Mode?
Hello, I've got multiple datasets (actually customers) that we calculate a few things with separately. I was able to get all of the datasets (customers) combined so they could all be on one table: Typically what I do in excel is from those numbers I'll pull a few different things out: I'd like to basically mimic these…
-
Domo Everywhere - Public vs Private (Access and Confidential)
Would setting the embedded card to PUBLIC provide access to users outside of the company? I have an embedded card on a SharePoint site that is set to PRIVATE and is only for internal use. However, not all users have DOMO licenses and just need to view the data visualization. I don't want to compromise the security of the…
-
How to edit Data Assembler jobs
hello, How can I edit a data assembler job in domo? For example if I want to change the setting or create a new one?
-
Adding and Removing Users from Datasets in Workflows
I'm trying to change the the dataset owners of a list of datasets from their original owner to a single output owner. I have all the inputs on a flat file but and will use the loop over template but need help on the function to add dataset owners itself. Do i create a dataset variable off of the dataset name or the dataset…
-
Overage Execution Rows Protections
Just had a user accidentally do a join that we identified 7 hrs after the process started that was up to 72 billion rows. It was going to top out over 300 billion, but we hit cancel. However, that overflow credit usage topped out over 3,000 credits, which is not the kind of mistake you'd like your team to be making. So,…
-
Combining Filtered Rows to one table
Hello, I am using one dataset for all three cards shown below. I have them on separate cards right now as they each are filtered to different things. Is there a way I can combine them so they would all show on one card/table together with one heading but show the three rows one under another with their filters still…
-
MapBox - No Background
I'm in well over my head but here goes nothing… In my first attempt at using Bricks, I downloaded the MapBox Donut Cluster Bricks. I got it connected to my MapBox account and have a dataset with quantities for each Lat/Long value. However, there is no "backdrop" for the chart: It's working in that the donuts each have…
-
Conditional Gateway Tile
Greetings, I would like to propose the addition of a tile that enables early termination of a dataflow without writing to the output dataset when specific conditions are met. A key use case for this feature would be terminating the dataflow if the input dataset contains zero rows. In such cases, the process should end, and…
-
Blend/Fusion Removed?
Hi, does anyone know if Blend/Fusion features were recently removed? We have processes using them and we cant we find data fusion/blend in any of the transform menu options? We also have MagicETLs that take those fusions as inputs to materialize them in some instances and we're presented with an error on the inputs saying…
-
Drilling from Table Card
One of the most common questions I answer from Domo users is why a drill doesn't work as expected on a table card depending on where the user clicks. For example, a user would look at the table below and click "200" to drill to transaction detail for Customer B. Instead, they receive an error message saying "An issue has…
-
Calculating YTD for each week in table
Hi, I want to replicate a table that looks like this: My dataset currently has date, impressions, and goal, and in ETL I've mapped the dates to a week by joining with another table. How would I use beast mode to find the impressions to date for each week, as well as the delivery percentage of goal?
-
How do you add lines to a pivot table?
I am sure this is easy, but how do I get lines in my pivot table? I believe it has to do with duplicate fields, such as the dates. But is there a way?
-
Previous Month Last Year value Formula
Hi Everyone I'm trying to calculate a sum of values for the previous month for the previous year (February 2024 in this case) so that I can compare the difference to previous month for this year I've made a few attempts but have had no success What is the best way to do this calculation for last year previous month? Thanks…
-
How to Find # Customers with X Miles
Hi Team, I'm hoping to find the number of customers within a given radius of a given business location. For example, how can I find how many of our customers are within 50 miles? What about within 100 miles? In order to capture ##% of our customers, how many miles do we need to travel? These are the types of questions I'm…
-
How do I initialize DDX Form Brick with Existing Dataset and then sync it to an AppDB collection
I was tinkering with the DDX Form and Dataset Brick and I want it where the table initializes with an existing dataset using domo.get(`/data/v1/${datasets[0]}`); and have it update into the new/existing app collection that is syncing to the brick, domo.get(`/domo/datastores/v1/collections/${collectionName}/documents`). For…
-
Extended DataSet information on DOMOStats
Can we get DOMOStats to include some of the additional information available on cards like in the API or CLI? While DOMOStats is great, there are some key funcionalities it lacks that are already available through the API and CLI and that would be a huge help when it comes to managing the instance. Some of the top of mind…
-
How can I set up a text box Variable that can search for a text string in a field?
Hi Domo Community, Like the title says, I'd like to set up a Variable to be used in a dashboard where users can input text and it will search for the text string in related reports and return the results. For example, I have a "Description" field for items. I'd like to search "6mm bolt" in the Variable/text box and have it…
-
Alerts in SPC charts
Good morning, Not so long ago, for the SPC charts there were alerts that trigger when the control chart rules were met I am not able to find that feature anymore when setting up the alert
-
Why would a dataset that comes in daily sometimes change the date format?
I have had this data set come in daily now for 6 months or more, and now for the second time in 1 month the data is wrong, and it seems to be an issue with the date format. Any reason why the date format would change? The correct format is 2025-03-24, but yesterday some of the dates formatted to 3/25/2025, therefore…
-
Dynamic Positional Inventory
Hi, I am looking to create a pivot table that is able to handle positional inventory dynamically. For example, if I have 3 weeks in my filtered range, I want to only show the data on the last week. I am using the below. CASE WHEN Week ending date = MAX(Week ending date) OVER () THEN SUM(ifnull(EOH Qty,0)) ELSE 0 END This…
-
REGEX Tutorial to Validate US Phone Numbers
Hi everyone, I wanted to create this discussion post to share a methodology I created using Domo's Regular Expressions in Magic ETL to parse and validate US phone numbers. This validation process follows the basic standards set by the North American Numbering Plan (NANP) and helps identify valid US phone numbers from a…
-
How to Modify PDF output?
I want to give customers a pdf of their dashboard - but I don't want that first page that comes up attached - basically a "first page" saying my company and theirs. The reason is that the end customer is my customer's customer. I don't want any front page on the report all at. Is there any way to format pdf outputs?