-
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…
-
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…
-
Case Statement in Magic ETL
Hello, Is there a way to implement a Case Statement (not nested Case Statements) in Magic ETL? Thank you, Nick
-
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…
-
Case statement within a Range Statement
Hello all - I'm trying to calculate a value through beastmode from survey data and then use that calculation to provide a stage name of Novice, Transitional and Expert. Since I cannot reference a beastmode within a beastmode, I used the calculation in every case statement and had the sum categorized as a stage name. It…
-
Beast Mode Case Statement Help
For some reason this CASE statement will not validate. I have all the required parts. `PayTotal` and `PayTargetWeek` are both number values and I want this field to return a character string. case when (sum(`PayTotal`) / `PayTargetWeek`) <= -.05 then 'Under Target' when (sum(`PayTotal`) / `PayTargetWeek`) >= -.049 and <=…
-
Calculating and Grouping Generations / Age Stratification in Domo
Hi all - I figured since I got Domo Support's help on calculating generations / age stratigification I would share the beast mode calculation for anyone else that would find this useful and not have to reinvent the wheel. CASE WHEN `dateOfBirth` >= '1946-01-01' AND `dateOfBirth` <= '1964-12-31' THEN 'Baby Boomer' WHEN…
-
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…