formulas
Discussion List
-
How to aggregate a case statement that uses a fixed functionHello, I was hoping somebody could help me understand how to sum the following case statement. case…Answered Chris_Wolman 18 views 2 comments 0 points Most recent by Chris_Wolman Beastmode & Analytics
-
Converting string to dateHi, I know there's a STR_TO_DATE function but maybe I could use more insight because it's not worki…Answered ✓ jrtomici 22 views 2 comments 0 points Most recent by jrtomici Data Platform & Data Science
-
ETL formula vs Beastmode - result discrepancyGood afternoon, I've come across a headscratcher where a formula created within ETL is giving a dif…
-
Calculate Previous Quarter Start and End DateHello! I am looking to calculate the Previous Quarter Start/End Date and the Previous Two Quarter …Answered AddieB 216 views 3 comments 0 points Most recent by Alfrancis_Kallos Data Platform & Data Science
-
Using RegEx to Extract DateHi all! I am looking for advice on extracting a Maturity Date from a column containing a string of …
-
First Non-Null Value from Column in Formula TileGreetings DOMO, Does anyone know how to find the first non-null value of a column in a formula tile…
-
How do I write the syntax for YOY % change?Hi all, I am trying to create a calculate field where I am able to see only the change from year to…
-
Calculating hits per minute by timestamp and Parts ranI am trying to calculate a live hits per minute by machine based on total parts ran per the differe…
-
How to Make a Weekly date range into a Daily Date?Hello Domo Dojo Masters - Good Day! We have data from salesforce that only has a start of the wee…
-
Social Media: Follower Total for yesterdayHi guys, I am trying to create a formula that Account Engagement Rate. As a part of the calculation…
-
Beginner - managing a wide table, creating sum of..Hi there, newbie here. I have a wide table with a column format a bit like this: name, question1, O…
-
Find greatest value for each specific IDHi, I have a dataset like this: ID Value 1 5 1 6 1 7 2 23 2 24 2 25 I wa…Answered ✓ jrtomici 82 views 3 comments 0 points Most recent by jaeW_at_Onyx Data Platform & Data Science
-
How to represent how many tickets opened by each individual user?Hi, I am trying to figure out how to pull 2 datasets together correctly. So, one dataset is Users …
-
Any chance I can add in a percent change over various fields in a pivot table via window funciton?I am doubtful that it is possible, but I'm holding out hope that somebody might have some insight. …
-
Convert text to dateHi All, I am trying to convert a string to date... STR_TO_DATE(`MFGDTE`,'%Y-%m-%d') But I am gettin…
-
Finding average of difference in two different datesHi All, I am trying to find the average difference in the dates between two different dates at a le…
-
Replicating SQL statement in Magic ETL Formula toolHi All, I am trying to replicate the following SQL statement in the MagicETL formula tool.. (SELECT…Answered ✓ ozarkram 71 views 4 comments 0 points Most recent by jaeW_at_Onyx Data Platform & Data Science
-
Magic ETL formula HelpHi All, I am trying to use the following transformation for joining but I am getting an error...Can…Answered ✓ ozarkram 51 views 2 comments 0 points Most recent by ozarkram Data Platform & Data Science
-
Beast mode for count distinct by concatenating two columnsHi All, I am trying to do the following beast mode operation: COUNT(DISTINCT (CASE when `ord_date`…
-
Help with Beast mode for getting the distinct count by order number for This year and last yearHi All, Hope you are doing well!.. I am trying to get the count of distinct combination of ordno an…Answered ✓ ozarkram 67 views 3 comments 0 points Most recent by ozarkram Data Platform & Data Science
-
Replacing single quote/apostrophe with nothingI am trying to replace a single quote with nothing using the formula tile in Magic ETL, but it is g…Answered ✓ MarkSnodgrass 168 views 3 comments 0 points Most recent by MarkSnodgrass Data Platform & Data Science
-
4Regex in Formulas in Views and in Formula ETL TilesI would like to be able to use regex to match values in formulas. Both in views and ETLS Such as t…
-
Value from yesterdayHi guys, Im trying to pull in the value from yesterday to fit into a broader formula. The value is …
-
4Global Formulas in ETLsI would like to have a way to create complex formulas, save them (similar to the Beast Mode Manager…