-
OR statements in card filtering
Hi folks - We have a dataset where users can have datapointA and datapointB. We want to build a card where an end user can have a filter that asks for any user has datapointA = 'green' OR 'databpointB = 'circle'. When we put those two datasets in a dataflow/card and add the datapoints as Quick Filters, it automatically…
-
Set values in a column based on a "master row"?
We are a music library company that makes a large amount of our income from the sum of tons of small royalties. Pretty much the only information that comes in from the royalty reports is the track title and amount earned, and even if it does have other information it's not unified among all the different royalty sources…
-
Beast Mode calc for omitting specific modalities?
I have a dataset that contains data on a whole collection of transactions. Within the dataset is a dimension I'm interested in- Divisional Expenses. This dimension has a few modalities- HR, Sales, Marketing, etc. Each of these modalities has a value. If I want to create a beast mode calculation on Divisional Expenses that…
-
Getting dates in one row
Hi All, I am working on the data visualizer and have the data as below The columns order,model, ord date, rec date,cur prm come from the DOMO workbench while the columns prm date -7D, prm date -14 D, prm date -28 D come from the beast mode... I am trying to get the above data in the format below...Can you please help…
-
Finding average of difference in two different dates
Hi All, I am trying to find the average difference in the dates between two different dates at a level of plant ,segment, model and part..I used the Group by tile for the same and in the aggregated column I am writing the below formula AVG(DATEDIFF(`cur_prm_date`,`prmdate7` )) over (order by `cur_prm_date`) for which I am…
-
Getting an error in visualizer
Hi All, I am getting an error when I am on the visualizer ...There was a problem saving your card. If the problem persists, contact the Domo support team. ..Can you please let me know what to do now...Will I lose all the work I have done now..
-
data flow to added new data to dataset each week.
Hi, I'm a bit stuck trying figure out how to added additional data to a dataset each week. the new data is added as a weekly extraction and uploaded to DOMO via SharePoint connector. I also have a 10 yr dump of historical data. what im looking to do is to create a dataset set to include the historical data and each week…
-
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…
-
Mass Renaming Columns
Is there any way for me to mass rename columns? Instead of going into the "Select Columns" tile and going down the list 1 by 1 can I copy paste a text file somewhere that will do this? In any other case I would be fine renaming, but right now my dataset has an output of almost 700 columns.
-
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…