-
Sub-Category of a Category?
Hi All, We are working on a report that has a few different program_namesthat are summed up in a pie chart using orig_loan_amount. I have been tasked with trying to sub categorize our bonds using a taxable/tax-exempt designation The problem I am trying to overcome is that our bonds (identified by pool_name) are actually…
-
Logic - link original submit date to all subsequent back orders
Hello. I'm wondering if anyone has ever had a similar scenario/concept and have come up with good ways to achieve the desired outcome. I've attached a screen shot of real data. The goal is to get the submitted date of 7/5/2024 (A6) linked to orders in rows 7 and 8. The story of this data is that order id 16403748 was…
-
How to Use Partitioning to Retain Data in a Monthly Rolling Window Dataset
Hi Domo Community, I’m currently working with a dataset (via MongoDB Connector) that operates on a 12-month rolling window, where data older than 12 months is deleted on the 1st of each month. Long story short, I cannot change this configuration. But, I would like to retain some of this older data using partitioning before…
-
Extract the string values in between stroke and question mark in a URL
Hi Domo, I am looking for a way to extract the string values in between stroke and question mark in a URL Example URL: https://dam-bc.com/content/67-making-AI-trustable.pdf?_gl=1*ckt29z I want to extract this part of URL: "67-making-AI-trustable.pdf" Ideally if I can do that with a beast mode formula would be great. But if…
-
COLUMN NAME CHANGE - PUSH TO BEASTMODES / BEASTMODE SEARCH AND REPLACE
I think a good option would be that if a column name is changed in the Column select tile that if that old column is being used in beastmodes that we can push that change to all affected beastmodes. When managing 100's or thousands of beastmodes it makes it difficult to go back and correct if we have to change a column…
-
Selecting prefix for conflicting field names
When joining datasets, Domo alerts you to any conflicts in the naming. Specifically, any common field names have to be renamed. It defaults to using the name of the originating dataset as a prefix. We use longish, descriptive dataset names, and the narrow, static width of the editing line makes renaming very tedious. Is…
-
Templated ETLs
I would love to be able to create an ETL and save that to use in other flows. A "save as template" button would be amazing. It would only save the tiles, not the columns, so you wouldn't have to delete everything before you start. We use recursive dataflows a lot, so it would be amazing if I could save that flow, and then…
-
MagicETL Recipes
We all have ETLs where we use common logic over and over again. I propose an idea to enhance MagicETL with something called 'Recipes'. A user could create a new recipe within Magic, add a series of tiles into it that do some common logical steps and save it with a given name (e.g.. 'Strip Whitespace and Split String'. Once…
-
How to create YTD, LYTD, LYLW, etc columns from a FISCAL CALENDAR
I have a dataset that has sales per item going by each week (yyyyww) for the last three years, only I can't use things like YEAR(CURDATE()) or YEARWEEK(CURDATE()) because the yearweek we're getting from the dataset is based on a fiscal calendar (Ex: The first full week of august is the first week of the year, so July 29,…
-
Company Turnover %
I am trying to calculate the company turn over %. We are pulling data from Salesforce into Domo. We have a custom object that lists all employees. These employee have an active/inactive status and a termination date. I am trying to figure out a way to calculate the total ACTIVE by INACTIVE YTD based on that term date.…
-
Pivoting into multiple columns
My dataset has a Month column. I want to pivot the data so that the months become the columns (so a column for June 2024, a column for July 2024, etc). Using the Magic ETL pivot tile it seems I'd have to perform the pivot for each month separately. Before I go down that route, does anyone know an easier way to do this?…
-
Magic ETL Join Tile
Apologies if this has been requested in the past. I would like a case insensitivity checkbox on the join tile. In the example below, I have created two datasets. In dataset2, I have a list of words in varying cases: lower, upper, and proper. If I join the datasets, I get different results based whether the words in…
-
Pivoting multiple columns with the same column values as its values
I have a scenario where I have rows from multiple columns that I want to pivot into a multiple columns. Let's say I have three columns: 'Questions,' 'Labels,' and 'Values.' I tried pivoting the 'Questions' column into separate columns with values from the 'Values' column. Now, I also want to pivot the 'Labels' column into…
-
Changing the input datasource to multiple ETLs at once
I have a table that powers multiple ETLs and I want to change this table in all the ETLs to another table without changing it individually in each ETL. Is there a way I can do this or view what ETLs are powered via Domostats ( I know I can check this in the Lineage tab) but I want it in a table so that I can analyze the…
-
Annotate part of an ETL dataflow
Is there a way to annotate part of an ETL dataflow like the following
-
How to get Gross Sales from Shopify?
My team and I are in the process of building datasets from Shopify's API but we are not able to get the gross sales amount to match with the gross sales amount in the Shopify's dashboard. Does anyone have any insights on this? We selected the report "All Orders". We have played with all columns, total_price,…
-
Where is my data going??
My data seems to be disappearing between the ETL and the final data that it actually outputs. Here are some pictures to try to explain what's happening. The first image shows the preview on the final tile in the workflow (being the output file titled Work Numbers (Final)). The second image shows the same chunk of data,…
-
Dynamic Pivot
I have a table with a combination of fields and a target value. I want to concat all the fields (Retailer, Field, Target, Strategic Priority) and pivot the table so they are all columns with their respective Target Value underneath. I know how to do this with the Pivot option in which I manually create a new column for…
-
Form Builder and Form Viewer Transformation
I am trying to use submissions we get from forms in DOMO via form viewer/builder apps and turn them into usable datasets that we can create cards with. Right now the form submission data puts the label in one column and the value in another and I would like to make it where the data looks like this: Date: | Model: |…
-
Optimizing Magic ETL with Mini ETL grouping windows to expand within complex ETL.
When Magic ETL becomes complicated, should we have a feature that suggests and organizes features into mini ETLs for the data sources? These mini ETLs could then expand into a larger window within the main ETL. This would allow us to minimize it later and continue the process without needing to create multiple output ETLs…
-
DomoGPT...?
Hi, can someone explain how to access DomoGPT chat box?
-
Magic ETL Join Tile Alterations Field Search
We have really appreciated all the quality-of-life updates to Magic ETL over the past few months! I have a few ideas to improve a pain point we frequently encounter when building ETL's. Some of our standard schema is verbose and requires field name prefixes when ingesting from certain systems. When we attempt to alter…
-
Get latest data from Ingestion in ETL grouped by month.
I have ingested a data which is regarding the Employee HC. Its per month. I have uploaded first 6 months of data in my ingestion dataset. In my dataset, I have used the append method to update. I have to prepare an ETL to power a new dataset. The dataset is supposed to have data for all months of all clients. The ingestion…
-
Magic ETL Organization Tools
Thinking it would be great if Domo implemented some organizational tools within the Magic ETL. We've got some rather large ETL's, that get quite complex, and organizational tools (organizing tiles into buckets, with ability to minimize bucket, add descriptions to bucket, etc.) would help my team and company scale. Having…
-
Rank
I noticed there is a difference between ordering using Rank format on a card, and using the Rank tile in a dataflow. If you use Show value as 'Ranks small to large', whenever there is a tie, the following ranked item will remain incremented by one. But when using the Rank tile, after a tie, the consecutive numbers are…
-
ETL not joining despite matching columns
I am trying to join an ETL, but for the life of me cannot get the join to work. I have double and triple checked that the columns are formatted the same, trimmed on both sides just in case, etc and Magic ETL still won't recognize that the data matches. What should I do?
-
PRODUCT RELEASE SNEAK: DataFlow Sharing Modal
As an active Community member perk, we will be providing insider sneak peeks for the Dataflow Sharing Modal features we will be releasing on Monday July 22nd 🥳 Historically, when users wanted to share a DataFlow with another user or group, it was often difficult, time consuming and frustrating as you often run into…
-
Save and Run vs Save As
Bad idea to change the Save options in the ETL. I've been shooting down to the bottom option "Save and Run" for years. I've already duplicated multiple datasets working fast, have to back track, delete the duplicates, and update the actual ETL.
-
Snap to Grid functionality in Magic ETL
Aligning the tiles in magic ETL can become quite cumbersome without any grid or guides for the tiles to line up with. It would be great for the default behavior of tiles to snap to a grid or show guide-lines that signify when tiles are aligned.
-
Solved ETL - Replace Null Values
Hi, I have a dataset with null values and text and I am trying to replace them with 0 and 1 respectively. But, when I try to write a formula using the conditions 'If Null' or 'If not null' I keep getting errors. Does anyone have any ideas? Thanks! Edit: I figured out what I was doing wrong.