Ask Magic ETL questions and get answers from Domo peers
I currently have an ETL that my team created yesterday, and it is partitioning data as of yesterday so there is currently 2 days of data in the data set. Is it possible to add historical data to a newly partitioned data set? Or is it possible to have the ETL partition off of a historical start date?
Say my raw dataset looks like this: And I would like to unpivot any column that has a month name is it, so in this example, it's 'Jan 2024 Total Pts Earned' and 'Jan 2024 Pts Redeemed', and the dataset would look like this (add a date column, total pts earned and total pts redeemed column): How can I do this with Magic…
Hello, I am trying to append a 8 datasets together and add a new column to the resulting output that is the source dataset for that row. That column is obviously not present in the original dataset. I just need to know where the data for that row originated so I can filter if needed. I have tried a few things but cannot…
Has anyone started to switch their recursive dataflows to use the new Upsert function? Are you still planning to build recursive dataflows? I have a few but going back and fourth on if switching is worth it/is it best practice?
Hi, new to domo and in particular beastmode, hoping someone can help. I have a KPI dashboard consisting of 30 plus customers and i want to find out the percentage of overall customers that meet or overachieve their KPI attainment each month. For example, if I have 10 customers and 5 meet or overachieve kpi then I'd like to…
Hi All, I'm working on identifying and tagging orders that already expired given a particular period. Our dataset captures data from active orders based on contract end dates. What I am having issues on is being able to tag the orders as expired because those are no longer being captured by the dataset. Any thoughts?…
Hi, so I have a beast mode calculation in one of my datasets that looks like this: CASE WHEN SUM(SUM(1)) OVER (PARTITION BY TRACK: Title,LIBRARY: Name,TRACK: Version) > 1 and TRACK: Version = 'Full Mix' THEN 'YES' WHEN TRACK: Version <> 'Full Mix' THEN null else 'NO' end The purpose is to make sure that there aren't…
I have implemented some conditional formatting using this code in an HTML table: $(myTable).DataTable({ data: reorderedData, lengthMenu: itemsPerPageOptions, columns: colNames, createdRow: function(row, data, dataIndex) { var daysOld = data[0]; // Correctly reference the first column if (daysOld == 1) {…
Hello Team, I am trying to do a ETL in domo but unable to get desired result please suggest. In my input, i have a few columns, the lowest grain in Employee id, I have a column called Value, In this values are given using delimiter "|". In my below example there are 2 instances on "|" but in my data it can come any no. of…
I have a simple card with a Table on it where one column that has a HTML link created with a concat function. The link is to call an Azure API and I'm trying to modify the link so that it will call the API silently instead of opening a new tab each time. I was able to play with an HTML brick and get a Javascript onclick…
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 DomoAI and get answers 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