-
Domo Workbench will not connect to Quickbooks after authorizing.
Multiple jobs were setup by an employee who is no longer at the company. I have removed Domo Workbench from integrated applications on Quickbooks and then reauthorized for every job. It worked yesterday and now will generate this error every time I run the job (manually or scheduled). "This application is unable to log…
-
Top 25s etc. in Table cards
We've put together a table card of Top 25 corporate travellers for one of our customers based on monthly spend. There are way more than 25 travellers however, and they want us to create a summary row for the remaining x travellers. The number of remaining travellers can vary month on month though so I need a way to hoover…
-
Connectors - Enhance Scheduling
Currently, the scheduling capability with respect to Connectors is based solely upon UTC (see first screenshot below). The scheduling capability available with respect to Magic ETL 2.0, however, provides the user flexibility to specify timezone (see second screenshot below). Can the scheduling capability with respect to…
-
Duplicating Connectors
Although there is the option to duplicate dataflows, it would be nice if we could also duplicate connectors. Some connectors are more complicated and have very specific settings that are crucial to getting the right data in. Currently, I'm testing out Facebook API Connectors and it's not efficient to constantly check that…
-
Custom Domo App (Replicating the SugarForce example)
I am trying to replicate the steps of the SugarForce sample code from Vanilla Javascript tutorial. After my initial setup (sample dataset, domo app cli, app initialization and publish), my domo.get command is giving me a 404 error for the following: domo.get('/data/v2/leads?limit=10') .then(function(leads){…
-
Thinking about using searchable filter brick in app studio
Hi, I am trying to use the searchable filter app to allow the user to search an order number and once selected, they can click on the search icon(see image below). Once the User clicks on the search icon, it directs them to another page in the app with the cards filtered to only that Order Number. Is it possible to make…
-
Get rid of Warning message in Pie Chart
Is there any way to get rid of this Warning? I am intended to show the numbers as negative though.
-
Gradient colors needs a midpoint setting
The recent gradient color addition to Analyzer has the potential to eliminate the need for setting up a bunch of color rules for variance colors, but it needs the ability to set a midpoint value like the heatmap color setting on table cards. Currently the gradient colors are relative to the bars displayed on a chart…
-
MagicETL Transform Settings: Timestamp to Date
I can't seem to find a clear answer as to what is happening here, so I'm turning to the community. I have a dataset with a timestamp field, createdAt The dataset arrives to Domo in UTC, and my company timezone settings are converting it to USA\Eastern Time. This is working as expected. Using this as an input dataset in…
-
Can I default the landing page to an App?
Would like to default our Sales Team users to the Sales Team App in App Studio
-
Ability to Default 'Send email notifications' to Unchecked
I administer Domo for a user base of 20,000+ users. We have created a dynamically updated group which includes all users of Domo, and this has allowed our users the ability to share Dashboards with everybody at our company. This is a great way to share information quickly with a large swath of people, however, the 'Send…
-
Can ddx cards automatically filter with normal cards when using page filters?
I am currently making a dashboard and needed a custom image to be used to display a value based on an ID, can ddx cards filter with the rest of the dashboard? Thanks ! :)
-
Any tips on how to clean Typo's in a dataset?
Hi all, I have a large and growing dataset with a number of human error typo's within the source. I am looking for a simple formula I can add to my ETL (or other method) to clean and fix common errors. An example to illustrate the issue, in my dataset I may have a field called 'Company Name' and within that field, for the…
-
Domo App Studio Form Deletion
A co-worker and I have recently been experimenting with forms inside the App Studio. When we made some progress, we wanted to delete and remove some duplicate forms as it would be problematic trying to pick the correct one out of a sea of duplicates. Unfortunately, we cannot find anywhere that these forms are stored. We've…
-
Inline Editing App improvements
Hi team, One of our customers pointed out some difficulties when using the Inline Editing app, and offered a few suggestions for improvement: 1. Creating a New Card - It doesn't seem possible to create a new card from the Asset Library, and the error "Invalid Client ID" appears, which can easily cause confusion: I believe…
-
How to migrate Workbench jobs to new server safely?
I will be decommissioning my server Domo Workbench runs on and need to migrate all jobs to a new machine. The current Workbench has jobs that run as frequently as every 60 minutes. I figured I could just export/import the jobs/settings, and leave them in a disabled state on the new server, test my connections to Domo, then…
-
Is it possible to make beast mode follow the colour rules on a different column?
I have a bar chart that has colour rules set up based on dataset column values. Now I need to use beast mode for the series, instead of using original dataset columns, because the beast mode allows us to convert the column value to different languages. In this case, the bar chart failed to follow the existing colour rules,…
-
Increase Dropdown Limit
I've encountered an issue where client surpassing 100k are not appearing in the dropdown search. even though these records are present in the dataset for a specific date range. It appears that the current dropdown limit of 100k records is preventing these entries from being displayed. It would be beneficial if the dropdown…
-
Custom Border Options Between Cards
In other BI tools, developers can customize borders such as vertical and horizontal borders, to help visual differentiate them. This feature is especially useful for clients who prefer to have clear visual separation between cards in their dashboards. Currently, Domo lacks this level of border customization. Implementing…
-
Domo.JS is not getting created via domo init
Domo.js is not getting deployed when I create a new project using domo init. I know there are workarounds to create this using npm install --save ryuu.js But I am wondering if this is a symptom for some systemic problem which is also causing my projects to error out with message such as these:
-
Inline Editing and Dataset refresh problem
Context: I have a Dataflow that has 2 Input Dataset (Product Sales 1, Product Sales 2) and an Output Dataset (to find rows that are in Product Sales 1 but not in Product Sales 2). And this Dataflow triggers monthly when Product Sales 1 and 2 get appended. I want to add a commentary column in the Output Dataset using Inline…
-
Connector authentication
FYI from a customer. we realized that you cannot copy/paste the SQL password on a connector! That was tripping us up a bit. But once we realized we have to type that password in manually everytime we change the connector, we stopped getting the authentication errors. It would be nice if that was noted somewhere on the…
-
GA4 Metric and Dimension Validation Best Practice
When setting up the GA4 connector for the first time it can be difficult to identify the metrics and dimensions needed to replicate the Google Analytics Dashboard. The quickest method I've found to identify the correct dimension names and metric values is to use the GA4 Query explorer.…
-
Issue with using calculated field in "Values" section with Pivot Table
Hi all, Up until recently, I was able to use calculated fields in the pivot table in order to display a text value: However, when attempting to do this on new cards, it will only let me use COUNT. Below is a different card/dataset, but in theory, shouldn't it be functioning the same way? I've tried adding it as a row…
-
YOY reporting based on Fiscal Week
Can we create a YOY card similar like this But based on the date range selected 10/20 to 10/26 which is fiscal week 43. It should compare the previous year fiscal week 43 which is date range 10/22 to 10/28. Currently, what is doing is it is comparing the same date range for 2023 (10/20/2023 to 10/26/2023). Is it possible…
-
Whoops error when implementing Join in dataset views
I'm relatively new to Domo, so I'm hoping someone can help. I need to complete a very simple join of two datasets. It is a left join of a larger data set from one of our vendors and a smaller dataset pulled in via the Google Sheets connector. I have tried connecting via User ID (integer) and by email address. In all cases…
-
ability to remove thousand abbreviations (K) on histogram card
I open the same data on a table I get an option under format for removing the thousand abbreviations (ex 1K instead of 1000). when I open it in a histogram card that option is not available in format.
-
Timezone by zip & postal codes for US and Canada
I need to map call data to local timezones to account for business hours and need to map it via zip and postal codes. Is there a pre-existing database available?
-
Rank and Window Function - SUM
I am trying to create a SUM in a Rank and Window ETL Tile. I have no reason to put a Frame Range in other than unbounded but it will not let me APPLY. I must be doing something wrong. Should the FOLLOWING box be a 0?
-
DDX Brick: Page Filter
Hi Everyone, I have created a DDX brick which is correctly making a gauge chart however it only shows the total aggregated number and doesn't update when a page filter is applied. Does anyone know what further code needs to be applied? I want it to update when the column DATE is applied on the page. Thank you for your help!