-
Combine multiple distinct rows values in one cell
Hi, I am trying to combine the distinct value from multiple rows in a column with Beast mode. Here is an example of my file: Field AField BFieldCA1111A2222A3333A4333B5111B6444C7555 I would like to have: Field AField BA111, 222, 333B111, 444C555 In this case I have a concat but I would also need to do a distinct sum…
-
Remove duplicate unknown comma separated values within a single 'cell'
Hello good people of Domo Very frustrated trying to remove duplicates WITHIN a comma seperated list. I have the following webform: If I 'Group By' (Magic ETL) by 'Who' & 'Manufacturer' (combining 'Model' & 'Colour' with commas) I get the below. This has repeats in R5:C3 (2x 'TT'), R6:C3 (2x V70) and 'Black' is repeated in…
-
Magic ETL column parsing
Is there an easy way using Magic ETL to create new columns based on existing columns. For example I have an ID column and a Page Name column and want to make each ID and Page Name a net new column to link to other data in the dataset. (I'm using governance Page data) Any ideas here?
-
Duplicate value handling in ETL
I have a column where there are around 34 values that are duplicated for one line that is supposed to be for two people. See picture for example. Ideally it'd be great to have one formula that can distinguish where the break would be so I don't have to manually create 34 lines of code, and have to continually add lines…
-
Trying to Count Instances within certain date range where 1 field is the same
Hello! I am trying to replicate an excel formula to determine the number of times a caller calls within 4 days, 3 days, 2 days, and 1 day. I would like to create a field for each of these time windows. If someone calls 6 times within 4 days, I would like the 6th call to have the number 5 in it in the "4 day window" flag.…
-
Identify percentile within a grouping
Hello all, I have a dataset with 3 columns: Parent Company, Child Company, and Total Sales. I was asked to identify the bottom 10% by rank of the child companies for each parent company and calculate the average total sales at that percentile. This discussion gives some insight on how to start. I used Rank and Window to…
-
STR to Date
Hi, I have a ETL formula tile That I am passing a str through and turning it into a date using this formula STR_TO_DATE(Get Fiscal Months, '%Y-%m-%d') however its coming out as NOV 1st 2023 12:00am. Is there a way to get rid of the 12 AM? Thanks in advance!
-
Creating a New column
Hi, I am trying to figure out the easiest way to create a new column. The new column would be taking dates and assigning them to a month. For example the values assigned to NOV 2023 would be between Oct 27th(3 working days (excluding weekends) of the last month to Nov 27th (3 working days before the last day of the month.…
-
How do I create new categories in beast mode?
I’m not talking about a case statement per say that forms categories based on parameters. I need to list 3 categories in a beast mode that then I can use to create a filter card that will then remove/add these metrics to cards. For example; ’Conversion %’ ’AOV’ ’Net Sales’
-
Combine [unique] strings separated by comma
Hi all Anyone know if this is on the horizon? Combining unique values in a comma separated string. Anyone know? The issue is mapped out in the 4 year old post I've linked to below. Thanks
-
Concatenate in Magic ETL
i have data like this : And with magic ETL want to concatenate contents of column C for same values in Column A. Desired result: Result with Group by's concatenate
-
Microsoft Exchange Connector
Hi, Upon connecting my Domo instance to Microsoft exchange ( In order to track # of emails around the corporation) I can only see the Microsoft account that's logged in through Domo, I want to be able to see all accounts from 1 connector. Is this at all possible or does anyone have any experience with the connector. Thanks…
-
DOMO Date Format
Hi all, Is it possible to format date to just month and year. Currently when grouping together time series data I use the 1st day of the month e.g. all data in November would be under 01/11/XXXX — I wanted to know if it is possible to have columns in a date format that is Nov XXXX. When I group like this in a view it…
-
can someone please help me for this question of magic etl
Magic ETL Activity Using the DataSet in Domo you created using Workbench in the previous activity, 1. Use Magic ETL to parse the currency code from the "Transaction Amount" column and separate the amount and the currency code into separate columns. Submit: A screenshot of the output of the data showing the different…
-
Reverting Back to the old dataset version
Can I revert back to the old version of a dataset and retrieve the lost rows?
-
Adding new Historical Data to an Already Existing Recursive Dataflow
I am looking for a way to add historical data into my already existing recursive dataflow. My two input datasets are 1.) an email connector that uploads once a day, 2.) a copy of my output dataset as an input dataset acting as my historical records. My output dataset has data from 2021-2023 but I would like to add data…
-
case when field is blank write something else display value
Have a field settlementID, I'm wanting to display when there isn't a value for that row to show pending else show the settlement id something like when settlementID is blank then 'Pending' else settlementID thank you
-
Running Total
Hi, I have a question related to keeping a running total and then moving that running total to a new column called 'Most consecutive days' and I am not sure if I need to do this in a beast mode or MagicETL Is there a way to, for example, product A sold for 10 days in a row, didnt sell a day then sold for 3 days in a row…
-
window function
I have the following table and i would like to understand how to get the difference between dates: id | status | date 1 | disconnect | april 4 1 | reconnect | april 7 2 | disconnect | june 4 I would like to understand the average days that persons reconnect in the entire dataset. Can a partition function work here? The…
-
Y/N Function
I have a month goal, how do i write a Beast mode that showcase if a month or date goal is met? Below is the code I am using to showcase the goals of each month
-
Month and Actual Goal
Hello all looking to make a case statement, I could be using the wrong one. I want to have a Beast mode that states when a specific month then it states what the goal is, picture below. Thank you in advance
-
Description of the changes made to every version of Magic ELT Dataflow
Is there a way to see a description of the changes made to every version of Magic ELT Dataflow? When I check DATA>VERSIONS, I don't see anything under the description.
-
Ordering Forecasting based on historic order quantity and marketing Calender
Scenario is as below Got order table which has got historic data about order quantity on each day for last 2 years. 3 columns, Date, Period Type (e.g. Normal, Christmas, Stocktaking sale, Mother's Day, etc.) and Order Quantity for each day Got Period type for next 1 year assigned to different dates. Want to forecast order…
-
Beast mode to filter out certain ID field then sum the remaining IDs 'value'
Hi - I am trying to remove certain IDs from a column then sum their values but can't get the syntax correct. Here is what I've gotten to but doesn't work. Problem with adding a filter is the removed values need to be in another line on the chart. Case When sum('value') - (when ID='Liability' Then sum('value')) End or Case…
-
Include Data for a specific date range
Hello - newbie here - I need to know how to only include data that falls within my defined start and end dates columns. There are multiple flight dates, so I need to be able to bucket the daily delivery data within those defined dates. It just pulls in all of the data for each flight and I cannot seem to get it to work. I…
-
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.…
-
Rank and Window: Unbounded following
Hello, Is there an equivalent way to count rows in a partition with unbounded preceding and unbounded following? I see that "unbounded" is available in the 'preceding' option but not in the 'following'. I simply want to count all the rows within the specified partition and reflect to the respective rows, but the step 4…
-
How to bring certain data from one Table to another Table
Hello All, I am trying to find out an alternative of Vlookup kind of scenario in Domo. I have 2 tables - Employee Headcount Country Mapping Employee Headcount Table contains all employee related demographys such as ID, DOJ, DOB, Country, etc. But it does not have Region and Sub-Region data in it. For that purpose I have a…
-
Monthly Bookings vs Quota Chart
I am using data pulled from Salesforce, but I want to show the bookings per month compared to the goal per month (essentially a chart using a scale marker that changes) The issue is that the goal is different every month. Is there a way to automatically build this in using Beastmode or a new DataFlow?
-
Can there be multiple "THEN" statements?
Here is my formula that is currently working! (CASE WHEN SKULabs Cost >= 25 AND SKULabs Cost<= 50 AND line_items_product_id THEN '25-50 Bucket' ELSE 'not 25-50' END ) I'd like to add at 'Qty On Hand' > 1 in this formula but I'm unsure of where / or if there can be 2 "THEN" statements. I'd like to be able to subtotal my…