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…
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…
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"
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.
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…
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'
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…
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…
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…
Can someone tell me why this isn't working....??? Nevermind - I figured it out.
It looks like you're new here. Sign in or register to get started.