-
Adding row numbers to a table with a Beast Mode?
Is there a way to add row numbers to a table with a Beast Mode? So there would be a column to the left of Date with a 1. for 2020-09-01, a 2. for 2020-09-08, etc?
-
Beast Mode: Reverse Date Count
Hi All, I have a database containing project information updated on a day by day basis. A project will have an associated RAG (red, amber, green) status and the corresponding date. For example, Project X was red for 10 days, then green for 3 days, and red for 7 days up to today. I need a statement which, first, identifies…
-
Domo totals are way higher than they should be
My Domo totals are way higher than then should be when I sum them, for example plays total should be 3,075 and it's over 48,000. When I try using the sum distinct, the values are much lower than they should be. Additionally, when I use the sum distinct I'm getting duplicates. Does anyone have ideas of how to fix these…
-
Six Sigma score calculation in ETL
Hi, I'm trying to calculate the six sigma score in ETL, the excel formula is =NORMSINV(1-(((Errors/Total records)*1000000)/1000000))+1.5 I found a Redshift function CUME_DIST but it doesn't do what I need. Any inputs to achieve this is much appreciated.
-
Sharing calculated field in dashboard, and cards within only
Hi there, When I create a calculated field in beastmode, I understand I can share the field within dataset. How can I share the formula so that it's only available within the dashboard and its cards. I do not want to publish whole bunch calculated fields that's visible to everyone who is using the dataset.
-
ETL using Append object not showing all records
Has anyone noticed that all the other object/functions in ETL in the preview tab show the full number of records except Append Rows. In a current ETL I am building and troubleshooting, I was trying to find out where data is dropping off in error and I got to the Append Rows object I was using and it is by default showing…
-
Simple count of unique responses by location
This should be easy I think. I have an app that produces survey response data in a pattern something like the simple example shown. Each row is a response to a question, and each response is tagged with a "ResponseGroupID" that ties them together as having been entered as part of a single "batch". I'm finding it easy to…
-
How to find position of string in Simple Domo ETL ( NOT in Beast Mode)
Hi All, I have requirement where i need to find a position of character in Domo ETL (Not Beast Mode). Can anybody assist me on this? Below is the example String ----> Asx@par Ans = 4 The symbol @ can come anywhere in input string so i need to find it's position. Thanks in Advance.
-
Change color of the data label values
I have attached an imagine of the card I'm trying to modify. I have a line + grouped bar chart. In the image, the red line is the budget numbers, and the green bars are the actual numbers. I'm trying to get the value numbers for each metric (budget and actual) to be different colors. So for example, I'd want all the number…
-
Calculate employee occurrences (absent, late, etc) from REHIRE date
Hey all. Wondering if anyone would be able to assist with this. We have a card (simple bar chart) where we show employee occurrences, e.g. absent, late, early out, etc based on a dataset that pulls together a couple different tables, assigning point values to these occurrences for a sum total (absence = 1 point | late <=10…
-
ETL Magic - Join on Date Range?
Hello Dojo, Looking for a solution to the following problem. I have a reference data set that has multiple spans of time, StartDate and EndDate, for a given ID. I was hoping to join to this via ETL Magic, but it looks like currently it only supports explicit joins between columns, correct? For example, I'm trying to…
-
DoMo trims leading zero while loading Text data into domo
Hi All, I am using simple DoMo ETL (Not Beast mode) and I have an issue with DoMo. I am loading text data from salesforce into domo using "salesforce" connector. The text data contains all numbers with leading zeros. Since there are no chanracters present in text data Domo treats it as number and trims leading zeros while…
-
Data Extraction from Teradata
Hi All, I need to create a DoMo Dataset by extracting a data from Teradata. Can anybody help me know which connector needs to be used and steps to fetch data from Teradata? All your help is appreciated.!!
-
Monitor last run of datasets
Hello Community, We are looking for a way to monitor the last run of our email datasets. At the moment we are feeding the data through Email either manually send to Domo or via Obiee, however from time to time either someone forgets to upload the data or the automatic upload fails. As a solution, we would like to build a…
-
CAlculated Average to include in my datasource
Hi All, I need help since I am not familiar with sql, but I need to a column with the calculated average for a particular product which does not have averages available in my datasource. This is a small sample of my data: As you can see the AUM product does not have an average balance in the source system hence it has to…
-
Empty cells after aggregating and creating a case when variable
Hi I have a dataset that shows a sale/lost sale an agent made on a daily basis. Now I am using the dataflow to get the sales % over the last 3 months (data is only last 3 months) per consultant and want to join it back to the original dataset for later card creation purposes. This following formula gives me empty values…
-
Summarize many columns in MySQL
SQL newbie. We have a dataset which is sourced by a google-doc. The data has many columns with short strings in them. Our goal is to summarize it to two columns Column 1: Order Number Column 2: A concat of each column on a given row (with the column headers prepended in) I have created a transform that extracts all of the…
-
MySQL joins are not case-sensitive!
I just realized that joins in SQL in DOMO are not case sensitive! This is a huge problem for me and my team. Here's an example: table_1: teammanager_idSalesJohn123MarketingJoe341 table_2: locationmanager_id_2MichiganJohn123CaliforniaJOhn123TexasJOHN123 selecttable_1.*,table_2.*from table_1left join table_2 on…
-
Unsupported SQL type '{columnType}' for column 'VARBINARY'
I want to assign NULL values to certain columns in a SQL transform: SELECTNULL as 'column_x',NULL as 'column_y',column_zFROM Table_1 The dataflow gives the following error: Unsupported SQL type '{columnType}' for column 'VARBINARY' This is because from what I understood from another post in Dojo: you cannot assign NULL…
-
Tenure calculation using differences between 2 dates (magic etl)
Hi, I am creating a new variable using the add formula icon where I am creating time period bins that reflects the tenure of the consultant in reference to today. This is the formula I created: case when CURRENT_DATE() -`CD (Start)` < 90 then '3 Months' when CURRENT_DATE() -`CD (Start)` >= 90 and CURRENT_DATE() -`CD…
-
Create Task on Dataflow Output by Row
Hi! If this isn't the right forum to post this, please let me know. TL;DR: I'm trying to automate alerts/tasks from the output of a dataflow such that each row in the output gets its own task instead of the entire updated dataset getting one bulk "dataset is updated, here you go" task. Two failed attempts are detailed…
-
Does datafusion count against warehouse row count
Reading the documentation for datafusions: DataFusion: Advantages and Disadvantages * Because a DataFusion is a just a view of the data, the output doesn’t have to be materialized and indexed into the Domo databases, which makes it so that data can be combined, visualized, and updated very quickly in Domo. * It makes data…
-
Beast Mode validated but not working
My Beast Mode shows it is validated, but then the numbers will not display on my graph. The error message I get says "An issues has occured during processing. We are unable to complete the request at this time." How do I fix this beast mode to get it to work properly? SUM(`Item No`) / Count (Distinct `Customer ID`) or I…
-
Filter Field with LIKE based on another Field
Hi all! Hopefully someone is able to understand what I'm trying to achieve and help with a solution. I need to filter based on a "Tag" field with single text values, once selected would filter all relevant items in another dataset that has these tags in a single field "Tags" with multiple text comma delimited "tag1, tag2"…
-
Multiple Case Statements
Hi Everyone, I am having a bit of trouble stringing together multiple case statements... The end goal of my attempted beast mode is to calculate Average Weekly Cost Per Lead (CPL is Cost divided by # Leads). The wrench in this whole scenario is that I have to do this based off the broadcast calendar. Broadcast Calendar is…
-
How do you change the order date "2020-01-06T16:56:00" to the first day of the month?
How do you change the order date "2020-01-06T16:56:00" to the first day of the month? Via transform.
-
Grouping into one Row
I want to be able to group the parent_wID field so that it is one row per entry. As you can see, the Retail/Wholesale columns are build from beast modes from a separate field. This is the syntax i used to separate those. "Retail" (CASE when `Loan_Originator_Type` = 'Retail' THEN 'Yes' else 0 end) "Wholesale" (CASE when…
-
Trying to filter records, but something is going wrong
Hi there, I have a single dataset. I am trying to filter records based on 3 criteria. For example, I would like the row to be included in the resulting data is column A = 7, or column B = 7, or column C is not null. I have tried a single filter, including the three above conditions and set the rules to "any" (not "all").…
-
Issue with Nested Case Statements
I have a dataset of call records. I am attempting to filter out records that fall outside of business hours when the 'Call Result' is 'No Agents in Queue,' based on the product the call was associated to. I have created the following Beast Mode calculation to do so: CASE `Last Leg Product`WHEN 'NPAC-CCS' THEN (CASE WHEN…
-
Whoops! Something went wrong.
I have a dataflow with 50+ transforms that has been working. Recently I added some more transforms to it and now when I run the final transform that joins all the other transforms together I get this error in red "Invalid" next to the RUN SQL button. Usualy if there is a syntax error or a missing transform it will tell you…