-
Question about using recursive reports but only reclusive until post month
I am working on setting up some recursive data structures to capture the data I need for this instance it charges in a period. We can call this resident's charges. Charges are accumulated until a post date which is most of the time the 21's day of the month with some exceptions. I have a small web form that lists these…
-
Dataflow loads in preview, but not in actual dataset?
Any troubleshooting tips for us? Our data flow's outputs: Work when we run a preview When we run it, the datasets give us an "Unable to load this DataSet" error. (The second dataset is my "test" output where I kept moving it around the flow, trying to identify if a specific part of the dataflow was breaking the final…
-
json data
We have a no SQL database, where our data is stored in Json format. Which is nested and has further nesting based on one to many relationships. We need to have a particular tabular form or method to map this dynamically changing data into domo
-
List of Months between two dates
Hi All, I am trying to create a Magic ETL V2.0 that lists the name of the months in between a hire and termination date for employees. I want to create a bar chart of number of employees who are active and terminated within a given months time. i.e. Hired: 5/1/2022 and Terminated: 8/31/2022. Months active = May 2022, June…
-
Removing Duplicates with Condition
Hi All. My dataset have a lot of duplicate rows so I wanted to use "Remove Duplicates" in ETL based on the Shipment ID. However, there are some products that are hazardous. I want to have the hazardous row left remaining when I remove the duplicates if there is a mix of Haz and non-Haz. Any function or use of "Rank &…
-
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…
-
Lead Function in Rank and Window Returning Self Referencing Value
For some reason I am getting a self referencing value rather than a NULL. In this example, I was expecting the Next Row Column to be NULL for the last row. Instead, it seems to be self referencing the student enrollment # column. The first 5 rows in the example are correct. Is this the default behavior of this…
-
Automatic Record Matching - Customers
Howdy! New Domo customer here - first time posting in the Dojo! We're bringing in accounts from various systems. Sometimes an account from system A is the same account in system B. I'm wondering if there's a way to do some sort of smart match to automatically establish relationships between records. Something like, if the…
-
How to force legend to stay in a Specific order
I have two questions: 1. Is there a way to sort the legend in a specific order and have it stay that way? I would like it to be as follows: A B C D F But I am having trouble finding the option in chart properties. 2. There is also an extra option in the key that is showing up that doesn't apply to anything. Is there a way…
-
New nested statement
I Need to create this nested statement in the Domo Dataflow but I keep getting a syntax error. I tried doing it a few ways and both are creating errors SELECT CASE WHEN "Status__c" in ('Booked') AND > 111 THEN 'TIER 4' ELSE 'TIER 1' END FROM "sfdc_travel_raw" or this query SELECT *, SUM(case WHEN "Status__c" = 'Booked' >…
-
Any Way to Use Regular Expressions to Change Case of Specific Words
I've got a requirement to change the appearance of articles and prepositions in words in a column to be displayed as lowercase after running a Title Case on the rest of the phrase. Right now, I have an extensive list of text replacements in Magic ETL to do this, but I was wondering if there might be a way to do this with a…
-
Dataset column description mass load
Is there a way to be able to edit the column description field massively. For example if I have all the descriptions that need to be input but there are datasets that have over 800 columns .... is there a way I can upload these to the dataset?
-
Is there a equivalent Excel WORKDAY function in DOMO? Or is there any workaround way?
I have a start date, I want to know the next work day after a specified number of days. (exclusive of weekend and public holidays). In Excel, WORKDAY function can do this. Would like to know how to achieve this in DOMO. Thanks for any input.
-
Summing Values Between Dates & Comparing to Other Values
Hello, I'm looking for help with a problem I'm having comparing pay for a pay period to a providers billings. I have removed rows for simplicity in the screenshot below, but I'd like to sum the `Billed Amount` between the `Period Beginning Date` and `Period End Date`. Then I'd like to show that info on a bar graph with the…
-
How can I count occurrences grouped by a given field?
Hello Domo users, I need to count the number of occurrences grouped by a given field. See the example. I tried a beast formula, but I cannot get the total number of occurrences. Is there a way to do it using a beast mode? Or is there another way to figure out the number of occurrences? Maybe using Magic ETL? I would prefer…
-
Is there a way to have a dataset sorted alphabetically?
I have several datasets that have over a hundred columns... and I'd like to have them sorted in alphabetical order. Is there an easy way to do this without having to go through and manually adjust their order using Select Columns in an ETL?
-
What is the difference between Multi cloud and federated?
What is the difference between Multi cloud and federated? We use snowflake for data warehousing, trying to figure out what's the best way forward. and is there documentation that spells out these differences.
-
Filtering data will completely remove blank values
Hi community, I'm not sure if this is by design or if this is a bug. Filtering data within a field will completely filter out the blank values as well. It looks like Domo won't recognize the Blanks as a value. This is an scenario: FieldA, FieldB CategoryA,12345 CategoryB,58679 ,89658 CategoryD,97865 CategoryY,74935 Filter:…
-
Domo Test and Production Instances
hi all, In the organization I am currently working in, we reached a point where we are developing and maintaining a lot of dashboards. Whenever we update datasets or update/modify dashboards, the users were also able to see those changes. This is becoming an issue as users think there is a problem with the dashboard, but…
-
Case Statement help
I have an ETL with several joins and calculations. My final output is good except for this last piece: I would like to identify in a formula that when the "ID" column has the same # but the "Status" column is different, then I want to keep the status result from the "last update date" column. Is there a formula I can use…
-
Domo - delete data
Why does Domo not have a simple way to delete certain rows that match a criteria? How can I delete certain rows from a dataset? Analogous to SQL "DELETE FROM"
-
Compare one column to another then out other data.
I am not an SQL person by any means. I am using a Data set where I am comparing the supervisor's name to the employee's name (All names are on this data set) and copying the Supervisor's Email into the Employee supervisor's email column that is blank. So in theory Steve's email will be copied into Jim and Luke's line.
-
separating Output datasets from ETL
I think I made a a mistake of having 1 ETL facilitate some simple transformations for several input datasets. I have the ETL triggered to run whenever any of them update... but now it occurred to me that the ETL is going to keep running every time one of them updates - and I'm afraid it won't pull in the latest updates…
-
Adding 1 year to a date and returning the new year
Hi, I am trying to return the year after a specific date, I tried the below but it is not returning what I anticipated WHEN MONTH(`hireDate`)>=2 AND MONTH(`hireDate`)<=4 THEN CONCAT(YEAR(ADDDATE(`hireDate`,INTERVAL 1 Year)),' - Q1') For example, if the hireDate was 02/01/2023, the return should be '2024 - Q1'
-
Adding data that matches a date to a date dimension table.
I have HR data that has Start Date and End Date (or null) for each employee. I am looking to be able to see the number of active employees at any given date. I have added the Domo Date Dimension table to my data set, but I can't figure out how to join so that for any date I can get the count of employees who's start date…
-
Magic ETL: How to REMOVE Rows Meeting a Two-Column Criteria?
As part of my ETL, I'm trying to REMOVE rows that meet the following criteria: column 1 is NOT NULL AND column 2 is NULL So if column 1 has any value in it AND column 2 is empty, then remove those rows from the data set. I was trying to figure out how to create a Filter Formula for this, but it seems to be designed for…
-
To create ETL
I want to get a new etl by connecting two datasets. All stages are working, but they do not pass to the output part. When I press the save button, it does not save my work. Also, I was able to combine a data set and a file that was on my computer before using the "join data" command. Now this option is not active. I cannot…
-
Disregard - failed to convert value from string to boolean
Can someone tell me why this isn't working....??? Nevermind - I figured it out.
-
Using Magic ETL, how can i sort an aggregated string?
-
String Operation Add Space to Postal Code
Hi All, I cannot seem to find out how to add a space to a Postal Code Column using new Magic ETL. Trying to change a text string eg: S4L1A5 to S4L 1A5. thx!