-
How to get the first character of a string in domo beast mode analyzer
Hi I am trying to get the first letter in the product number field. I have created a test field to remove any extra white spaces the product number field would come with and here is the calculation: TRIM(ProductNumber) Next I am trying to use the Left function to get the first letter from that test field without any extra…
-
Help with SQL query
My first post so apologies if I have dropped this in the wrong forum. I have a slightly more complex dataflow than Magic ETL will handle and I am hoping I can manage this with SQL, however my SQL is a little rusty (read metal falling apart). The requirement is possibly quite common in that I need to measure how many…
-
dashboard not reflecting filtered values
I have a dashboard which has filters by semester term and college. There is a column for type of housing and a metric in the dashboard. The metric should display upon the filter on college as a whole as it is constant across all terms . However, it displays only upon filtering the terms, as the data is present across rows…
-
Can't Edit View
I'm a DOMO Admin and there is a DOMO dataset view that I can't edit - I'm getting the message 'you don't have access to edit this view'. The person who created this dataset also gets this message - nobody can edit this view. I created a copy and can edit that view but I need to understand why this message is appearing and…
-
Color Coding or conditional formatting in DOMO?
I am trying to make a scorecard for budget…etc… Let's say our budget in Jan was $14,418,053 and are actuals were below that. How could I turn that budget red? and vice versa if actuals were above budget it would be green? Is this possible in DOMO yet or are there work arounds. Thanks, Garrett
-
Using a simple case when function not working
Hi so I am trying to use an if-then statement in beast mode but it is not giving me the correct output. The field I am using in this code is product status and these are following values inside it. What I am trying to do is bucket the values into two buckets one which is repeat and one which is new. The code that I am…
-
How do I get started with MySQL Dataflows?
Hello all, I have roughly two years experience with creating Magic ETLs, but no experience with MySQL dataflows. I'm seeking to experiment with MySQL just for the sake of experimentation. Background: I've written thousands of Case When Statements for Beast Modes and calculated fields, but have very little actual SQL…
-
Recover a deleted dataflow
Hi, I was doing some cleanup and deleted some datasets that resulted in the deletion of a dataflow. Is there a way to recover deleted dataflows? I noticed a deleted dataflow could be recovered if you find a link to it: —but I can't find a link to the dataflow I need. Thanks.
-
Average Session Duration Y/Y
I am importing GA4 data and trying to display Y/Y in a multivalue on a dashboard. I used SEC_TO_TIME(Avg. Session Duration) to change the data to time format, but it's still not showing appropriately. Any ideas?
-
Blank vs empty square
Hello everyone, I encountered these two fields in one of my columns ("blank" vs empty square), which is messing a bit with my formulas. Why is this happening? What's the difference between the two? Thanks so much!
-
Multiple cases in CASE WHEN
Hello! I am trying to include a formula with three possible outputs based on three different conditions inside an ETL but I don't know what's wrong with my formula: Help is appreciated!
-
Not sure why I am getting a SQL Error
I have the columns correctly added, but even though its there in the columns list, I am getting an error. PLease check the screenshot to view details
-
Redshift Flow
We have a redshift flow that runs daily. The flow has past three years of data from three different flows filtered by the date. Recently some changes were made to the historical data and I cannot see those reflected in the redshift flow. However, if I write the same code in a separate Redshift dataflow it works. Can anyone…
-
SQL View of DataSets
Is there a way to view the SQL query of an output dataset in Domo? We are working on exporting our data to Cognos and it would be nice to see the query we are working with in Domo when recreating it in Cognos. Thanks, Erik
-
MYSQL Time
Hi, Is there a way to cut down the time of MYSQL dataflows? I have a dataflow that takes 6 hours for 5 million rows of data and would love to find a way to cut that down.
-
Adrenaline Time Out Error
Getting the following error on Adrenaline flow: "ERROR 3326: Execution time exceeded run time cap of 00:30" Can someone please help?
-
MySQL
For this question: Join together two DataSets with MySQL using the name, year, and gender columns and include appropriate indexing. Not sure what to index here, is there any additional resources around indexing? The course doesn't go over it explicitly and this link doesn't either:…
-
Domo comparison with ETL Tools
Does Domo has all capabilities which modern ETL tools like Azure Data Factory, Apache Airflow, Informatica etc.
-
How do you remove some column data?
I have a column with true and false values for emails. I want to remove all the false values, but when I do, I lose the other columns (meetings and calls) in the table chart. How do I remove just the false values, but have it not apply or filter out all the other data columns?
-
Building Data Mart inside Domo
Hi, Can we build Data mart inside Domo? Are there any challenges or limitations we need to consider?
-
Build ODS Layer Inside Domo
Can we build ODS (Operational Data Store) inside Domo for serving the use case of near real time reports (~ 6 mins latency) ?
-
How to correctly pivot this data?
I am trying to pivot the data below in an ETL flow. I am having trouble formmatting it correctly to PIVOT how I need. I would like the following above to look like this after complete… How could I do this? Thanks
-
Trailing Totals Deep Dive
Yesterdays Community Meeting was awesome with lots of valuable insights, but was wondering if someone could elaborate a bit more on how the trend SQL works, I know we saw 2 of the transforms but I'm having a hard time figuring out the rest, like how is information being filled so that the rows 91-1 represent consecutive…
-
ETL Pivot Tile
I am trying to pivot the warehouse clean column with the values to show like this: How Would I go about formatting the pivot tile for this? Thanks
-
SQL formula for blank cells
I have a table with some cells that are blank. I would like a zero to populate in the cell instead of them being blank. Is there a simple SQL formula someone could share with me to change the blank cell to a 0 number?
-
Is there a way to bucket columns similar to excel in DOMO?
I am trying to have a pivot table that shows weekly plans vs actuals. Is there a way to add a top layer of that to group the value columns into the top three pillars? Supply, demand, revenue. Thanks
-
Restricting Dataflows
I am admin for my instance.. I have shared input datasets to a specific group with a role. But I notice that they automatically get all my dataflows access that include those above shared datasets and they are able to edit the dataflow as well. Is there a option to restrict the access of dataflows (ETLs) though those…
-
UPDATE Statement in MySQL Flow is not updating the value in the Table.
Hi Team, I am trying to create a MySQL Data Flow using below SQL Transform which will have a UPDATE statement. Some How it is not updating the Column in the output table which I want to update. Can you please check what am I missing ? ====================================== CREATE Procedure GetAllDates() BEGIN DECLARE l_cnt…
-
SQL formula not working?
I have a series of tests that run to determine a pass or fail. All the formulas work but this one is giving me problems - CASE WHEN Critical/Major= 'Common' AND
No>= 2 AND Critical/Major= 'Major' AND No>= 1 THEN 'Fail' Any one know why this would not be returning a Fail?
-
Dataset Email Connector
I have a dataset that updates via email connecotr. When the data is sent to the connector the dates turn into integers. Is there a way to fix this? Thanks