Community Forums

Discover best practices and find answers to your questions with advice from fellow Domo users.

Recent Discussions

Please I need help with setting up a retention chart
Hi Domo gurus. I'm trying to create a "line + grouped bar chart" similar to the ones attached below. My goal is to create a chart that shows monthly cohorts of users who have made '100 api calls" and showing x% who returned to make other 100 api calls at the interval: 31 - 60 days, 61 - 90days, 91 - 120days, 121 - 150days.…
Is it possible to use while/do loops in MySQL in Domo Dataflows?
I have data that has varying rows of data for each identifier, from one row to 26. For each identifier, I have four different columns that change with the various rows. For each new identifier, I want to loop through the rows that follow that have the same identifier and build the row out with the unique values in these…
Graphing a [Case Statement + Window Function] calculated field
Hey everyone! I've run into an issue while attempting to create a card to graph a calculated field that involves a case statement and a window function but I'm not sure if my implementation is wrong or if this is a Domo limitation. I have a database that records the Employee's ID, Date, Hour of Availability (24H format)…
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…
Case Statement Help - Condition not being passed
Hi All, I've been struggling with this absurd problem when creating a beast mode calculation using case statement. Basically I'm trying to pass 2 conditions into my case statement but for some reason, even after validating the formula, only 1 condition is passing. My calculation is: (CASE WHEN YEAR(`transaction_date`) =…
Dividing with Multiple Beast Mode Functions
I have 2 formulas I am trying to divide into one another CASE WHEN `Action` = 'Lead' THEN SUM(`Unique Events`) END and CASE WHEN `Action` = 'Completion' THEN SUM(`Unique Events`) END Individually they work fine and result in 100000 and 50000 respectively. I need to divide Completions into Leads to determine my dropoff rate…
Find Count Distinct w. Multiple Factors
Hello! I need to find ‘new initial customers’ by sales agent at the campaign level. For the purpose of this report, we define a ‘new initial customer’ as a customer (Customer_ID) who entered into a campaign (Campaign_ID) within a specified time range (by calendar month). I need to only count Customer_IDs the first time…
Case Statement Using Beast Mode Calculations
I need to create a card with one out of two solutions: * one chart that allows me to stack other beast mode calucations on top of one another, resembling a table; or * two very elaborate CASE statements that group together a dimension and measure of 17 categories. The former does not seem to exist, so it seems I'll have to…
Beast Mode - Parent of Parent type join
I have a data set of project items at multiple levels of a project hierarchy: project > task > sub task. I'm trying to build a sort of rollup card that shows the items based on parent link relationships. i.e.: * Project Parent = Self * Task Parent = Project * Sub Task Parent = Task I'd like to be able to have a column that…
Replacing IFNull value based on a separate key
Hello and thanks to anyone who responds to this in advance. I'm relatively new to using DOMO and have been experiencing issues trying to replace null values with the corresponding data. The report that I am using was exported in a weird manner due to how our back end is structured. The primary key (Project ID) exports 2…

Welcome!

It looks like you're new here. Members get access to exclusive content, events and more. Sign in or register to get started.