sql
Discussion List
-
Creating an Artificial downtime for maintenance for only week and work hoursI am trying to calculate downtime within DOMO. The downtime we have currenlty coming from the other…
-
Is there a way to aggregate the output using a FIXED function used in a CASE statement?I'm a MajorDomo in a large retailer, and I'm working to rewrite our TY/LY Beast Modes to calculate …
-
Calculate Previous Quarter Start and End DateHello! I am looking to calculate the Previous Quarter Start/End Date and the Previous Two Quarter …Answered AddieB 224 views 3 comments 0 points Most recent by Alfrancis_Kallos Data Platform & Data Science
-
3 month moving with current month for a date columnI am trying to calculate a SQL formula for a moving 90 day period based on month. For example what …
-
Dataset query fails when not using a where clauseI'm trying to get all the data from my dataset by executing a simple query: Here's what my code loo…Answered ✓ user053667 570 views 7 comments 0 points Most recent by xywust2014 Data Platform & Data Science
-
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…
-
Making a bucket list of defectsI am trying to make a bucket for sentence long defects and put them in a column that is easier to f…
-
Aggregate count function does not work in the denominatorWhen I use the following statement in a card summary, it works properly. But when use it as a value…
-
Calculating hits per minute by timestamp and Parts ranI am trying to calculate a live hits per minute by machine based on total parts ran per the differe…
-
Help with Converting Time Zone - 'DateTimeOffset' to 'DateTime' in SQL ConnectorHey everyone, I'm having trouble with a conversion from DateTimeOffset to Datetime in a SQL Query …Answered ElliotGitter 130 views 1 comment 0 points Most recent by ElliotGitter Data Platform & Data Science
-
Syntax for nullHi all, I am trying to create a formula in ETL that deals with the null values in multiple columns.…
-
Magic ETL HelpHi, I am going through the Data specialist practical test and am running into troubles. Here are my…
-
Trying to Find the Top 10 part numbers by $'s for the year for each plant department.I have a large table showing plant department and their part numbers with the quantity scraped / do…
-
Is there a better way to perform a variable-length recursive query using MySQL ver. 5.6?I'm looking to perform a recursive query on a data hierarchy with an unknown amount of levels. I've…Answered ✓ Casey_Tsujita 77 views 1 comment 0 points Most recent by GrantSmith Data Platform & Data Science
-
Add Data that has been modified in the last 7 daysI have a snowflake dataset that has a modified date column. I want to merge the data that has been …
-
Can someone give me DDX Bricks examples which use traditional SQL (using JOIN) to query?I want to use traditional SQL to query to fetch data from database in ddx bricks. My sql query cont…
-
Need help reviewing sql query used to create domo sql dataflowHello, I am working on moving one of our SQL Queries to Domo. This query looks for users who have …Answered vikrao 263 views 15 comments 0 points Most recent by jaeW_at_Onyx Data Platform & Data Science
-
Deduplicating a table based on the content of certain columnsI have a dataset that has about 20 columns in it. The first column contains ID numbers and a lot of…
-
Creating a join from a lookup tableI have created a dataflow that joins two sets of data together, however when i join them together i…
-
LISTAGG or equivalent during data import from NetSuiteWhat SQL should I be using during an import to collapse data from a column into ',' delimited strin…Answered mberkeley 216 views 3 comments 0 points Most recent by jaeW_at_Onyx Data Platform & Data Science
-
How to use Escape characters in Beast Modes?Hi, I am trying to create a web link for a card using a beast mode and some of the values that will…
-
Is AS valid in Beast mode?Good afternoon, Can AS be used in Beast Modes to create aliases? It doesn't seem like it but I migh…
-
Table vs SQL Data Flows and which functions does Domo not recognize? (I'm confused)Hi, My CSM informed us that window functions are enabled. I would like to write the following via E…
-
Can I write SQL directly to my data sources?I know I can click on "SQL" in the top ribbon to write SQL against my data sources using …
-
Rolling 30 Day Formula in magic ETLHi, I am trying to write the formula above within magic ETL. Column A consists of static values. C…
-
How to Create Monthly Averages for Headcount?Hi All, I'm in the process of building an attrition model in Domo in the form: Total Terms / Averag…
-
use fields from different tables group by date to calculate percentageHi, I am trying to calculate a percentage using two fields from two different tables in SQL Magic T…