-
What Type/Version of SQL do SQL Tiles Use?
Question is self explanatory, in MySQL you can use the SELECT version () command to determine this, but you can't in the tiles. What is the version?
-
Allow background color choice on Header elements
Currently you can only choose styles that affect the font of the header elements. It would be nice to be able to choose colors as well.
-
Get MySQL on latest version
Currently, Domo's MySQL is on version 5.6, which is approaching end of support. There are also a number of commonly used features that people want to use in MySQL, but can't because it is still on version 5.6. Please upgrade to the latest version.
-
Conditional Formatting - table MoM
Hello, I'm trying to set color rules/conditional formatting in a table card. What I'd like to do is set rules that if that months sales figure is higher than the previous it'll be green, if that months sales figures is lower than the previous it'll be red. (ex. If July sold 10, but Aug sold 8 August's value would show as…
-
Power Point Plug in
I am using the new Powerpoint plug in. I can import cards, click refresh and select a filter and the filter will work. I can even create a second filter and then toggle back and forth. As long as I have not save the powerpoint this all works. As soon as I save the powerpoint, the powerpoint will say there is no DOMO…
-
Charting with a filled gauge.
Hi, 2 part question. For reference I am using 1 gauge and a variable to switch between revenue/ cost/ margin view. 1) I am using the gauge to compare to budget. I am wondering for the color of the gauge is it possible to have it be green when Margin/Revenue is above the target line but green when the Cost is below the…
-
Stacked Bar from this dataset config?
Not sure if this is possible directly, with Beast Mode, or if I have to change how the dataset is configured with ETL…. The dataset is currently setup like this simplified mockup: Ignoring the fact that the numbers in my mockup, don't match my card mockup, I want to present them like this: Is there an out of the box way to…
-
Boxplot Data Label Improvements
The options for the boxplot data label settings are pretty limiting. Although they have provided some great opportunities to visualise, due to their positioning (and options), I often struggle to present the data in a way that is accessible to the layman. It does not make sense for the median to position itself above the…
-
Can you add count (n) to box-plot graphics?
Hey all, Has anyone managed to add a count to a series boxplot graphic? I want to show the distribution of a score against categories, however, I also want to present the number of items in the category. Is anyone aware of a way to facilitate this? Best, Sam
-
Percent of Series?
Hi team, this feels like it should be very simple but I'm missing the key ingredient. I currently have "Percent of Category" as the data label. I'm using an Overlay chart. What is happening: 🚫 Green / Green + Blue = Displayed Percentage What I need to happen: ✅ Green / Blue = Displayed Percentage Any ideas?
-
Allow Group Ownership of Magic ETLs in DOMO
Currently only Datasets can have group ownership, however it would be a great timesaver if a group can have ownership of an ETL in Domo. It would make ownership more streamlined and controlled.
-
Domo Everywhere .env file
Hello. I was following along with the "Getting Started with Domo Everywhere" instructional video and got to a point where what I am seeing on my end is not aligning with the video. In the video, the instructor opens the .env file that has client_id, client_secret, embed_id, and embed_type. When I open mine, the…
-
Amazon Selling Partner Connector enhancement
Can we make an enhancement to the connector to allow for any prebuild standard reports in Seller Central be brought in? The connector currently lets you select Create and Download report but this only allows you to select from a list of reports. A couple of example reports of interest that are trying to be brought in are:…
-
DomoStats: Hourly/Avanced Schedule
Hello everyone, Our team is implementing a sophisticated Alerting system for the client. We are using various features of DOMO and would also like to leverage DomoStats, particularly the "Datasets History" report. This report would be perfect if it could run more than once a day. We need to be able to update the dataset at…
-
Python Scripting in Magic ETL | Iterating through close dates to get unique account id values
Hello! I'm trying to find the issue in my current python code that iterates through each date while maintaining a set of already logged accounts and then counting new accounts each day. I have sorted by the 'Close Date' , grouped by the 'Close Date' and the 'Owner Division', and have 'new accounts' and 'seen_accounts'…
-
Need to Show Actual Start and End Dates, not "This Week/Last Week/Last 2 Weeks"
G'day everyone 👋 I'm trying to use Smart Text (dynamic text) to show the dates being filtered, however the text comes through just as the filter looks (eg. This Week, Last Week, Last 2 Weeks, etc). Ideally, we'd like to show the actual dates being reported (eg. 08/12/2024 - 08/18/2024). I am a bit stuck trying to make this…
-
Two Group By with SUM totals
As always, terrible title by me I'm sure :) This is quite similar to a question I had last week that @rco helped me with, and I'm using his answer as the basis for what I'm working on, but am stuck on getting it to work. Last week I was doing counts of projects, but this week, I need to SUM the project cost. Simplified…
-
Count that accomodates NULL
On some charts, for my summary value I need to add a custom Project Count Beast Mode, which is just this: Value1+Value2+Value3 etc… However, if any of the values are null, the count no longer works. Is there a workaround without having to exclude it from the Beast Mode? Thanks!
-
How to filter column by a specific language
Hi, I’m currently working on a dataset that contains a “Page Title” column with rows in both English and other languages. I want to set up a filter to exclude all non-English titles. I use the following REGEX formula: CASE WHEN Page Title REGEXP '^[A-Za-z0-9 .,!?-]*$' THEN 'English' ELSE 'Other' END This formula helps…
-
Drill path for tables
Hello! :) I need to use drill path for a table (card) in DOMO such that when you click on one cell of the table, it goes to another table related to that cell. Could you please guide me in this regard? Thank you!
-
Interactive Tables with Writeback functionality
Hi There, This may be a complex ask. But I think it could be extremely valuable. I would love to create a table powered by Domo for our planning team that is powered by Domo but would also have a dynamic user input field. This field would adjust calculations on the card but could also have writeback functionality. In my…
-
Search results to show unique values
Hello, My backend data in excel has over 50,000 rows and one of the column is #ID shown in the below screenshot. I am searching for an existing ID "9996", but it just shows the 3 values. And I see the note below the search bar which is confusing, and not sure how to filter the page to see all matching unique values. Please…
-
Advanced Donut Chart with multiple rings
The donut charts in Domo appear to be quite limited. I created my own code to display a multi-ring donut chart, using a Domo blank brick. Generic screenshot below. Each ring in my code has an actual amount, projected amount, and budget amount. The light gray represents the projected. The darker gray represents the…
-
Mega Table SubTotals in Brick
I am lost in how subtotals are integrated into a mega table in a brick. I started with the ten data source DDX brick, and I was comfortable with configuring the options and the two data queries; however, the subtotal has me stumped. Is the subtotal a third query or somehow handled with the data from the original query? I…
-
We need a tile that alphabetizes columns in Magic ETL
Can we have a tile in Magic ETL that alphabetizes columns? Right now, I have to manually drag columns to get them ordered correctly for the next step in the ETL.
-
Can we get different color badges based on different certification paths?
Right now, all my certified cards look the same. I have to hover over the certification to see which department certified the card. It would be cool if I could have a purple badge for "Loan Officer Certified" and an orange bade for "Accounting Certified", etc.
-
Sub-Category of a Category?
Hi All, We are working on a report that has a few different program_namesthat are summed up in a pie chart using orig_loan_amount. I have been tasked with trying to sub categorize our bonds using a taxable/tax-exempt designation The problem I am trying to overcome is that our bonds (identified by pool_name) are actually…
-
Filtering a card
I am trying to filter off certain Key words for a column- But when I go to add several key words domo does not calculate properly.. is there any way to filter off multiple key words? The issue is these key words arent always at the start of the description so i dont think a beast mode would work. Let me know if I am wrong!
-
Onedrive files failing
Hello, we noticed a couple of weeks ago that a bunch of sharepoint/onedrive files that we have set up to ingest into Domo on a regular cadence, are failing. The error message in Domo is the same for all of them: "Domo is ready, but the requested file does not exist" We haven't moved the location of any of these files, so…
-
Filter Cards Not Showing All Data
Hello, I have been trying to create dropdown filter cards to get around the fact that you can't organize the filter views on a dashboard after they have been created. I have two cards that allow the user to select the company/location of the data that they want to see. However, the card is not displaying all locations that…