-
Why won't this beast mode work -- case statement
CASE WHEN `Variable Name`<= 1 THEN 'SMALL' WHEN `Variable Name` BETWEEN 1 AND 1,000 THEN 'MEDIUM' WHEN `Variable Name` > 1,000 'LARGE' END
-
Duplicate data points for Weekly Reporting. I need the most recent day for weekly reporting.
Our subscription data is collected on multiple days throughout the week and creates a snapshot of that point in time. I want to see what that week's total was based on the most recent day. I don't mind removing the row with an earlier start date.
-
Adrenaline Data Export Failed
Hello, My ETLs sometimes randomly say this for no reason, my understanding is that Adrenaline data flow is an advanced feature that we do not have. I have had this happen at least 10 times before and then it is fine the next day, probably just a glitch. But I have had this one dataflow that looks perfectly normal and will…
-
Declaring MySQL variable in Dataflow
Is it possible to declare a global variable in MySQL Dataflow? What I am trying to do is declare a variable in one transformation and call that variable in a different transformation Here's an example of what I am trying to do: Transformation1(SQL - No Output) SET @testvar = 1; Transformation2 (Table) - SELECT * FROM…
-
Is there documentation of the java CLI command export-data?
Is there documentation of the java CLI command export-data any place except inside the .jar file? I read thru https://domohelp.domo.com/hc/en-us/articles/360043437733-Command-Line-Interface-CLI-Tool#2.3.8. and it seems to describe everything except the export-data command. It just has the comment "For full exports, use…
-
Comparing two datasets for missing sites
Hi, I'm looking to compare two datasets from Smartsheet to identify which sites are missing from one dataset. For example, show me all sites that are in 'Master Schedule' but aren't on 'Secondary Schedule', both sheets have identifying numbers in column 'URN'. What would be the best way for me to do this? Would I join…
-
Dataflow wont run!
Hi I have my dataflow in Domo and it ran fine. I then added a bit to it to bring in more information and it saves and the preview runs fine. I expanded the preview to check the max number of lines. But....when I now go to save and run it, it just tells me DataFlow was saved, but could not be run. Any thoughts on what I can…
-
Best Mode Formula for 2 Month Period
Hi Everyone, I require help to create beast mode for 2 month period which would be like a Filter on the Dashboard. For example: Jan-Feb, Mar -Apr, May-Jun, Jul-Aug, Sep-Oct, Nov-Dec
-
MySQL Version
I have been using MySQL ETL for years. Our organization is starting to work with more unstructured data every day. Domo's implementation of MySQL has been stuck on 5.6 for some time. It appears the current version is 5.6.28-76.1-56. Most of the new JSON Functions show up in version 5.7+. Is there any plan from the Domo…
-
Test to see if a specific date falls between two other dates
Hi all, I am having trouble getting this beast mode to work. CASE WHEN 05-30-2022 >= start_date AND 05-30-2022 <= `end_date` THEN 1 ELSE 0 END or something like this CASE WHEN str_to_date('30-MAY-22','%d-%b-%y') >= start_date AND str_to_date('30-MAY-22','%d-%b-%y') <= `end_date` THEN 1 ELSE 0 END Both start_date and…
-
Extracting data from Domo
What are all of the options to extract data from Domo and import into Oracle? Can a daily alert be created to extract data to Excel, CSV, or Text file that then can be imported into Oracle.
-
Split string column into multiple rows
Hi, I have a column that has anywhere from 0 to 25 notes in one cell. The delimiter for the cell is a line break after each note. I need to split the cell into a row for each note so that we can filter for just notes that just apply to a group like "Billing" or "Admin". How can this be accomplished? We would like the…
-
Beast mode to extract the date based on a pattern
Hi All, I am trying to extract the date from a field based on a pattern - If the first four characters of the field description are *SLD then I need to extract the date from the field description as output date else I need to take the date from the field orddate as the the output date..please find the table below: can you…
-
Access dyanmic date filter in Beast mode
I want to leverage the date filter parameter dynamically in beast mode. For example: I have 2 date fields that are populated when an account is opened (Date Opened) and when an account is closed (Date Closed). I would like to have a count of active accounts based on the date range that is dynamically selected on the card.…
-
loading large datasets
Hello Domo users, We have "reports" in a database. There are say 10,000 or more. We need a solution to share ONE report with users. Is there a way to query the dataset based on a URL string? The solution we have loads ALL the reports which are visualized in the same way. We have to share ALL the reports with EVERYONE then…
-
SNAPSHOT ETL DATAFLOW
Hi Beatiful People - I was able to learn how to create a snapshot etl dataflow, just a quick question, where in the dataflow can I add a column that shows the date for the historical data and the date column for the appended data?
-
Replace text and value mapper failing
I have a couple data flows that use replace text or value mappers to remove certain text characters from a number column to then convert to an integer. Examples of text we are finding in our source data are "#DIV/0" and "--". However, when those characters don't exist at all in the source data, the replace text tile fails…
-
Requests Older than 6 Days
Hi Guys! I am trying to capture dates that are older than 6 days, but this Beast Mode is showing me zero although I know I have some. SUM(case when DATEDIFF(`Effective Time`,CURRENT_DATE()) >=6 then 1 else 0 end) Thank you!!
-
Help with Beast mode to calculate time in tier
Reaching out to the community in hopes that someone has dealt with the use case I'm struggling with. Our support organization operates in a tiered model (Tier 1, Tier 2, and Tier 3). I'm in need of assistance writing a beast mode to calculate the amount of time a ticket sat in each of the tiers. Using the above table, I…
-
Do Beast Modes show up on Views?
Will Beast Mode calculations show up on Views created for Datasets? I'm working with a view of a dataset, but don't see any of the Beast Modes that were shared with that Dataset....
-
Replicating SQL statement in Magic ETL Formula tool
Hi All, I am trying to replicate the following SQL statement in the MagicETL formula tool.. (SELECT MAX("FISCAL_YEAR") FROM table WHERE "DATE_VALUE" = CURRENT_DATE) AS CUR_FISCAL_YEAR In the Magic ETL tool I am giving the name of the output column as CUR_FISCAL_YEAR and Write Formula as MAX(`FISCAL_YEAR`) WHERE…
-
Are Averaged Aggregated Percentages % Straight Averages or Weighted Averages?
I’m a new user to Domo but experienced with Tableau, QlikSense, and PowerBI. I’m excited to keep learning with this new platform! Aggregating Percentages Does Domo calculate weighted average percentages on “Beast Mode” calculated fields when aggregating by averaging to a higher dimension? For example, my data is row by Zip…
-
Row Combine
Hi everyone, I've asked a similar question before, but I'm struggling to understand how to best combine multiple rows into 1 while still combining the data from the existing columns using a ,. I have a list of students who are enrolled in a course and they share an OrgUnitIDand then have different times when they have…
-
Sharing Dashboard with viewers of another dashboard
Hi All, I have a dashboard by the name (Dashboard 6) which is currently shared with 165 users ..I need to share another dashboard (Dashboard 7) with the same set of 165 users...Can you please let me know how to go about the same..Any shortcuts for the same... Thanks, Arun
-
Setting up a count off of different date rules in ETL
Hi everyone, I'm trying to set up a column that would show me how many workdays to pay a consultant for, depending on how many days they worked for over the month. The variables are whether the start or end date was during that month (and so they would only be comped for that part of the month - from start to month end of…
-
Magic ETL formula Help
Hi All, I am trying to use the following transformation for joining but I am getting an error...Can you please help! CAST(`DEALER_NO` as varchar(8)).. I am getting the following error... Syntax error in expression at character 20 on line 1 : cast (dealer_no) as varchar()) Thanks, Arun
-
How to always correct the date to the 1st.
Hello all, I want to know the code for ETL "Add Formmura" function. The column ”Data” will always contain a value for the year, month, and date. When the value comes in , I want to set the date value always to 1st by using " Add Formmura" function in ETL as like below picture. Could you let me know the code to enter into…
-
Beast mode help - a count of users who transact once a month in each of the last three months
Hi, Any Beast Mode gurus able to help me with how they think it would be possible to return a distinct count of users (customerid) who have transacted (transactiontime) at least once a month in each of the last three months? The table has every transaction made as a single row with a time and date stamp if that helps.
-
How do I get non-matching records from two tables in Magic ETL
I have two tables A and B , a unique record is identified by an ID and a date. I am interested in identifying the non-matching records in the two tables and using the output to build a report,how would I go about this?
-
Assigning the same value to different days of the week
Hi All, I am using the following Beast mode (Goal) to assign the same value to Monday ,tuesday, wednesday and thursday for different plants..Can you please let me know if the below is fine.. Case when `Plant` ='Celes' and dayofweek(`orderdate`) in (2,3,4,5) then '50' when `Plant` ='menes' and dayofweek(`orderdate`) in…