Ask SQL DataFlow questions and get answers from Domo peers
Hi Team, The formula below is validating but it is showing "NaN" for all CPM values. For context estimated_youtube_ad revenue and ad_impressions may include the following values: 0, Null values, integers greater than 0. Any potential way to fix this? Thank you in advance! Select* ,…
I'm writing the following formula and it's not distinguishing between the dates correctly. What am I doing wrong? case when `Parent OR AgencyName` = 'Aspire Home Healthcare' and `Date` >= '10/23/2024' then `Total referrals` = 0 ELSE `Total referrals` end Note, my date shows as the little calendar and 'Total referrals'…
I have dataflow that gets failed when it tries to completely run a dataflow that runs more than a day. Is there any solution. can the dataflow can run more than a day. Can anyone help me with this problem?
Hi, I am trying to split a string and I cannot find which method to Use. Ive tried the substring_index method and the split_string Method and both have failed. I am trying to extract the city name out of a string that looks like this "CARROLLTON,TX/" Thank you
Hi, I am running into a problem with my visual I want to filter out any SKUs with a future mail date but since each SKU has multiple mail dates it is not recognizing the future ones it is going off the first mail date it sees. For example, the calculated field I have created is this "CASE WHEN MailDate > CURRENT_DATE()…
Hello, I have a sales pivot table that I want to highlight when sales are decreasing. Is there a way to highlight a cell if it is less than the previous cell (basically if cells are decreasing month to month?)
I created a dataset with the following SQL query 6/1/24, and on 8/8/24 I began getting the following error: The dataset is currently locked and cannot be executed right now. The likely cause is the Job is open in the UI or has unsaved changes. I have confirmed that the job is not open in the UI and has no unsaved changes,…
Grateful for any guidance. I'm seeing the syntax error below and I can't figure out why. New to MySQL Transforms as my previously relied upon python scripts are to be deprecated. Objective To take a single column of dates and turn them into column headers. Once pivoted, row value(s) are irrelevant (they'll be overwritten…
I have created a job in the Domo workbench with the following SQL query, but in my resulting dataset, "Transaction_Date" and "Transaction_Time" are not splitting into two columns, one with just the date (2021-09-02) and the other just the time (01:00:21.000)….I am still getting both (2021-09-02 01:00:21.000). I have also…
There are multiple lines (column titled: PO Number, one on each line) for a given item number in my data. I want to combine all of the results for PO Number so they appear on one line, separated by a comma (shown at the bottom). Item Number PO Number 63631 235084 63631 231656 63631 227775 63631 235084 63631 231656 63631…
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