-
AppStore Error
I am unable to get Domo's AppStore to pull up any connectors. Anyone else having this problem?
-
Workbench Authorization
Hello Domo. I've noticed that our Domo Workbench has required server reauthorization multiple times already this year. Would it be possible to update the settings so the server remains authorized for a longer period—ideally one year, or at least six months? Additionally, it would be very helpful if a notification could be…
-
Turn off Magic ETL notifications
Can we please turn off the notifications for large grid recommendation? There's a setting for under the settings icon. I'm getting tired of closing this every time I go into a flow. I also don't think we need the mini map cluttering the window.
-
Validate Issue
Is anyone else having problems with the validate button? If I try to validate formulas using the validate button it gives me an error. But the validate button on the field does not give the error. This started after one of the recent - refresh your browser we've updated Domo screens.
-
Export Filtered Results
{I think we already posted this request but I don't see it.} When I filter a dataset and export, the export contains all the data and all the fields. I want export to only export what is displayed. If a filter is active, the export should only contains records that match the filter. I keep having to create cards just to…
-
API for DataSet tags
I am having trouble trying to pull values from the Domo API, to identify datasets by "tag". In data center, if I tag some of my datasets as "API", I want to use Python to pull the list of all datasets with that tag. There's a discussion at this link but it doesn't give a solution: I can get a list of my Domo datasets and…
-
Need to read a Domo dataset using C#
I am having trouble getting an access token to work in C#. I am writing an application, and I need to update an office list using the data in one of my Domo datasets. I have created client and secret IDs and post to "https://api.domo.com/oauth/token". I have tried several grant types and included/excluded a scope. The…
-
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…
-
Magic ETL Join Tile
Apologies if this has been requested in the past. I would like a case insensitivity checkbox on the join tile. In the example below, I have created two datasets. In dataset2, I have a list of words in varying cases: lower, upper, and proper. If I join the datasets, I get different results based whether the words in…
-
Hide Total
The card interface changed. I used to be able to hide fields from the total row. Now I see I can hide the label, but the value is still there. How do I hide fields from the total row since this interface update?
-
Rank
I noticed there is a difference between ordering using Rank format on a card, and using the Rank tile in a dataflow. If you use Show value as 'Ranks small to large', whenever there is a tie, the following ranked item will remain incremented by one. But when using the Rank tile, after a tie, the consecutive numbers are…
-
Training Videos
I've noticed several of you do training videos. I want to draw on your experience and knowledge of current tools. I have an extensive background in graphics, video, etc. So complexity of the tool doesn't bother me. I want to create a couple training videos for our staff on using our Domo dashboards, etc. It MUST be able to…
-
Blank Brick Dataset Schema
I created a blank brick to track office locations in the path of hurricane Beryl. My ETL produces a dataset with latitude and longitude in decimal. Now my blank brick is showing these values as integers. They are not integer. How do I force the blank brick to re-evaluate the schema. I tried reloading and reassigning. I…
-
Order By
Why does the order of elements change every time we run an API or an ETL? If I put a select column tile on an ETL, immediately followed by an output, I would expect the output fields to be in the order of the select column tile. I'm currently working on a complex aging flow and running the flow makes the dataset wonky and…
-
SQL To Magic ETL Issue
Domo's use of mySQL as an ETL is frustrating slow. I have a solution that runs in seconds when I duplicate it in MS SQL, but when applied in Domo it takes forever. I need to figure out how to do the following with tiles in Magic ETL. I have created an example using store locations as anonymized data. Assume I have a table…
-
Blank Brick
When I create a blank brick in Domo, it builds out a card with area for javascript, html, and css code. It also adds three datasets to the domain. I replace dataset[0] with my own dataset and get the card working. Terrific so far. But I never needed that example set in the first place. Now I want to delete those example…
-
Color blindness & creative solutions
After the recent Domo XCanva Challenge, I am a bit more aware of when I am coloring outside the lines in producing a result. I just created a blank brick for a large table (simulated here in smaller version screenshots) that includes rankings on several columns. The request includes heat mapping on the columns. Since this…
-
Default Message
I want a card with a single line of text. Not a table. This is to act like a caption textbox. To indicate last run. The text is to indicate most recent date within the dataset. Assume there's a column called [date]. Here's the tricky part. This date must be based on the data itself. We have many offices. When filtered to…
-
NetSuite Connector
Due to privacy I cannot share any records, nor can I simulate it. This is going to take familiarity with the NetSuite connectors to answer. This connector does not work like other APIs. We have tried two of the NetSuite connectors recommended to us by Domo. When we validate the information we find a couple records missing…
-
Data Structure Issue
Short version: how do I check if a field is a valid date? Long version: Using the NetSuite connector, our data has a field called Period. The connector does not allow me to define the data structure. I tried admin » toolkit » schema management. It doesn't hold. If I force the dataset field to a string, the next run it puts…
-
Carrying date range in hyperlink
I am using pfilters to drilldown on multiple columns. But the set date range isn't carrying when the link is clicked. How can I open an anchor link so the new page has the date range the first page had? CONCAT('<a href="https://domain.domo.com/page/1234567898?pfilters=' etc
-
HTML Table Styles
I don't generally work with html table chart type, but I have a dashboard that needs borders and subheadings if possible. I am only interested in what I can control in html tables, I don't want to use bricks. I can't find any web examples with fancy tables showing borders and headings such as the following. Can this be…
-
File Import Schema
I often get frustrated by Domo's need to define its own data structures. It might get quite a bit right, but what it gets wrong becomes a problem. In the file import, I see no way to define the data structure for each column. The best I can do is force the data type in the source file and try to trick Domo into creating…
-
Comparing weekly data
Say I want to compare 2023 and 2024 March data. In 2023, March starts on a Wednesday. In 2024, March starts on a Friday. If I chart day of month, I can visually see the weekend gaps. I'd like to find a way to compare weeks to the previous year, that executives could easily understand. But because of the movement of the…
-
Domo Workbench Error
I have an Excel file that gets picked up using Domo Workbench once per week. Workbench is showing an error, "Cannot read that as a ZipFile." The file is not configured as a zip file. It's a local Excel file. And it's configured to load as an Excel file (Excel: On-Premise). I opened after seeing the error and it opens in…
-
Effective Dating
I want to capture appointment differential data and report back using effective dating. So that if I want a snapshot of a specific date, I'm pulling the most recent changes up to that moment and ignoring the rest. I've done this plenty in SQL, but looking for a solution using Domo ETL. I don't want to re-invent the wheel.…
-
Check for condition against the whole
Assume the dataset I am given looks like the following (below). My downtown store was flooded in 2023. Some of my customers may have moved their shopping uptown. I need to filter the list so I only see customers that had "Downtown" amounts in 2022, and also had "Uptown" amounts in 2023. In the scenario shown, I expect to…
-
Column borders
The suggestion has already been made, but I want to mock-up how easy it would be to add border styles via the Domo interface. This could be on mega tables, html tables, or simple table. We need some way to darken and thicken borders. Telling us to use bricks or something is like suggesting we go to some other application.…
-
Dataflow Version Clearing
I don't need all these dataflow versions. There should be a command to set the current as base and clear all old versions.
-
Confusion - LOWER
I have formula logic to try to standardize insurance company names. I use a series of case conditions to try to create a new field with standard naming. But my logic doesn't seem to work the way it would in SQL. My formula contains searches such as… CASE WHEN LOWER(insurance_company_name) LIKE '%aetna%' AND…