Ask Magic ETL questions and get answers from Domo peers
I'd like to build a recursive dataflow, but capture data by month. Any idea how this can be solved?
Have a dataset that doesn't have a timestamp that is being imported via connector. Can I use the batch_last_run as the date to create the recursive dataflow?
Hello Domo Dojo Masters - Good Day! We have data from salesforce that only has a start of the week and end of the week date columns>>> How can I make it so that we can have a daily date?
Hi, I am new here! I have a dataset that has data on multiple rows for the same patient with different encounter dates. I want to only see the unique patient once (so patient ID is the identifier) and show me only the most recent encounter date. Example data: John Doe, Patient ID 1, encounter date 1/3/2022 John Doe,…
Hi, I have monthly data and have the data stacked with different period types i. Last year, 2021, 2020 and 2019. I can access these values by checking the period type in my beast modes. All good. For this use case I need to add a fixed 2019. So when I graph say 2021 through to 2023 each month looks back at 2019. e.g. I can…
Hello, Wondering if anyone has encountered an error like this before and know what it means? (other than that the action is thirsty)
I am trying to get a HC for each department from our labor hour reporting data. I was going to use a count function by employee name to be able to pull the number of workers for each department. The challenge is for example: Date Employee Department 10/12 Jon Fabrication 10/13 Jon Fabrication How would I eliminate the…
Good morning. Been running down the rabbit hole for a day or two on this and trying different solutions from previous Domo questions without much success. I have a sheet that has multiple entries for each equipment number and in the end I would like one row for each piece of equipment that is the most recent EVENTTIME.…
Hi everyone, can anyone give any tips for loading an excel file with approximately 250,000 rows of data (some files about 60K KB, i've uploaded larger file sizes before)? It's to a dataset that is set to append but every time I upload it and click "save", and it imports, I go to check via Explorer view and I dont see the…
Hi everyone, We have a dataset containing two columns Date, Id and Value. We are using the lag function to get the value from the previous financial year. i.e. lag(Date, 364) over (partition by Id order by Date) Wondering how we could use this to get the previous date the year before but matching on the date. So 1st Feb…
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