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.
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…
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…
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…
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…
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…
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?
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…
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…
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…
It looks like you're new here. Sign in or register to get started.