Ask Magic ETL questions and get answers from Domo peers
Hello All, I am trying to find a better way to code this because I think the calculation may be faltering somehow. Alpha calculation is just a sum of amounts Beta calculation is just case pulling numbers from different fields. Mas field- what I am trying to achieve is simply to divide Alpha by Beta It seems to work somehow…
I have a client whose week starts on Monday. since the default week start day in Domo is Sunday, I would like to use beastmode to calculate week numbers with a start day of monday. I get a validation error every time I try to input a number in the [mode] portion of WEEK(date,[mode]). I'm referencing MySQL 5.5 documentation…
How do I use the name of an already calculated field or beast mode in another calculation. I learnt this nested ability was done last year. We are able to use the PDP new update but can't seem to get the nested beast mode to work. Exam: A=b+c B=d+e Why can't I write another beast mode F= A/B ? rather I have to write it as…
How to alter a column that is in text and cast data type as integer or floating decimal? I get this error when using the Alter Columns tile: 'Failed to parse text ' ' from column 'Column A' as type 'Integer' How can I alter the columns data type in the magic ETL successfully?
Hi all I'm hoping you lovely people can help me sort the following out, please I have tens of thousands of rows of data which all repeat themselves (for boring reasons). There are 20+ columns but two are always a pair. I've used 'country' and 'value' here to demonstrate (see table below). All I would like to do is add up…
I have a dataset that includes line breaks in some cells. I was trying to use the "Replace Text" action, but I'm not sure how Domo is coding the breaks. '\n' and '<br>' did not work. In Domo, you can't visually see the line breaks, but as soon as I download the CSV and open in Excel, I can see them (screen shot attached).…
I'm trying to built a basic table card that only shows records where the Brand attribute is NULL. I know for a fact that there are records that meet this criteria in my data set, as shown in the image below. What's puzzling is that when I apply the filter, it doesn't return any records. The filter works as it should for…
I am trying to set up an ETL or logic where any time a new incidence happens, the clock resets. Problem statement would be - How many days can a company go without recording any incidences being recorded. Once the incidence happens, the days resets.
Hello, I started working on an ETL and then later made changes to a copy of it. I want to delete the original in order to keep the Domo instance clean (the completed task is in the copy). Will deleting the original cause any harm? Thanks in advance!
Hey, how would I create a last updated card on top of a dash? This way it gives the users the understanding of how up to date the cards below are, etc. How would i create that on the dataset to then even be able to apply to a card? Thanks!
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