-
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…
-
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
-
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
-
How could we implement a SQL Flow that would split lines based on certain logic
Hello, I have an ask where I need to split lines when there are multiple Users working at the same time in order to accurately count how many users are working together during a certain interval. If I have 3 users working each one during different periods I want to split the Initial rows as per below picture. If I am able…
-
MySQL Workflow
Can Domo's mysql handle more than 500k records? It shows the import can only go to 500k but I'm assuming that is for previewing data not actual processing. I attempted to output only five rows from a million record dataset and it ran for 30 minutes before I cancelled the process.
-
Is there a roadmap for updating to MySQL v8?
Hi, A client has asked if we will be updating to MySQL v8 soon as we currently only support MySQL version 5.6.37? Thanks!
-
Trying to use a case statement with a When/Then clause inside it formula is validated but not workin
Hi I am trying to use a case statement with a When and Then clause inside it. The formula I am putting in is basic and has worked for other tables but not working for the one I am currently working with. I have tried these formulas: 1. CASE `SeasonalDescription` WHEN 'Easter' THEN 'Spring and Summer' ELSE 'Other' END 2.…
-
3 month moving with current month for a date column
I am trying to calculate a SQL formula for a moving 90 day period based on month. For example what I would like to see now is the date column rolled up into DEC,JAN,FEB and as we move to next month I would expect to see JAN,FEB,MAR. I know the current month function to get only the current month moving but having trouble…
-
Dataset query fails when not using a where clause
I'm trying to get all the data from my dataset by executing a simple query: Here's what my code looks like: rows = cnxn.execute(sqlcmd)for row in rows: dataset_id = '609f128a-ac54-4f4f-a71e-81362f9fa154' table_name = 'orders' query_url = "https://api.domo.com/v1/datasets/query/execute/" + dataset_id myobj = {"sql": "SELECT…
-
Is there a way to run ad-hoc SQL queries against arbitrary PostgreSQL tables?
My company is migrating from Mode Analytics to Domo, and I'm trying to understand whether and how I can run ad-hoc SQL queries against arbitrary tables. As a software engineer, I regularly use Mode's [query editor](https://mode.com/help/articles/querying-data/) to gain insights into our PostgreSQL database data in…
-
SQL DataFlow vs API access
Hi DOJO Community, Good morning. Do any of you know why when I am querying the API the runtime between two dates is about 2 minutes (querying 130k rows from a 16MM row dataset). But when I query it from SQL given a query using the SQL ETL DataFlow, it takes a very long time to run ( I terminated it each time)
-
Calculating hits per minute by timestamp and Parts ran
I am trying to calculate a live hits per minute by machine based on total parts ran per the difference between the start time of the day and the most recent timestamp. I am having trouble piecing together the correct formula to go about this. Does anyone have any suggestions? Thanks
-
Help with Converting Time Zone - 'DateTimeOffset' to 'DateTime' in SQL Connector
Hey everyone, I'm having trouble with a conversion from DateTimeOffset to Datetime in a SQL Query (inside a SQL connector). I am trying to convert my date columns when they are imported in DOMO as UTC so they are coming in as the right time (Db is UTC, Domo is Pacific) and convert them to DateTime. When I run…
-
Connect SQL Server Management Studio to Domo
Hi everyone, I have database in Microsoft Sql Server Management Studio. Is it possible to connect it with Domo instance using Microsoft Sql Server Connector ? https://domohelp.domo.com/hc/en-us/articles/360043436173-Microsoft-SQL-Server-Connector
-
Syntax for null
Hi all, I am trying to create a formula in ETL that deals with the null values in multiple columns. So far, no matter what kind of formula I use, I am unable to get the blanks filled in Here is what I am trying right now based off of all of the other posts I have read Again, nothing is turning up XYX like I would expect. I…
-
SQL Writeback - Importing to Existing Schema
Is there a way to specify a specific SQL schema the SQL Writeback connector uses? The documentation mentions it's possible, but doesn't mention the syntax. I can easily import to dbo, but would like to import existing schema.
-
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