-
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…
-
Regexp on FTP
I have a need to upload an HR file into Domo. The file will come through a SFTP site once per month. But the name will not be consistent. Besides incorporating date information, there's a section that will change each month. I would like the ability to do a more advanced search on the filename through FTP in Workbench.…
-
Workbench SFTP Filename Changes
I need to schedule workbench to download a file from an SFTP site. The name file I am downloading will change. It has a date and time embedded, and a randomized string. It looks something like this {yyyymmdd_hhmmss_Product Report_V2_{some string}.xlsx. Can I tell workbench to bring whatever it sees containing "Product…
-
Filter on two or more columns
Do pfilters require special configuring of python or something? I want to embed an anchor reference link, to open a drill through page filtered on two or more columns in the row that was clicked. In the example below, clicking the link on the first row would open a page filtered on store=5, salesperson=Ralph. Store…
-
Standardizing Names
I need a way to apply a list of replacement values against incoming data. This is to standardize naming on insurance companies. If the data field says "BCBS of Tennesee", "BCBS of Tennessee", "BCBS of Tenn", Blue C Blue S", etc…the result needs to be in a new field with the result "Blue Cross Blue Shield". Say I have an…
-
Domo API to MS-SQL
I tried unsuccessfully to find an example of pulling a Domo dataset directly to MS-SQL via the API. So I created my own. I am not a python coder but my script works just fine. Does anyone have a version of this subroutine that does not require defining the column names (ie header)? #Retrieve dataset from Domo API def…
