-
Can i write a nested "if" "and" statement in beast mode?
here is what the excel formula looks like: =IF(AND(K5=0,L5=0),"remaining",IF(AND(K5=0,L5>0),"resolved",IF(AND(K5>0,L5>0),"no gap","new"))) thank you so much for your help
-
How to join datasets without a unique ID
Hey All, Running into a problem, I have a IP address for a user, and wanting to reference the country of origin for IP address. I have imported a IP address database, which shows the IP start and IP end ranges for specific countries. I have modified these and the user IP address to numerical value. The plan was to use…
-
How do I calculate IRR in a beast mode?
-
Beast Mode Numbers Sorting Improperly
Hi all - I create the folling simple beastmode to find the number of days between two dates: DATEDIFF(`Date1`, `Date2`) The formula validated and the output reflected the correct number of days between the two dates - great! The problem is that the card that the beastmode is in does not seem to recognize the value of the…
-
Sum of all instances of dates more than 30 days old
Hello all, I'm attempting to sum all of the instances of dates that are more than 30 days older than the current date to determine which users of my app are no longer active. Below is my beast mode code: SUM(CASE WHEN DATEDIFF( CURDATE(),Max(`Last Sign In`)) > 30 THEN 1 ELSE 0 end) However, ever time I run this command it…
-
Rolling Average Calculation
HI There, I'm trying to do a rolling average calculation. Compare Average of previous 7 days (not including yesterday) versus yesterday. CASE WHEN AVG(CASE WHEN `advertiser` = 'coke' AND (`day` <= CURRENT_DATE()-2 and `day` >= CURRENT_DATE()-8) THEN `revenue` ELSE 0 END) = 0 THEN 0 ELSE (SUM(CASE WHEN `advertiser` = 'coke'…
-
Beastmode calculate percentage of actuals compared to target (NOT total)
Hi, Ultimately I want to show utilization of billable & other hours worked, as compared to their allocated hours. The kicker is I need to account for people working more than their allocated hours, i.e. it needs to show greater than 100%, so I cannot use the built-in Percent of Total graphs. There is a set allocation…
-
Create a new table from existing table with data for last few days
Hi, Let say I have a table that corresponds to a Domo card. This table has a field with type 'Date' Now I want to create another table that is exactly mirror to my 1st original table, but will consider data only for last x-days starting from my System-date. Furthermore, that new table should be updated automatically when…
-
Is possible to send an E-Mail as final step of a DataFlow chain?
Hi, We are developing a dataflow that needs to send an email to a list of users after all the steps are done. I tried to use smtp library in a python script as follows: with smtplib.SMTP_SSL("smtp.gmail.com", port, context=context) as server: server.login(email, password) Giving this error: socket.gaierror: [Errno -2] Name…
-
Calculate the number of days that an event take place
I have a giant data set with Order number, profit, coupons, campaigns etc. I have categorized each order's promotion campaign. Now I want to calculate the profit per day for each campaign so I can make effective comparisons, but I don't really know how to use beast mode for this. I have a column of order data as well. I…
-
How to create a running total in ETL?
How can add a number from the previous month in the ETL?
-
case when field is blank write something else display value
Have a field settlementID, I'm wanting to display when there isn't a value for that row to show pending else show the settlement id something like when settlementID is blank then 'Pending' else settlementID thank you
-
Calculated field in a new Best Mode calculation
Hello, If a created a new calculate fied caled 'Data Calculated' can I use is for another calculation? When I am writing the formula below, I get A column in this calculation did not exist. case when `= Data Calculated` = 'test' then '1' else 0 end Thank you!
-
Week over Week Metrics - Multiple Stores to Show
Hello, Experts, I have a use case where I am looking to build a card for week over week showing in table format a list of stores in one column and total sales in another column for the given X # of weeks. Based on my reading, it looks like I will have to build a new transform to be able to accomplish this. Can you confirm…
-
how can i duplicate a data table
How can I create a duplicate of an exisiting data table in order to capture all of the beast modes, etc.?
-
Beast mode CONCAT() for creating a dynamic link in a table
I have a field in my dataset which I want to use to create a new field which is a URL in the below format - <a href="www.example.com/[`DatasetField`]" target="_blank">www.example.com/[`DatasetField`]</a> Where `DatasetField` is a column in my dataset. I am doing CONCAT like on the lines I have mentioned but it does not…
-
Calculating on a calculation
Couldn't think of the best way to title this but the description should make it clear. The calculation I need to do is a basic one but doing it isn't as straight forward as it seems. I'd like to calculate an average of the total work a team gets done in a set period of time and if you're familiar with the software dev…
-
Calculating Score Domo with Variable
Hi, I am trying to calculate a score from different fields using CASE in domo but it seems we cannot use variables in beastmode and I am facing dificulties. Each of my columns have values which I want to translate into a score and then sum up the final score for a line. ie: If Field1='1" Then score=20 + If Field2="Yes"…
-
Deleting dataflow and datasets
Is there a way to delete a dataflow and all its associated datasets/cards? It's irritating to delete a dataset, get navigated away, find the dataflow, delete the dataflow
-
Division - Beast Mode - Exceptions
Experts, So I have a division formula that we built in a beast mode. Some of my data on the bottom part of the divisor comes up as 0. So what I did to account for that is to do a NULLIF. However, when you divide by NULL Domo freaks out when you are trying to present this in a card. What ways would you recommend to…
-
Beast Mode not calculating for Current Year to Date
I am stumped on this one... I created a beast mode to calculate the number of rejections as a percentage of sales. Specific lines of data have reason codes to flag what type of transaction it is. So F, H, etc are specific type of rejection lines. The "0" is a normal sales transaction. The beast mode below calculates…
-
When do we use Magic ETL and SQL data flows?
Hello everyone Im new at Domo. When I want to transform and combine my data, is it better to use magic etl or sql data flows? Does it matter? Ive already made some experiences, they both work fine. Is there a difference? Thanks for your answers.
-
Beast Model for Calculating Average of Values for lines which meets certain conditions
Hi Everyone, I have looked through several posts to see if this was already discussed, but couldn't didn't quite find what I was looking for. I have a dataset that contains a date column representing the week for which the data is for. I would like to calculate the average of values within a 6 week period from the original…
-
Issue converting string to number in beast mode
I've seen some others posts about this and have gotten this to work on other cards but I'm having an issue converting a string to a number on this card. I've tried `Field_name`*1 and I've tried CAST(`Field_Name` AS DECIMAL(10,2)) but I get back a 0 or null response in the newly created column. I've also tried a CASE…
-
How can I display year over year counts of volume by physician?
Hi, I'm having trouble trying to get my physicians on a card and do a comparison of their volumes year over year on the same card. See attached graph.
-
How to use count distinct
When I do count(distinct) it is saying that is not a valid formula. Below is my formula. I am counting the sales names named (SalesHost), but against their sales and I want to sum the sales. I added a beastmode to calculate the rank, but need to get rid of the duplicate sales names. The first is invalid, but the second is…
-
Looking for an equivalent to 'SELECT column_name WHERE IN' for beast mode.
Is there a Beast Mode equivalant for this SQL? Can Beast Mode even accomodate something like this? select * from TABLE where ResolvedBy in (select distinct ResolvedBy from TABLE where AssignmentGroup = 'IT Ops T1 Tickets' and ResolvedBy != '') and AssignmentGroup = 'IT Ops T1 Tickets' order by ResolvedBy asc; I know it can…
-
How to build fact and dimension tables?
Hello everyone, I am new at Domo and need some help. I built a fact and several dimension tables (Star Schema), which are my data sets. Now I want to visualize the data, but unfortunately I can only choose one data set in a card. Is it posible to have a Star Schema in Domo? What do I have to do? Thank you
-
Calculate Variance of a variable from two date ranges
Hello I am fairly new to domo, and I am wondering how to calculate the variance of a variable in my data set from a specific time frame (Quarter 1 2019) and divide that by then variance from another time frame (Quarter 3 2018)? So far I have tried this, but this did not match with the values from a calculation in Excel:…
-
MySQL mapping fields to columns
I have a MySQL dataflow that contains all the metrics for our sales reps (new customers, pipeline, leads, etc.) from 8 different sources. I need to remove all the sales reps who are inactive/terminated, and I already have this field (Roster Status) available in one of the data sources (the Roster data). How can I remove…