-
SQL Tile - not able to reference CTE name in itself when using recursion
I am trying to do a fairly simple recursion cte to navigate an employee hierarchy and assign an integer "level" to each employee based on their place in the org. I am using a SQL tile in a Magic ETL. I am getting an error from Domo "Table Not Found: hierarchytable". This I believe is referencing the FROM hierarchytable as…
-
Storing Form Responses Based on Dropdown Selection in App Studio
Hi, I have an App Studio app with dropdown filters. I want to build a form within it that is specific to each dropdown selection. When an individual fills out the form after selecting a dropdown option, the form results should be stored along with the selected dropdown value. How can I achieve this?
-
Email Connector CSV format vs CSV UTF-8
Hello, I download an Excel file from a supplier portal and email it to a DOMO email connector. By default the format is CSV however I find I have to save the file as CSV UTF-8 otherwise DOMO does not ingest all the rows (roughly 17% of the total rows is ingested if I do not change the file format). I have attempted to…
-
Can "Total Row" sum the column contents when those columns are using aggregation = Average
I have 5 columns where I am using aggregation = Average, and when I include "Total Row", the total values are also averages. Is there a way to change the "Total Row" settings so that those columns are summed, not averaged?
-
Identify a duplicate
Is there a way to create a column that can help identify a duplicate from another column? Below is a list of loan ids that we have and some of them have coborrowers but some dont. I dont need to remove the duplicates but I would like to create a new column that can identify quickly which one is a coborrower. Is there a…
-
Magic ETL flow failed while executing with "Failed to index Dataset " error
Hi, I am facing below error while executing magic ETL flow in Domo. Failed while executing "Failed to index DataSet '3a922bde-7139-42c1-96c3-88d7516a1fa7' " All tiles were executed successfully, but output dataset is not created. I used "upsert" as update method for creating output Dataset. Could you please suggest to…
-
Export Data Option - Exports WITH Selected Filters
Currently if you are filtering on a dataset and want to export the dataset based on the filters, I don't believe this is not possible unless you create a card with filters or an ETL. I would like the option to export the data with the filters applied on the dataset view.
-
AppDB Query giving inconsistent results
My AppDB query gives the correct result first time when I search a document but the very next query for that same document results nothing. And every subsequent query for that document results nothing. This is a pattern every time I try searching a different document in AppDB. //check if the document already exist const…
-
Combine Two Transforms in MySQL
Hello, do you know what to type in Output DatasSets to have transform_data_1 as column 1 and transform_data_2 as column 2?
-
Update Domo's version of R
Right now, Domo uses R 4.1 in Jupyter and in the data science tiles. That version is over 4 years old and increasingly is not supported by packages, making it harder to use common packages in Domo. Please update to 4.5.
-
Collapse the bottom section of the Formula Editor window to gain more room in the actual editor
In the Magic ETL Formula Editor window, I would estimate that 95% of the time I don't need any of the bottom three sections: Columns, Functions, and Function Descriptions. With them in place (highlighted in red), and the new AI prompt box which appeared today (highlighted in green), I am only able to see four lines in the…
-
I need to convert the following beast mode to Group by
SUM(served) OVER (PARTITION BY Physical County,CABINET) / Sum(Passed) OVER (PARTITION BY Physical County,CABINET )*100
-
Meta Product Insights Alpha+ report in Domo
Hi, I recently received a question from our team on whether we can access the new Meta Product Insights Alpha+ report using one of our API connector settings (Facebook Ads Connector). I couldn't find any articles regarding this, but does anyone know if this is a possible report to pull in Domo?
-
Dataset Tags in Workflows Not accessible
Hi Team, How do I access the 'tags' variable from the Get Metadata function output in Workflows. The option isn't included in the children: however in code engine this is available: Any thoughts please let me know.
-
Hi, how do I create a task in a project using an alert, I have tried it and it's not working for me
-
Send email to people who I have shared the App with
I made some changes to an App, I want to send email about those changes to people whom I have shared the App with. I haven't used workflow before and it seems very confusing. So I couple of question: How do I get a list of people whom I've shared the App with?
-
Turn Off "Error Loading Data to .... " Alert?
Hi Team, I hope all is well. Is there a bulk method for turning off data loading alerts for datasets based on a criteria (e.g name has Archived in it) All help appreciated.
-
Could not Load Data for [Archived]ThisDatasetDoesNotNeedAnAlert
Please can we have the option to bulk remove the default alerts related to Loading Errors. After archiving thousands of datasets we're hit with these errors daily. Thanks
-
Multi Levels Sankey
I'd like to make a revenue sankey chart like this, is it possible in DOMO?
-
Can I generate a Data Set in DOMO that consists of my data/settings in DOMO?
Problem to solve: We have Primary dashboards in our DOMO that I want to populate with data showing the following scenarios: Profile pictures/info of users in Domo by team A list of "custom" reports we produce for customers A list or display of "custom" apps we produce and embed I've found a data set that uses DOMO…
-
Walkthrough: Embedding cards with filtering in a .NET web app
If you have struggled embedding a card using Domo Everywhere into a .NET web app, I have created a video that walks you through it. Below is the code that would need to go into your project that I cover in the video. Hopefully you find this helpful. Visual Studio Solution in zip file
-
Moved: Walkthrough: Embedding cards with filtering in a .NET web app
This discussion has been moved.
-
Troubleshooting for Unable to retrieve data error
I want to create a datasetview using some datasources in redshift. However, I frequently facing unable to retrieve data error message while preparing the data. It really being a bottleneck to get my job done. For context, I want to perform simple inner join between Table A and Table B. Table A contains 120 million rows and…
-
App Studio share a specific page with a person or user not the entire app
Share specific pages with a group not the entire app because some of the information may be confidential but you like it to remain in the App on its own page especially if running meeting through DOMO
-
auto subscribe to an alert
hi, has anyone created a workflow that would auto subscribe a person to an alert. The idea is to subscribe people to alerts or multiple alerts, based on what dashboards they have access to. Thanks
-
Folder for Organizing Apps in App Studio
In App Studio, having a folder to group multiple apps from a single client would improve accessibility. This would make it easier to manage, navigate and find apps efficiently.
-
Domo Apps Home Page: Organization
Currently the only way to organize your App Studio apps is by changing their title, thereby alphabetizing them, or favoriting them. The title is truncated, so even that option is limited. Some additional organization/navigation tools would be helpful: Tags Folders Descriptions List view
-
Adding Visible Descriptions/Tags for Apps in Apps Studio
Hi Domo Product Team Our team leverages the Apps in App Studio and Domo Everywhere heavily in our customer deployment. We build Apps in App Studio which are then deploy to our customer instances via Domo Everywhere publication. Presently there is no way to add any sorts of descriptions or tags for each Apps which are being…
-
Domo App Studio Home Page
It would be nice to have the ability to arrange apps and/or group apps in folders or sections, on the page. Have them list in alphabetical is limiting.
-
Being able to edit "Home" Button on Apps
The current Home button can be confusing for clients as it implies it will take them to the central app page that connects the other pages. I wish we have the ability to change the icon and name of the Home button, such as "Exit App" with an exit icon. While it seems like a minor issue, I can foresee the confusion of new…