-
Pivot Table switch values to show as columns or rows
Been working with Pivot tables for a while now, and one of the huge things I miss is the ability of selecting whether the values should be displayed as Columns vs Rows, something that you have in simple spreadsheet programs. This has proven useful when you want to show the same metric by different aggregations for example,…
-
View as user or view as role
As an Admin / Major Domo I want to view my Domo Instance from the perspective of a selected user or role In order to ensure their experience aligns with what is expected. (Dashboards, cards, pages, features, etc. that they should see are there, and those they should not see are not visible.)
-
Split out the Grant option 'Export From Domo'
Currently, there's an option to enable/disable users from 'Creat[ing] Scheduled Reports and export[ing] to email, print, PowerPoint, CSV, and Excel.' I would like to retain the ability to share the cards/dashboards but would like to have an option of preventing users from accessing the underlying data behind the chart…
-
Mass Deploy Drill Paths
I generally want a structured layer between visualizations and the default drill down data. If I have 30 cards on a page I would have to build this 30 times. Allow developers to assign or copy/paste a card structure into any drill path.
-
GA4 Connector Settings Best Practices
Those of us who work with Google Analytics 4 data understand getting the data to accurately pull into Domo is at best tricky and really does take closely studying the settings and creating ETLs. I thought it would be a good idea to collect our best practices in one place. For example, if you want to get an accurate user…
-
5 Reasons NOT To attend Connections Tour
The Connections Tour is the ticket to snag, especially with the $0 price tag that’s easier on your budget than those concert tickets you splurged on this summer. But if you’re thinking this tour is a total skip, read HERE for the 5 reasons you might be right.
-
Beast mode 'Case when' for if a date exists
Hello! I am trying to write a beast mode that counts a row of data if a date is present. The first row of my beast mode is working, but I am having issues with the second row. Basically, if a move-in date is present (or is not null), I want to count that row in this calculation. I am new to writing beast modes so I am not…
-
Google Analytics 4 Preferred Connector Error 401
I'm currently attempting to pull data for a GA4 account into Domo using the preferred Google Analytics 4 connector. I've selected all of the dimensions and metrics that I would need, but when I attempt to run the dataset it will attempt to pull the data in for around an hour and then return '401 : Unauthorized : Error…
-
size of dataset
Is there a way in Domo to understand the actual size of the dataset? I know we can find the row count, but I am not sure how to find the size in GB/TB.
-
Many rows
I need to find a way to pull in many rows of data. I have two months worth of data which is essentially 110M rows. I need to pull in at least a year. Is there a way to do this? I tried the ETL partitioning method but it said 'too many rows of data'. Would workbench work with partitioning here or would I get the same error?…
-
When I add a table to a powerpoint slide through the plug in, how can I remove the blank space?
I am currently using the domo plugin for powerpoint. When I try and add a table to a slide from a dashboard I created, there is always a blank space added to the bottom of the table, that is within the image itself. I can crop the image so the blank space is removed, but when I refresh the data, it reverts back to the…
-
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…