Ask Magic ETL questions and get answers from Domo peers
I've been asked to build out a card that shows employee count by month, this seems easy enough until you try and factor in the termination date. What is expected is to show in each month the total active employees, so if employee A is hired on Jan 1st and terminated Feb 15th he would show as a count of 1 in January and a…
I have a dataset that shows details from received Purchase Orders (inventory) that our company buys. If for instance a user sets up a date filter on this data, we also want to show the received purchase orders for the same vendor for the receipts starting 365 days prior to the Start date of the Date filter on the…
Any help on this would be appreciated, I can't seem to get rid of this error and I'm not sure what I'm doing wrong or what I need to check. I'm duplicating an ETL we currently use for a similar dataset, but this dataset is separated by day, rather than month.
Usually I use PDP giving access to some areas, but for exceptions I can not just give access to everything, like Employees of Area A but not access to a specific employee out of 300 is posible to use a not in for a PDP?
Hello All, I'm struggling here as I feel like I'm so close. I'm trying to show a summary number that is a calculation (Cost/Leads) and while I've been able to figure out the font size and color, I am still struggling to control the format to be a currency without decimals instead of the number its at now Right now, I've…
I have a dataset that contains IDs and meta data to include modification dates. Each ID has a last modification date. However, each ID may (or may not) be associated with other IDs. I want to identify the latest modification date (direct or associated) for each ID. Below is an illustration of what it looks like, except…
I have a few columns which use the date format 01/Jan/2016, I need to convert these to 'Date' to use as date ranges in metrics. I have tried using the 'replace' text card in an ETL to change the forward slashes and months to numbers. This works on some rows but not all (trying to figure out why). Then I change the data…
Hello everyone, I am working on comparing data from a previous data input, Universal Analytics, to a new one, Google Analytics 4. Basically, there was an update and data is formatted differently. I am attempting to join the two datasets to compare the month of A ugust for variances, but the closest thing to a unique column…
I am using a connector to pull data in from one of our web analytics platforms. The problem is that it pulls in a 'Total' row which I can not suppress at the source. Using an ETL how do I remove that row? I've tried to use the Filter Row tile but perhaps I am doing something wrong there because I have not been able to…
Table A has transactions that show an item's "Old Status" and "New Status" along with the date of the transaction. For example, row 1 shows that item XYZ changed from "Regular Price" to "Promo Price" on 1/1/2023. Row 2 shows that item XYZ changed from "Promo Price" to "Regular Price" on 1/4/2023. Row 3 shows that item XYZ…
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