-
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.…
-
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…
-
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…
-
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
-
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…
-
Card Lineage
A previous question asked how to find the dashboards that use a given card. The answer pointed at using Domo Governance reporting. Surely there's an easier way to connect the dots. If I open a dataset, there's a "cards" link that shows me the cards that use the dataset. When I click on one of the cards…is there no way in…
-
Format as number without comma
I have a new version of an existing dashboard. The dashboard has a dropdown selector for year. Year is a formula field on the ETL defined as Year(`transaction_date`). On my original dashboard I see 2023, 2022, 2021. On the new version, I can't get the filter to remove the thousands comma. So I see "2,023" instead of…
-
Remove answered questions from the list of unanswered questions
Why are answered questions coming up in the unanswered questions link? Can we get those removed from that list?
-
Show Scheduled Connectors
Is there any way in Domo to see the time schedule for all jsn or other connectors? I want to review the times I have set for connectors. Currently I use an external site to keep notes.
-
Export to PDF error - images
I have a dashboard that displays information with a field containing a person's id. On one of the cards, I display an image of the person. The card uses an html table to display the person by calling an image url. When I try to export the dashboard to PDF, the export fails. If there any way to tell Domo to ignore a card…
-
MySQL Workflow
Can Domo's mysql handle more than 500k records? It shows the import can only go to 500k but I'm assuming that is for previewing data not actual processing. I attempted to output only five rows from a million record dataset and it ran for 30 minutes before I cancelled the process.
-
CLI move-data needs to move not copy
Using the CLI move-data command, I set up a dummy dataset to move rows. The rows copied but did not remove from the source.
-
Allow empty datasets with future date ranges
We pull two years transactions plus the current year from an api using JSON connectors. I've found it more reliable and efficient to break the data into smaller pieces. For the past years, I have created a connector for each - refreshed once per month. For the current year, I am splitting the year into Q1, Q2, Q3, and Q4.…