-
Is it possible to batch edit source data?
I have a large dataset that needs some cleaning. We have appended to this dataset daily over several years and some of the data values have drifted over time as users have renamed what are essentially labels for different entities. If this were SQL, I could write an update statement and quickly replace the values in label…
-
BEAST MODE CALCULATION ISSUE
Using the Beast Mode below I am being forced to use the ABS function in order for the Beast mode to give me a calculation. If I remove the ABS Function I get the error "An issue has occurred during processing. We are unable to complete the request at this time". The issue I have is I need to remove the ABS (Absolute Value…
-
Data Processing using Partition
Why I am having data loss issue when using data partition in Domo ETL?
-
Nested Case and Concat Statement
Hi, I am trying to figure out how to create an Etl that expresses: If a particular year has a result then concat that with another column's result. Something like: CONCAT(case WHEN 2015= 1 then '2015', '-', Virtual vs In-Person else '' end) 2015 has a 1/0 constant and I want the result to be if they attended in person (so…
-
how to combine mutiple rows into one separated by ','? Form builder muti selection data handling
I used form builder and there are couple fields are multisection dropdowns, in the response dataset, it separates the selections into different rows, but I want them to show as a,b,c together not a(next row), b(next row),c. Does anybody know how should I use the magic ETL to do that? I used my old way to transform the…
-
Trying to use Unpivot
I have a dataset. 1 order has 10 stages. each stage has a schedule date, completed date and status. 1 order has 1 row and 30 columns. I am trying to unpivot to 1 order having 10 rows and 6 columns. I used 3 different unpivot tiles for it. I built out the ETL but not sure why its taking forever to run.
-
Renaming Columns and NOT breaking cards
I am barely getting started with the vast DOMO world so forgive me if this is an obvious thing. I was recently creating a dataflow and some cards from that dataflow and decided to test something out. I created the card using a column from that dataflow and then proceeded to change the name of that column in the dataflow.…
-
ETL calculation to work out hours taken from a start and finish timestamp
Hi all and happy Monday I have some data i am pulling in via a SQL workbench that gives us a time clocked onto a job and another column for clocked off the job. The data is in a the format 2022-12-23T14:27:20. So i am trying to generate a calculated column that gives me the hours taken per job, for example: Clock on =…
-
Lag a pre-existing column?
Hi there, I'm wondering if it's possible (with Magic ETL or beast mode) to creation functions (like rank and window) that can lag value from Column 1 to Column 2, where both columns already exist. Full context: We have 3 columns. Monthly total, Last month, Year to date. I'm trying to generate a new YTD total every month by…
-
How do i fill in rows of data with previous row info?
This… into this via magic etl
-
When alter columns can't change column type, what else can I try?
-
Inline Line Editing Structure
Hello, I am trying to use inline editing to make changes to a dataset by labeling a line item 'YES' or 'NO'. The data I receive is replaced each morning (Some line items are updated, some are removed, some stay the same. ) Currently any changes I make today to the data will be erased the next morning. I have tried doing a…
-
How do we hide/merge duplicate cells in a column in HTML table
Hi Domo team and users, I am using an HTML table for my card, because I need to implement some cell specific conditional formatting (not shown in this screenshot) and only HTML Card works out for this. But while using this visual, there is no option to consolidate the repeating vales in a column. Any insights on this is…
-
How do I search for rows containing specific text and replace the information in that row?
I have a column in my ETL dataset that is named "City", in that column there are multiple city names however they have been put in in all different ways (ie: st george, St. George, ST George). I would like to search that column for rows containing 'george' and replace the information in that row with 'St. George'. I've…
-
Trying to convert Month of the Year into Date with Magic ETL
Basically the title. I am using a dataset that pulls Month of the Year instead of Date, as the User count with the Date metric isn't accurate. However I have run into issues trying to convert Month of the Year into a date format. Here is the original format: As you can see, each month is numbered from 1-12. I used Value…
-
Converting to Integer
Hi All, In my ETL I am loading 2 columns for Credit & Debit, as part of my ETL I want to do Credit-Debit to get a column for amount however the data being loaded is recognising the Credit & Debit as text. I've tried to use the alter columns tile in my ETL to convert to an integer however it doesn't appear to be working.…
-
Beastmode - Duration (mins) between 2 Datetime Columns
If I have 2 datetime columns (StartDate & EndDate), how do I find the duration (mins) between the 2 using Beastmode? Example:
-
Joining Weekly And Monthly Data In ETL
Hello, I have a data set that holds labor hours and wages for positions broken down by day of week. So for example, there are columns for Sunday through Saturday. Position 1 will have 0 hours in Sunday and Saturday columns and 8 hours in Monday through Friday columns. There is also a budgeted hourly wage. So what I can get…
-
Getting value of previous quarter and comparison
Hello Team, I have a date column named 'Fiscal quarter start date' and another Beast mode with calculated value for 'Customer Survey' I want to create a beast mode in which I will compare the Customer survey of the Current Quarter with the second last quarter. I tried to create a Case statement but unable to get results…
-
changing a column data type
Hello community, I have a column that has dates yet the data type for this column is showing as a 'text'. I've been looking everywhere, but I don't see any options that would allow me to change the data type for this column. Where can I find the menu to change a columns data type? Is this even possible in domo? Thank you!
-
Mass Alias Column Names
I have a dataset with a few hundred columns to alias. Is there a relatively painless way to do this without using the select or alter tile?
-
Syntax of ANOVAF(), ANOVAP() and TTEST()
These functions are supported in the Fx Tile in Magic. Does anyone have some syntax examples ? The function requires an aggregation context suggesting a group by action
-
Moved: Can I copy beast modes from one ETL to another without changing the names of them?
This discussion has been moved.
-
Date_Sub
Hi, I have two dates that are timestamps ex(dec 12, 2023 6:30:00 Am) I am trying to subtract the two dates to figure out how long a certain task took to complete. I am using date_sub and I am receiving this error, how would I fix this? "Calculation Error : Operator '-' cannot be applied to type 'Timestamp'."
-
Keep Columns After Using Group By Tile in ETL
I haven't played around with the group by tile yet so this might be a very simple answer I overlooked. But why do all of my columns disappear and leave only the columns I identified in the group by tile from my data after I use this function? I know I could join the data back in but I was assuming I was using it wrong.…
-
Run Recursive Dataflow only when new data comes
I am trying to create a recursive dataflow which should run only when new data comes. Here are the conditions for that, We are suppose to get weekly data in our CSV connector every Monday. We have set out recursive dataflow to run on Wednesday. We use week number as our constraint column. But sometimes, we get data late on…
-
Date Formatting in Tables/Charts
Hello, I am new to domo so hoping this is pretty basic to update. My date columns come in the following format "Jan 23, 2024" in my raw data. When I pick my date fields in any cards it only shows the year 2024. In some cases I will want columns or rows to be months or possibly days or weeks. How am I able to pull other…
-
Creating a marker and deduping in ETL
Hey guys, Hope you all are doing well. I have an issue with data transformation in the ETL. It is best described on the screenshot below. I have multiple entries for duplicate IDs (one row for each product) and want to mark all entries for a given ID that contain Product 'c' as 1. That's the formula I used below to…
-
Domo App and Group
I have an app created in the domo. I also have a Group created by my Org. I want to share the app to the group, but i am unable to search the group name. Is it possible to share the app to a group ?
-
Date Conversion
I need a formula for taking just the month name from this format - Thu, 29 Feb 2024 11:59 PM. I need it in a date formatted column though. I can take the Month Name using MONTHNAME('my date column') but i cant get the column to be date. Its always text. Any advice? Thanks