Ask Magic ETL questions and get answers from Domo peers
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…
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?
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? I need it to be in a Date format such as 2023-09-01 instead of 01.09.2023
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…
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,…
It looks like you're new here. Sign in or register to get started.
Have a Domo product enhancement idea? Submit or upvote on ideas in the Ideas Exchange.
Ask questions about Connectors, Workbench, Cloud Amplifier and get best practices from Domo peers
Ask questions about Magic ETL, SQL DataFlows, DataFusion, Dataset Views and get best practices from Domo peers
Ask questions about Beast Mode, Cards, Charting, Dashboards, Stories, Variables and get best practices from Domo peers
Ask questions about App Framework, Workflows, Domo Bricks, Domo Developer, API and get best practices from Domo peers
Ask questions about Jupyter Workspaces, R & Python Tiles, AutoML and get best practices from Domo peers
Ask questions about Domo Everywhere, Scheduled Reports, Mobile and get best practices from Domo peers
Ask questions about Governance Administration, Approvals, Teams, Alerts, and Buzz and get best practices from Domo peers
Watch how our Customers are using Domo to solve their complex problems.
Domo support and product teams are here to live-answer questions about the most recent product releases. Please post questions in this Forum board for all users to benefit (rather than submitting a support ticket).
Questions or discussions related to Domo University, trainings and certifications