-
Color Rules: Prevent table card from inheriting colors
If I set a color rule on a bar chart, and build a table card as the drill, I cannot remove the color rules from the table. The color is inherited from the bar chart, and the only change I can make is to uncolor the WHOLE table row, but I can't simply remove color in the first place. In my use case, the only reason to have…
-
Compare MAX date with YOY: Month-to-Date (MTD) Comparison
Trying to create a sql statement in magic ETL to compare YOY: Month-to-Date (MTD) by MAX date. My current code from is: CASE WHEN (MONTH(MEMBERSHIP_INSTANCE_PURCHASE_DATE) = MONTH(CURDATE()) and YEAR(MEMBERSHIP_INSTANCE_PURCHASE_DATE) = YEAR(CURDATE()) and DAYOFMONTH(MEMBERSHIP_INSTANCE_PURCHASE_DATE)…
-
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…
-
App Studio Controls/Filters
While creating apps with multiple pages/tabs we don't often use the same dataset for each card we put on a dashboard (app in this case, woohoo for app studio!) Where we are running into trouble here is that page filters only have the option to select a singular dataset rather than all datasets where the field is present.…
-
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…
-
Domo Office Add-In - Relative Date Filters
Hi, the legacy version of the plug-in that our users are widely used to had the ability to do relative date filtering. Unfortunately, the new version does not include this functionality and is hindering our effort to get users to upgrade. Please enhance the new add-in by adding relative date filtering.
-
enabling embedded App Studio app to have export functionality
We use domo everywhere currently using dashboards and like the design flexibility that App Studio brings but there is currently no option to add the export functions to embedded apps. Adding this even at card level would be a real improvement
-
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…
-
Options for Preview Run Limits in Magic ETL
The Magic ETL currently only max out at 400k row for the preview run from your input datasets. This is limiting the test preview in your flow as it only picks (from my understanding) the first 400k row of your dataset. So if you're trying to preview your actions (such as filtering) you may not get anything showing in the…
-
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…