-
Sudden Beastmode error
Hi there! I have a card, which uses a lot of beast mode calculations. All of a sudden. I get this error: "You have a divide by zero error in your Card´s Beast Mode / Link: Get help in Domo´s Knowledge Base" So, I checked everything and I was told that I needed a case function to avoid 0 division, also checked DOJO topics,…
-
Identify customers ordering on multiple dates
Hi I am trying to build a beast mode calculation to isolate customers that have ordered based on certain conditions. My dataset contains all customer ordering activity, each customer is identified by a unique user ID. Customers will often order multiple times each week. Each customer order is assigned a unique order ID and…
-
Dual figures in the Summary Field with CONCAT
So i found the solution to get two different values in the summary field with CONCAT command. I have the following beast mode command CONCAT('$', round(sum(`Value`), 2), ' Period Total | ','$', max(Case when (`date` = CURRENT_DATE()) then round(`Value`, 2) end), ' Today') what it does is allows me to se a sum of values in…
-
making sum of daily averages
So I have a data set which has the a date column and a column that represents a certain value for each date. I have several years of data where I have a single corresponding value but my latest data has multiple values per day - i.e. i have basically an entry for each 5 minutes per day. So when I graph this in a bar chart…
-
unexpected result from joining to ETL data flows
So here is another strange happening that I do not understand. Here goes folks: I have two data flows that I have created each contains a date column and a value column. The date columns don't match up exactly - same date but not the same time samps... anyway I want to join them so that I will have one date column and two…
-
How to filter range of measure value for specific dimension
Hello, I need to ignore some specific range of measure data for some specific dimension value. Please help. Eg : Yellow lines to be ignored. when product name = computer or laptop then amount is not equal to between 100 to -100 Please advice. Thanks Bikash
-
Beast Mode update
It seems like in the new Beast Mode you can't look through a list of previously written calculations on the data source. When you open Beast Mode via the 'add a calculated field' button you can only see a blank template for what you want to work on. It also seems like a Beast Mode calculation isn't available outside of the…
-
Sum ( Extract ( ) ) using RedShift
Using RedShift,,, i know that EXTRACT ( minute from date1) will give me the minute from date1 (18:03.94 returns 3) Ok,,, so now in my RedShift i said SELECT SUM( (EXTRACT(hour from date1-date2)*60) + extract(minute from date1-date2) ) So in my POSTGRES db, that returns everything great in total minutes.. Here's what i am…
-
How to count number of work days in a date range
My first Dojo question. I hope it is worthy. I need to create a simple table that shows the number of work days since the begining of the quarter, The total number of work days in the quarter and use those two numbers to calculate the percent of the quarter completed. Is there a way to count the days in a date range that…
-
Why are not all of my beast modes copying over when I switch datasets?
I have an existing dataset built using the dataflow that powers a lot of my cards, and which has a lot of beast modes on (some unique per card, some shared across the dataset). I've created another identical dataset using the data blend. However, when I switch over datasets, not all of the beast modes copy over. When I've…
-
Current Day vs Previous Day in Table
Hi Everyone DateSalesproduct6/13/201621A6/12/201620A how to create a table like below by using date set above Output ProductCurrent_Dayprevious_dayDoDA21205% Thanks in advance
-
Data Fusion Request - Changing Column Names
Hi - Could you please prioritize adding the ability to change field names in Data Fusions after they have been created? I understand that currently this is only possible at the initial creation stage. This is problematic because additional field names not only come in unchangeable, but they are combined with their original…
-
New User: Calculated Field Sum Error; Cannot find resolution documentation
This is an elementary function, and I appear to be doing it correctly, yet I cannot get the correct outcome. I am using beast mode to add a calculated field, which combines the value of 2 raw data fields. However, the calculated field, no matter what I do, always returns blank values instead of a calculated value. What am…
-
Case Statement (dividing by specific conditions)
Good afternoon, Dojo's. We received assistance in another thread (https://goo.gl/i5cVjC - thank you @RGranada!) but needed to expand upon the original beast mode to determine a completed percentage for only certain individuals as opposed to company-wide and @Valiant suggested it's best to open a new thread for this request…
-
Group by Value in Column
Hi All, I'm looking to find a way to group a dataset based on a specific value in a column. Any ideas how to do this? Thanks! Eric
-
How to apply mean to all rows though beastmode?
Is there a way display the mean for all rows without aggregating (summing)? This would require aggregating a field and returning it to each row. For example: ID,Amount,Avg Amount 1,$10,$20 2,$20,$20 3,$30,$20 While this can be done in dataflow, it needs to be dynamic (use will filter and change date range) and thus done in…
-
Is a Case Statement using COUNT / SUM possible?
Good morning. Not sure if it's the case statement itself, i.e. incorrect syntax or if there's an issue related to divide a COUNT by a SUM value. We've also tried to run this as COUNT / COUNT but to no avail. We'd like to use only certain agents when trying to determine a Completed Conversion % for offers. The beast mode…
-
Creating New DataFlow from Zips2Fips DataSet and ODBC DataSet
I have USA map card that I want to drill down to counties. I got Zips2Fips DataSet from DomoSolutions that I have to join to my DataSet. I tried to do that through Magic ETL joining these two DataSets matching ZipCodes, but I am getting empty rows. What could be the problem? Thank you, Marko.
-
HTML - Mobile and PPT friendly
Is there any trick to getting the HTML that I've put into summary numbers via beast mode to work on the mobile app and/or in a downloaded PPT of the card? I'm thinking the answer is no, but just wanted to check. Not a huge deal, but having such nice looking summary numbers on a desktop browser then it looking messy on a…
-
Finding the last non-zero value in each column
I've got a DataSet with several columsn. Each column stores a single statistic: TotalItems NewItems RepairItems There are many rows, each of which has each column along with data, location name and other values of interest. Here's the question: Sometimes rows have 0's that indicate 'no change'. What we're after is a chart…
-
Case statement clarification
This seems pretty straightfoward, but I wasn't able to find a definitive answer searching Domo or Google. We're hoping to clarify whether the beast mode formula (case statement using "OR") will return a total count of five (5), i.e. count each row one time or eleven (11), i.e. instead counting EACH instance of a condition…
-
Error: Table in Dataflow "doesn't exist" but it does
I have two transforms with output tables that I select from to create a new dataset however the system tries to tell me the table doesn't exist and I'm not sure why. Is there some sort of limitation that I'm not understanding?
-
Exclude all data from Current Month (in either Beast Mode or ETL)
My aim is to exclude all current month data. I have tried to do this in ETL, however the date field filter doesn't appear to allow for "less than current month" - happy to take suggestions. I have also tried in Beast Mode formula. I have successfully excluded data in other calculations using currentdate however am…
-
When viewing a dataset, is it possibl to see a list of flows and cards that use it?
When viewing a dataset, is it possibl to see a list of flows and cards that use it? Currently, I can only see the count of the number of cards/ETLs that use it
-
Magic ETL Help - Overwrite value in a column if another column equals one of two values
In our sales system there was a recent change to a part number, and I need to correct history in the dataset. If the 2nd Item Number is either "LOT SQD STOCK" or "LOT SQD SPECIAL" then I want to overwrite the value in the Supplier ID column to be "SQD" otherwise I want the Supplier ID column keep it's current value. I'd…
-
Average if channel type statement beast mode
Hello, I am trying to create a summary number that takes an average of one customer type and compares it to another. My code currently looks like CONCAT( (CASE when `Channel` = 'RET' then SUM(`ordercases`)),' | ' (CASE when `Channel` = 'FSV' then SUM(`ordercases`)) I am having trouble with the syntax. Has anyone had any…
-
Count Based on Unique Identifier
Hello all, I'm very new to Domo and in particular Beastmode. In this case, I do not have access to the dataflow behind the chart. I'm trying to count the number of yes and no responses for each unique ID number to put into a stacked bar chart. My X-Axis is the person and the Y Axis is the total number of unique items…
-
Date Difference contingent on other column values SQL
Hi I am trying to find the date difference between different rows with like IDs. Please see screenshot of Excel to see data needs clearly. Also screen shots attached from SQL transforms. SQL Does Validate: Transform 1 SELECT sp_palapprovals_workflow_history_dwb1. *, Case when (`Primary Item ID`=`Primary Item ID`) and…
-
Subquery versus Output Table
I am always looking to optimize my dataflows and was curious if it was better to have multiple output tables in a dataflow or less output tables by utilizing subqueries? For debugging and readability it is nice to have multiple output tables but I do not want to do this if it will have a negative impact on performance.…
-
Magic ETL - Add a "Flag" column based on comparing a date in one column to current date
In my data I have a date column. I'd like to create a column via Magic ETL (want to use in a filter) that looks at the date a determines if it is in the past or in the future. Here is a short video that explains. From an Excel formula standpoint, it would be: =IF([@[Last Update]]>TODAY(),"Future","Past") I tried with value…