-
Attendance Occurrence Count
We've been able to accomplish a good portion of the original request within dataflow w/transforms rather than a beast mode, and we'd like to complete this request but need assistance on the last piece of it as the information available online hasn't helped as we'd hoped. We were told that this would fall under Gaps &…
-
Nested Concatenations in Beast Mode
Whenever we use nested Concatenations with Case Statements, every Concatenations gives a break line. How to avoid that ? CONCAT( 'Last Week SEO had ', ROUND(SUM(CASE WHEN WEEK(DATE_SUB(`Date`,1)) = WEEK(DATE_SUB(CURRENT_DATE(),7)) and YEAR(`Date`) = YEAR(CURDATE()) and `Tracking Code Program` = 'SEO' and `API Name` =…
-
Finding quartiles and outputting the data within each quartile
Hi I'm trying to break a dataset down into quartiles for Recency, Frequency, and Monetary (each data item will have a value for each). I then need to output the items that are within a given quartile in order to do further data manipulation. I know that box plot graphs can show quartile values, but they don't actually mark…
-
Redshift vs. MySQL vs. ETL
Hi Everyone, This Knowledge Base Article suggests guidelines for when to use certain In-Domo processing options, but admittedly I default to using Redshift for all of my transforms regardless of dataset input size. Am I missing out on faster data flow processing times by not following the guidelines in the article? I would…
-
Beast Mode: Calculations from multiple fields
Hello Dojo! My question is whether we can create a beast mode calculation to index values from multiple audiences. For example, we want to create a beast mode that calculates the quotient of two dataset fields (ex. `Total Devices`/`Total Devices`). To my understanding, the two dataset fields listed above always come from…
-
How can I find column name across DOMO?
I have a field called "User Name". How can I find Datasets/DataFlows contains this "User Name". Thank you
-
Easy Way to Measure Time in Business Days?
Is there a fairly simple way to do this or will I be looking at a fairly complex workaround? I am assuming that this may have to happen on the query side rather than in Domo but just wanted to make sure I am not missing anything. Thanks, Lucas
-
How do I identify the second lowest value? I.e. MIN('COLUMN') +1?
I'm trying to sort my API calls by time and label the order in which they took place, however I'm not sure how to identify beyond the MIN time. Is there a way to identify the MIN and then look at the second or third or fourth value thereafter? Ideally, my Beast Mode would then label each call with the order they came in by…
-
Activiey after a certain time in a DateTime formatted column
I am trying to see activity completed after 5pm, regardless of the day. I am not sure how to even begin creating this type of beastmode (if necessary). My Last_updated_date column is in a datetime format. I need to see the date but either have items color coded if after 5pm or have or have a new column added with a some…
-
MySQL Transform Only New Data
Hi, I'm trying to use a MySQL dataflow to transform data as it arrives (every minute via Stream API) but obviously I only want to include the new data not repeat the entire dataset transform each time (2.9m rowss and counting). Setting the append flag and the frequency on update doesn't do this, I just get the same 2.9m…
-
list all beastmodes
is there any quick way to get a list of all beastmodes that have been shared on a dataset?
-
Track Attendance Occurrences
Hi. We've been asked to track occurrences (absence, late in, early out) for a rolling 30 day period for employees. We're importing an Excel spreadsheet through Box from our 3rd party HR application and have the data required in that dataset but having trouble trying to accomplish this in a beast mode, and not sure if the…
-
First and Last Name in a single Column, when there is not Last Name
I have two beast modes that take the `name` and break it into two seperate "colums" So I can have a first name column and last name column on my table card. First Name LEFT(`Name`, INSTR(`Name`, ' ') - 1) Last Name RIGHT(`Name`, (LENGTH(`Name`) - INSTR(`Name`, ' '))) The issue that I am running into is sometime there is…
-
HTML in Summary Number
Hey all! HTML is not enabled in summary numbers correct?
-
Adding a column to a datasource in Domo Workbench breaks ETL transform (Redshift SQL)
Hello! I was hoping anyone might be able to help me out with this. I am using Domo Workbench to extract from a SQL Server ODBC source (instance is on-premise behind a VPN), and added a column that was needed to an existing source, but after reuploading the data to Domo, an ETL Redshift transform using it now errors, saying…
-
help with margin formula
Im running the following formula to produce my margin %, and want when 'override_payee_id' = 'MEADBIMT' to have the % always be 15% but currently the way its written its taking .15/SUM(IFNULL(`total_charge`,0))*100 which isn't producing the correct amount, how can I write the following to have when the payee id is MEADBIMT…
-
Using FROM_UNIXTIME Correctly
Hello, I think this problem is an easy fix, but it has proven difficult for me. I've imported some data from Hubspot about my contacts, and I'm trying to convert one column from UNIX into a human readable time using a calculated field. (I validated it before and Domo said it was good to go). This is my formula:…
-
Beastmode Percentage Calculation
Hi There, I'd like to do a percentage calucation of the following beast mode. COUNT(DISTINCT (CASE WHEN `Campaign` = 'A' THEN `ID` END)) / SUM(COUNT(DISTINCT (CASE WHEN `Campaign` = 'A' THEN `ID` END))) Can you advise on how to do an embeded beast mode calcuation? Thanks!
-
How to Create a Dynamic Pivot in Dataflow ?
Hi, I have a dataset that I would like to pivot on a certain column value, development month, that introuduces new unique values each time the data is refreshed. The issue that I am having is that this field can change any time the dataset is updated. This is a rather large data set (2 million rows) and I'd like to avoid…
-
replicating Google Analytics’ Time Format in DOMO
I want to show Time on Site (and ither metrics that report in minutes and seconds) the way Google Analytics does, but it shows up in DOMO as number of seconds. Is there a solution at the connector level and is there a solution at the beastmode level (something I could do on the fly for reports do yesterday)? Thanks all,
-
Calculated Field to Calculate Fraction of Hours between Two Timestamps
I am trying to calculate the number of hours (w/fraction, e.g. 36.25) between two datetime stamps, one of these fields may or may not be populated. I have tried multiple "TIMEDIFF()" fuctions but I cannot simply get the number of hours between the two datetime stamps. I've come close but cannot seem to get negative hours…
-
Create a date field for TODAY at exactly noon
I wish to compare dates to see if they are before or after TODAY at Noon. the 12:00 noon part is static, but the TODAY part changes every day so I want that to be dynamic. I tried this but it did not seem to work: STR_TO_DATE(CONCAT(CURRENT_DATE(),'12:00:00'),'%m,%d,%Y') Appreciate the help!
-
Why does the percentage change calc in Beast mode show -100% all the time?
I have a beast mode calculation that calculates % change in sales but the result in domo is always -100%. Below is my bbeast mode code. Any ideas? (((CASE WHEN YEAR(Target.`ForDate`) = YEAR(CURRENT_DATE) THEN Target.`RetailSales` else 0 END) - (CASE WHEN YEAR(Target.`ForDate`) = YEAR(CURRENT_DATE)-1 and…
-
Comparing WTD Sales upto the current time for last 3 week
Hi, I want to compare WTD Sales up-to the same point in time for the past 3-4 weeks. The Period over Period chart only compares WTD sales at the end of the day instead of up-to the current point in time. How to achieve this in Beast Mode or Dataflow level? Thanks, Prajwal
-
Recreating Excel's Pivot Chart "Show values as % Running Total In"
I'm trying to recreate this Excel Pivot Table in Domo (Currently as a Heat Map but if someone has a better suggestion I'm all ears). (See "Domo - Pivot 1.JPG) The good or bad thing is I can select the data from the database however I want so I'm free to do calculations before the data gets to Domo but the basics that make…
-
Dynamically Uncollapse Columns for Tabular Output
Hi, I'm trying to create a stored procedure like in the link below and while its not erroring out, its also not uncollapsing columns like it says it would. I'm not great at SQL and I've tried this in ETL but I can't get it to work there either. https://knowledge.domo.com/@api/deki/files/5209/Dynamic_Pivot.sql?revision=1…
-
Getting DateDiff to show decimal places
We're using two date fields in a card and are trying to show a difference between the two. The source data shows these w/decimal places (screenshot) but our card didn't, couldn't understand why but when viewing the data table at the bottom of the card, it seemed it might be caused by the PickupDate being YYYY-MMM only,…
-
User defined functions for Beast Mode?
Is it possible to create user defined functions that can be called in Beast Mode? I'm creating Beast Modes for summaries in the top left of a visual, and it's getting ridiculous & unwieldy pretty quickly. In order for it to look reasonable, I need to format and abbreviate the numbers, similar to how it's described in this…
-
Remove Duplicates - Keep Most Current Instance?
I have a table of Opportunities from Salesforce that I am pulling into Domo, and Appending on a regular basis, for any Opportunities that were modified by a User or Automated Process in the last day. The purpose would be to have the most current records of all fields, for every Opportunity. What I'm finding is that I most…
-
Adding an email address to table
I'm trying to add a clickable email link to a table. From reading through other posts, I know it has to be some form the CONCAT below. When I try to use what I've written, it doesn't do anything, doesn't open an email message, nothing. What am I missing? CONCAT('<a href="mailto:',`Email`,'">','Send Mail','</a>') In the…