Ask SQL DataFlow questions and get answers from Domo peers
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…
I want to convert a char value to number using TO_NUMBER function in Adrenaline Dataflow. The KB is given as below. What is the string pattern to be provided in the function to avoid decimals ? TO_NUMBER(STRING, STRING pattern) Converts a string into a number. An optional pattern can be passed in. If the pattern doesn't…
I have a really quick simple question I am using the field "item Number" but I need to omit any Item Numbers that contain the characters "A, B, C, P" I tried using the filter tool on the analyzer and used the Match Values option set that to does not contain "A, B, C, P" but that doesn't seem to work Here is the screenshot…
Hi I am trying to get the first letter in the product number field. I have created a test field to remove any extra white spaces the product number field would come with and here is the calculation: TRIM(ProductNumber) Next I am trying to use the Left function to get the first letter from that test field without any extra…
My first post so apologies if I have dropped this in the wrong forum. I have a slightly more complex dataflow than Magic ETL will handle and I am hoping I can manage this with SQL, however my SQL is a little rusty (read metal falling apart). The requirement is possibly quite common in that I need to measure how many…
I have a dashboard which has filters by semester term and college. There is a column for type of housing and a metric in the dashboard. The metric should display upon the filter on college as a whole as it is constant across all terms . However, it displays only upon filtering the terms, as the data is present across rows…
I'm a DOMO Admin and there is a DOMO dataset view that I can't edit - I'm getting the message 'you don't have access to edit this view'. The person who created this dataset also gets this message - nobody can edit this view. I created a copy and can edit that view but I need to understand why this message is appearing and…
I am trying to make a scorecard for budget…etc… Let's say our budget in Jan was $14,418,053 and are actuals were below that. How could I turn that budget red? and vice versa if actuals were above budget it would be green? Is this possible in DOMO yet or are there work arounds. Thanks, Garrett
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