-
Json No Code and Json No Code oAuth Connector - Add response details
These connectors both return errors that start with "Domo is ready but…" in the dataset history which provide very little detail into the error that actually occurred. I'm not sure but from examples I've seen it seems like this might be a generic set of messages based on the HTTP status returned. I appreciate that Domo…
-
ERROR: This calculation uses both aggregated and non-aggregated columns.
I have been using beast mode fields that used window functions and which validated and worked fine in my charts for years now. However, today when I tried to add a new beast mode I am getting the following error "This calculation uses both aggregated and non-aggregated columns. This may result in duplicate rows and…
-
Uploading to External Connector
I am uploading data from a Magic ETL output dataset to Amazon S3 using the connector. I have a column with phone numbers (Text Datatype) which is automatically appending an apostrophe (`) before the number. I need to get rid of that apostrophe before uploading it.
-
InformData: Empowering data-driven culture
InformData is a data company that helps organizations make informed hiring decisions by providing background screening services such as criminal history checks, employment and education verification, and other identity-based insights. Watch and read InformData's Domo story HERE. Key highlights: Challenge: InformData had a…
-
Seeking advice on my chart of MCQ responses
I have a dataset that gives respondents' selections in response to multiple-choice questions on a survey tool. There's no limit on the number of questions on a survey, the length of question or response option text, or the number of options that can be defined for each multiple-choice question. The audience consuming this…
-
Color rule a column based of another column? Color rule for text?
I have a table card with these columns: Account Name, MTD, MTD Budget I want to apply color rule to MTD column so that when MTD is below 10% of the budget, color that MTD number red, else green. So in this example, 100 would be red, and 500 would be green. Account Name MTD MTD Budget Sales 1000 2000 Expenses 500 400 Is it…
-
Is there a best practice for a visual indication that a card has a drill down configured?
I'm curious if the community has recommendations for a quick visual cue to users that a card has a drill down option configured. I think maybe I saw a method that @ColemenWilson was using at one point (…?) but figured it might be worth a post/ask to see what others are doing and maybe what they do (and don't) recommend.…
-
App Configuration - Filter Options
Hi Domo Community, I am making updates to my team's App. The goal is to have filters at the card level static across the dashboard tab/page. For example, if we go into a card in the App and select a filter, we would like to have the filter applied to the dashboard tab/page. Is this possible? Also, I would greatly…
-
EXCEL SFTP Connector Keep All Columns (Append)
Hi All, I have been having a problem recently with different vendors' data pushes that the data connects via Excel SFTP. What occurs is that either the vendor changes the column name, so the past data drops the column with the name change, and all that data gets lost. What also occurs is that the workflow the vendor has…
-
what kind of SQL does DOmo use
Hi everyone, does anyone what kind of SQL DOMO uses? standard or mySQL?
-
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.
-
How can I set up a text box Variable that can search for a text string in a field?
Hi Domo Community, Like the title says, I'd like to set up a Variable to be used in a dashboard where users can input text and it will search for the text string in related reports and return the results. For example, I have a "Description" field for items. I'd like to search "6mm bolt" in the Variable/text box and have it…
-
beast mode for total active tickets per hour
Hi Everyone, I was hoping to get some assistance on writing a beast mode for getting a table to show total number of tickets per hour. Something like the one below: I have something like this so far- DATE_FORMAT(Date_Entered_UTC, '%Y-%m-%d %H:00:00'), COUNT(TicketNbr) but getting an error when trying to submit it. Any…
-
SQL Tile - Add All Columns
Hi, When using the SQL tile it would be really helpful if there was a button to add columns from an input with one click. Either one-by-one, or an "add all from input" button would work too. Sometimes the intellisense doesn't pop up when trying to type the name in the editor. Thanks!
-
If we made a band called "AI Agents", what would you play?
I'm a guitarist and so is @DanHendriksen so that's probably our realm. If you were to join this imaginary band, how are you contributing? Who's playing the ETLs?
-
How can i achieve the below grouped calculation in a beast mode?
Hello Team, How can i achieve the below calculation in a beast mode. sum(MAX(SUM(`metric1`) OVER (PARTITION BY `Metric2`, `metric3')) OVER (PARTITION BY `Metric2`, `metric3`)) If its not possible in domo beast mode then can you please suggest a way to achieve it in any other feature?
-
App Studio - Limits for Control Filter Options (Please!)
Hey friends! As we develop more within the App Studio space, we have run into a topic that would be amazing to add some functionality for. For example purposes - Let's say we have a dataset that is really badass, built to do all sorts of things and provide tons of information. We take that dataset, and are building an App…
-
Individual / Group Landing Pages
If Domo could allow each login to have its own Landing Page, or by Group. This will allow the Landing Page to be relevant to each Department / Team or subsidary company. For example, Sales / Marketing Team can see their monthly stats and goals. Customer Service Team can see their monthly calls received and average call…
-
API PUT Error: Full authentication is required to access this resource
Hello, I am trying to execute a PUT API call to update a DOMO variable in a workflow. I have the variable's URL and I have the secret token needed to authorize the call (per DOMO's documentation), however I am still getting the following error:…
-
Is there a way to set Auto preview on for all Cloud Amplifier datasets?
I've been using Cloud Amplifier more recently and noticed that whenever I create a new card using it, the Auto Preview is always off. Is this a bug or is this something that can be tweaked?
-
Beast Mode- SQL code to count how many updates in 6 hour intervals
Hello, I'm in need of assistance please of creating a beast mode but can't seem to write it correctly. I have a table named updates with a column time_start that stores the timestamp of each update. the Rows will be the ticket numbers And I want to group the updates by 6-hour intervals, and count how many updates fall into…
-
Allow borders inside of tabs
Currently, if you have a tab setup in an app, you cannot put borders in the tab. There are workarounds, like a text box with _ characters, but it doesn't have the dynamic sizing of the border feature
-
Show Configuration AND Notes panels on Magic ETL tile simultaneously
Currently, a user can see either the configuration of an ETL tile OR they can tab over to the notes section. It would be nice to see both views at once when writing notes on the configuration or editing the configuration based on the existing notes.
-
New and Updated Instructor-led Training from Domo University
The Domo Education team is excited to announce a major refresh of our Instructor-led Training (ILT) program. Registration is available now at Domo University for new and updated training offerings to provide more comprehensive, hands-on learning opportunities tailored to various skill levels and interests. Importantly,…
-
Add CLI activity Log to Domostats
This should already be included but is not. Domo should add robust CLI logging into Domostats We have repeated issue where Domo occasionally removes the upsert key on our dataset without warning or cause. Domo can also add a section to the Web GUI that allows users to control Upsert Keys for CLI datasets
-
Dataset Watchdog Logs
I'm starting to use dataset watchdog and I'm finding most of it pretty intuitive. I created a config file and started a watchdog job a few days ago and now the execution log is not updating. Are there limits to the log as it exists?
-
Is it possible to update the resulting dataset from AppDB once updated in the ProCode editor?
I was recreating the table showcased in the Editable Data webinar using some of our own data. I happened to make a mistake when I first ran the pro-code editor that left out a column and some values from another column due to a data typing mismatch. However, when I ran the adjusted code, the dataset that generated from…
-
Change dataset name/description when publishing
Is there a way to change the name and/or description of a dataset when publishing it to a Domo Everywhere subscriber? I have a couple needs for this: Data sets are named with a client ID number that we don't need/want to show to the end users. I considered using tags for the client ID number but you can't search datasets…
-
Add Search Bar in the "Connected Cards" page within a Dataset
Hello, It would be really useful to be able to search within the grid of cards in the "Cards" tab within a dataset. When there are hundreds of cards on that dataset, having a search bar would make it easier to find a particular card. Being able to search by card title would be great, even more interesting would be the…
-
Can DOMO user with participant role submit the values into pro-code editor app if user is not owner?
Hello team, I have developed a pro-code editor app and shared it with a Domo user who has a participant role. The objective is to grant the user permission to submit new values into the table. The user can input values into the table, but when they click the 'Submit' button, the status remains stuck on 'Submitting' and the…