Ask Magic ETL questions and get answers from Domo peers
I have a dataflow that is joining multiple datasets with information about a set of schools - 29 elementary schools and 3 high schools. One of the data sets is specific to tests scores that only the elementary schools take, so the high school rows are "null." This dataflow that I am creating aims to generate separate…
Trying to see if there is a way to achieve this. I have a column that has something like the left column here Is there a way to achieve the right side column by looking at maybe the number of commas + 1 maybe? Doing this in ETL formula tile would be best for me if possible
I built a dashboard before I realized I needed to make a bunch for the entire department, and so I wanted to create a nesting in the dashboard management, but from my testing and efforts, I can only reorder them, not drop them into a different sub-dash area . Is there a way to align them, like Parent Dashboard = xxxxxx ?
Is there a built-in way for us to take a user to the data that they drill down to, and in my case, using the Case Safe Opportunity ID field, have it be clickable to launch them into SFDC to view the opportunity/account details?
Hi all, I am brand new and trying to swim in the deep end and don't have knowledge of SQL so struggling with how to write a case/formula for one of my ETL transformations. I want to create a column with a constant based on values in a column, essentially: If the value of column A equals ONEY or CMDU than 45, if not than 30…
I'm looking to combine data from 6 sources into one pie chart. All data will be coming from Pipedrive but each dataset uses different filters. I have setup an ETL which goes through each filter, I'm stuck on working out how to combine the data into two columns (stage and number of panels). Is there an optimal way to…
Hello - Can I create a calendar table based of a start date and end date? I have the start date and end date that encompassed a week, and then the columns for sunday to saturday what I am trying to achieve is, to put dates as well to the columns for sunday to saturday for example: the start date is 9/4 and end date is 9/10…
I have a dataset with item receipt dates by branch. I need to find the most recent receiving event for each item by branch. The dataset has about 7M rows, and my thought was to do a dataset view, rank the receipts by branch & item descending on the receipt date. I can't seem to get the calculated column to work. Any help…
I'm trying to find the min. the value between column 1 and a range of numbers in different columns. For example, is the difference between column 1 and column 2 less than the value between columns 1 and 3? Any suggestions on how to do this?
I used the Lag function to operate a subtraction between data point and previous data point. However now I need now the average for that new column (which I am not able to do in Beast Mode) Any suggestions
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