Ask Magic ETL questions and get answers from Domo peers
Hi Domo Masters - so, when we want to capture the current date what we do is we use>>> Case When 'Date'=Curdate() then 'True' else 'False' end is there a way we can capture the current quarter? Thanks!!!
I have an ETL that uses, among other inputs, a Webform that isn't always maintained perfectly. One recent problem involved two rows for the same identifier, with different text in the description column. What I'd like to do is make the ETL fail if something like this happens. I tried doing a Group By on the identifier…
I'm using the case statement below to identify dates from "Last Week". It works fine but I will run into a problem in January as we move to week 0 or 1 for current week, and last week could be 52 or 53 (see screen grab). Any suggestions for approaching this? CASE WHEN WEEK(`Date`) = (WEEK(CURRENT_DATE())-1) THEN 'Last…
Hello there. I have a Jira connector set up that pulls users (Name, Email, Jira ID). However, it only pulls currently active. One of the dashboards I am creating needs this data, but we also need to keep users who leave. My thought was to export the data today, then import as a data file. Then, starting tomorrow, append…
Hi, For this particular use case I have data like below Date | Value I need to transform this to Date | Value | Date LY | Value LY I could join the source data up like this to itself when pulling the data into domo via SQL but would rather do this in domo. I attempted to use the period over period dimension stuff made by…
I am working with the domo writeback to gsheets. It is scheduled to run each day at a specific time which I set up when I first set up the writeback into my ETL. Now I need to change that schedule so I go to the dataset details then the 'Settings' and 'Scheduling' and make a change. However, when I click SAVE - nothing…
Hello team, columns A and B are the occurrences in date format of two separate events. I have three columns. People, Date A and Date B. I'd like to be able to have a single date filter and out put the count of A and count of B for each person in that date timeframe. I appreciate any suggestions!
Hi Team, Do we have option to freeze header in pivottable (chart table) as i could not find in chart properties pls suggest
The default week() function extracts the week number from the start of the year and runs 1 to 53 or 54. I need to show week number within the quarter, running 1 to 13 or 14 within each qtr. Is there a way to do this using beast mode or using the formula tile in Magic ETL ? 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