-
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…
-
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…
-
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…
-
Removing duplicates
Hi, I need help coming up with logic for this problem. I have a dataset that looks like this: ID Source 1 A 1 A 1 B 1 B 2 A 3 B I want to only remove rows from source A IF that same row is also in source B. Otherwise I want to keep rows unique to source A and unique to source B. The output should look like this: ID Source…
-
Dynamic Pivot
I have a table with a combination of fields and a target value. I want to concat all the fields (Retailer, Field, Target, Strategic Priority) and pivot the table so they are all columns with their respective Target Value underneath. I know how to do this with the Pivot option in which I manually create a new column for…
-
Historical Trend
We have sales data that is just a list of sales opportunities like so Opportunity → Create Date, Close Date, Amount We have all opportunities (open and closed) but we only have the current status of the Opportunity. Can i build a historical trend from this simple data set, so I can see what the total opportunity amount was…
-
Multiple Split Columns
Hey, so i need to split numerous times within a column of data. i'm on the split column tile now, but i don't want to enter 100 new columns to create for each split. is there an easier way to split all of the data in the 'tags' column?
-
Comparing one month's EOM data to previous month EOM data in same row
Hi, I need to do a calculation so I can subtract previous months hours (4/31/2023) data from this month's hours (5/31/2023) data. This is how data is organized. This just a small example of how it is. Without changing the structure of dataset how can i get all the 4/31 data on the same row as the 5/31 data? I have been…
-
How do I alter Date (in Text format : 01.09.2023) to Date format?
How do I alter Date (in Text format : 01.09.2023) to Date format? I need it to be in a Date format such as 2023-09-01 instead of 01.09.2023
-
Date format Changes
Hi @GrantSmith , This is the date format I have in the dataset : I wanted to remove the C and have it in text to alter it as Date : Thus I used this formula on the formula tile (RIGHT(Date, 10)) and got it in : However I tried using the Alter tile and Formula tile (STR_TO_DATE(Date, '%Y-%m-%d')) which did not work, giving…
-
Add a condition on line plot to toggle between AVG and SUM conditions
Hi, I have a column in my data 'Volumes' and I am using that as Y-axis of line chart which is currently set to aggregate as SUM(Volumes). I have a problem with it where I want it to perform AVG(Volumes) when one condition is met and perform SUM rest of the times. I am trying to perform this logic using calculated field,…
-
I need to convert a text column to date in ETL
and I am not sure how to do this, I have attached a screenshot of my text date