-
Final Summary- DP 2024 Product Features
For the second year in a row, we created a one pager which shows all the features released and even discussed at Domopalooza. In the past it has sometimes been understandably hard to remember if what you saw was GA or a sneak or something else. So we strive to be transparent so you have one place to check and remember.…
-
Allow sorting of quick filters
Currently, we have many academic years in some reports but usually need to sort by the newest. However, all the order academic years are at the top of the filter and we need to scroll down the filter to get the current year. Having the ability to sort this so the data currently on the bottom would be on the top would be…
-
Making the QTY value to multiple rows
Hello, I am trying to take the data below and make the 'ORDQTY' column multiple rows based on Columns C and T and U. How would I do this? The end goal would be for row 2 would have two identical rows since there are a quantity of 2. Row 7 would have 4 identical rows and so-on. I am trying to have 1 unique row based on…
-
Improvements to Headers in App Studio and Dashboards
I wish there were more customization for the Headers function in both AppStudio and Dashboards. Right now we are limited to a single horizontal line and I have a handful of use cases where I'd like to limit the width of the page so I can have multiple headers in a line (see example above). The ability to change the…
-
Please Help - Cant get pivot table working properly
I am having a problem with a formula. I am trying to display Yes for a facility if they have a task event status in Completed or CompleteLate status. If they have a task in any other task event status I want to Display No. In my pivot table in domo I am getting an error of multiple results encountered for same location. If…
-
ETL snap to grid
I like to keep very neat or orderly ETLs. Would love the ability to align ETL tiles horizontally or vertically or snap to grid or something. I think that would help keep a clean workstation.
-
App Studio PDPs
Is there a way to apply app specific PDPs that apply across all reports within an App? For example I want each user to only see their own data whenever entering the app, is there a way to apply this at the app level or do I need PDP datasets for every report?
-
Magic ETL Forecasting Tile
Hi, I have a dataset that I have grouped together into monthly data (using the LAST_DAY function in case it matters). Using magic ETL, I then add the forecasting tile to get a forecasted volume. I have actuals upto the end of May 2022, but the forecast model is only giving me forecast data starting in July 2022. Can…
-
How do I use window function date ranges in DOMO ETLs?
The short version, I need the following query to work somewhere in DOMO ETL: AVG(`Score`) OVER (PARTITION BY Company ORDER BY 'Date` RANGE BETWEEN INTERVAL '90' DAY PRECEDING AND INTERVAL '0' DAY FOLLOWING) More detail: I tried using group by but cannot use window functions, formulas but can't use aggregations, and rank…
-
Creating a Cumulative Concat Function on a Text Field
I currently have an ETL looking at distinct Opportunities by their close won day. However, this issue is now looking at Distinct accounts within the same dataset. At first, I thought to use the count distinct function on the account ID in a groupby. However, since multiple opps can be tied to one account and each one can…
-
Conditionally Starting a Dataflow
I have a dataflow that I only want to start when the data in a dataset materially changes. It seems like it runs no matter if the data changes or not. Any advice on this.
-
Text to Date Issue
Hey there! I am trying to alter a text into a date, but I keep getting the "failed to parse" warning. For context, I'm uploading a CSV file. Does anyone know a formula to fix this? I've tried multiple, but haven't had much luck. *I provided a screenshot of how the field looks in the CSV file prior to uploading into Domo.
-
What is the list of DOMO CLI dataset types
I'm trying to upload a dataset using DOMO CLI create-dataset command. I'm failing as I need to include a "-t, —type <TYPE>" I was unable to use a help command to get help with types. Does anyone know what types are available? Here is my command and error response: create-dataset -n sales_comm_plan20240327 -s…
-
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…
-
Text to Floating Decimal Issue
Hey there! So, I am trying to alter a text into a floating decimal but I keep getting the "failed to parse" warning. For context, I'm uploading a CSV file that already has the field I'm needing as a currency. But, when I upload into Domo it turns it into a text. I will be needing to aggregate (sum) this field so I need it…
-
Domo Feature Request: Allowing Users to Promote a Repository that contains locked beastmodes
We have many beastmodes that are locked on cards. Thus, only admins, beastmode owners, or those with "Manage All Cards and Pages" and "Manage DataSets" grants enabled. We are running into issue where users are unable to promote to our production environment because they don't fit into one of the three above categories. We…
-
Snowflake use cases
Hi everyone, currently we use Domo and have some data sources we collect from multiple businesses. Without going into much detail, does anyone here use SnowFlake and have it integrated into Domo? If so, or even if not, what are the benefits of using Snowflake along with Domo?
-
Bring power BI dashboards and data sets to Domo
I believe I heard during the Domopalooza that in the consumption model there is a way to bring all power BI data to Domo easily. We are thinking about migrating from Power BI to Domo. I found the writeback connector from Domo to Power BI article Can someone please confirm if I am correct about the Power BI and Domo…
-
Large Excel Dataset
I am trying to import 450 MB spreadsheet into Domo. But when it finishes importing there will be 0 Rows and 0 Columns. Is there any limitation on the file size ?
-
Brave - Official Supported Browsers
It would be of great help to consider Brave as an official supported browser for DOMO.
-
Pivot Table
I have data with plants and tasks. Each plant has a few daily tasks assigned to them. If the status of a task is complete or completelate the task complete column needs to be yes. If it is any other status I need No displayed. I need to aggregate at Plant level so unless all of the tasks meet Yes criteria I want No…
-
Using a Power BI dataset
Hello, Is there any way to import a dataset created in Power BI (via Power Query) into Domo as a dataset? For example, my organization uses a Data Warehouse (other than domo). The Finance group, which uses Power BI performs transformations on the data from the Data Warehouse. I would like to use the 'processed' datasets in…
-
Combining 2 cards? Trying to find out how to use advertised feature.
At the 1:15 mark of this ad, the user mentions combining two cards showing different but related data ending with an "overlay" of the 2 visuals at 1:50. But, it didn't go into the specifics of how it was done. Does anyone know what feature would allow this? As always, thank you in advance!
-
Best approach via Beast Mode - multiple if/case statements
Hi everyone, I have the below data example: Name Variety Benchmark Value Achieved Value Apple Red Apple Batch 23 3 4 Apple Red Apple Batch 22 N/A 4 Orange Batch 11 v1 3 4 Orange Batch 11 v2 5 3 Pear Batch 20 TVS 2 6 Pear Batch 24 LKT 4 1 Plum Batch 25 MBH N/A 7 Lemon Batch 2 N/A 5 Ideally I would like to use colors on a…
-
APP STUDIO Q&A from Domopalooza
The product team enjoyed answering questions from the audience during the final session at Domopalooza. Below you will find the answers to all questions related to App Studio (including those that weren't mentioned on stage). Q: Back in the day, form builder and inline dataset editor were some of the coolest apps for…
-
Remove Card Title From Dashboard Display
I am trying to remove the title from the cards on the right to match the cards on the left, so that the title isn't repeated. I prefer the look of the cards on the left. I didn't create the cards on the left and don't know how it was done. Thanks
-
Databricks Connector to allow Username and Password
The current Databricks connector only allows to connect using a Personal Access Token. It would be great to be able to input a username and password especially for service accounts.
-
Has the location of FORMS changed very recently?
Hi, Has the location of Forms changed recently? The Forms ICON is missing from MORE > WORKFLOWS as it shows in this support article. As of 3/12/2024 this is the Workflows options: Thanks, P
-
Alert Configuration options differ across the DataSets
Good afternoon all, I am looking at setting up the Alerts on our DataSets and have noticed that the options for the configuration differ between different DataSets even though they are both powered by the same Connector. Version 1 - provides the option to apply the alert on the indivduals rows and apply filters (the one…
-
Undo
Is there a way after deleting cards or pages to undo or restore? without having to rebuild them.