Formulas
Discussion List
-
Issue with Sales Data Tracking and Date TransformationHello, I'm encountering an issue with tracking sales data in from our CRM. The problem arises from…
-
SQL formula not working?I have a series of tests that run to determine a pass or fail. All the formulas work but this one i…
-
Value from yesterdayHi guys, Im trying to pull in the value from yesterday to fit into a broader formula. The value is …
-
Please help me write this filter formula:How can I write a filter formula where I want to exclude everything that says 'INTERCOMPANY' from '…
-
I wanted to rename few items in a column based on this campaign, in the ETLHi, I wanted to rename App to Web for this campaign, and I tried using a formula to achieve this i…
-
ETL error: "failed to convert value 'Infinity' from type 'Floating Decimal' to type 'Fixed Decimal'"Hi, I have a magic ETL dataflow. It has 2 input sources. There's a formula tile where we calculate …
-
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…
-
Creating a Pass/Fail Test in Magic ETLI am trying to create a pass/fail test in magic ETL. There are four test it needs to go through t…
-
Why is a field not allowing me to exclude it?I recently built a new field for my dataset in Excel that added certain employees into specific gro…
-
5Allow Window Functions in MagicETL Formula TileIt would be helpful to be able to write MagicETL formulas using window functions, similar to in bea…
-
Form Builder and Form Viewer TransformationI am trying to use submissions we get from forms in DOMO via form viewer/builder apps and turn them…
-
Case Statement helpI have an ETL with several joins and calculations. My final output is good except for this last pie…
-
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…
-
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…
-
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…
-
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 …
-
Using RegEx to Extract DateHi all! I am looking for advice on extracting a Maturity Date from a column containing a string of …
-
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…
-
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…
-
Magic ETL formula HelpHi All, I am trying to use the following transformation for joining but I am getting an error...Can…