-
Email Connector: Way to ignore #N/A fields in xls files ?
I am using the email connector to send .xls files to DOMO. There were some fields in the excel file that contained "#N/A" and they were automatically converted to "ERROR 42" in the dataset that was created and caused my downstream dataflow to fail. Is there a way to have the connector somehow ignore #N/A fields or convert…
-
Beast Mode calculation works but when trying to insert into a card, I get an error.
Good day, I have a beast mode calculation that I believe can calculate the sum of accidents over the previous 12 months for any given month. My data set goes back 3 years on a month by month basis. Here is the current beast mode that works when I validate it: SUM(SUM(fieldsAccident Count)) OVER ( PARTITION BY…
-
Domo bug? from Excel file import
When I append data on a Excel File export (same structure) the valid ID's in the ID column are errored out with ERROR:#N/A Right now its at 58,000 rows, is there an issue here? Wondering why its erroring out those ID's
-
Magic ETL History Error Log Visual Representation
It would be great if in the history of the dataflow it gave some sort of visual representation on which FAILED had an actual error message I normally have to look at each one to find the one with the actual error
-
Provide details on when Domo will attempt to run a dataset again
As an Admin or Editor I want to see the details of when Domo will attempt to run a dataset again. In order to know if I should try to manually kick off a dataset, or wait for Domo to run it. Currently the Interface shows this when there is an isssue: When clicking view details, it takes you to the History tab. I would like…
-
Transaction Deadlock workbench error
Good morning. I am curious if anyone has had this error before. One of our workbench jobs has been getting it more and more. I don't know if it is a domo workbench issue, or if it is an issue on the database side where we query the workbench job from Error 40001 Microsoft ODBC SQL Server Driver SQL Server Transaction was…
-
Error in PPT. Plugin
Hi Everyone, I am having an error code on a ppt I connected to Domo. Everything was set with cards but I ended up deleting some cards from the dashboard itself and also on the ppt. Now when I refresh the ppt. I get an error message below. I deleted the cards from the dashboard and ppt so I am not sure how to solve this…
-
Multiple Case statements
Hi there, I am trying to make a table that has the following columns. Customer Name / AW 2022 Pre-Orders / AW 2022 Replen Orders / AW 2023 Pre-Orders So what i need is a beast mode formula that can get me data based off the 'Invoiced Month' of 10, 11, 12. The 'Invoiced Year' of 2022 and 2023. And finally the 'Sales Order…
-
I am needing help to create a condition in order to make a beast mode I am working on
I need this beast mode to switch its year offset based on which quarter it currently is. This is the first and most important part of the beast mode since it will effect how the data is read and written each quarter. I have come up with three ways to do this but none work, here is what I have come up with: (CASE When (CASE…
-
One of my bar charts won't display properly in the dashboard.
Hi, everyone! I have a card which shows up properly in analyzer, but does not show its bars in the dashboard or when I click into the card for a drilldown. The weird thing is, if I hover over another card as if to filter a time period, the data will show up. Our management and executive leadership regularly access this…
-
"The Pivot Table is Only Showing Part of the Data" Error
In our KPI cards using pivot tables, I keep getting the following error. ”This pivot table is only showing part of the data. The visible rows and/or columns are incomplete.” There doesn't seem to be anything wrong with the DataSet, and I have not been able to identify the cause. Has anyone else had a similar error?
-
Workbench - Source File Does Not Exist
Has anyone found a solution for the "Source File Does Not Exist" error? I am using the 'Excel: On-Premise' processing method and using a network drive for storage. Even when I reconfigure and reselect the file it does not resolve and I get the above reference error. Any ideas? Thanks all!
-
ML model null values and unknown error message
We are trying to create a machine learning workflow wherein we are trying to predict by feeding in several rows of data to train the model and use that as base to get the predictions. We were able to run the same model (with samechosen parameters) in Python and get an accuracy of upto 95%. When we try to replicate the same…
-
Instagram Business Connector - Server Error
Hi guys, Has anyone had this error whilst trying to pull data from Instagram? Domo is ready, but received a 'Server Error' from the data provider. If the issue persists contact the data provider for support. All suggestions welcome as I really need to get this fixed. Thanks, Shiel.
-
Snowflake Federated Connector 'No federated agent was found for the provided values...'
Have been using snowflake federated connector for about 3 months no issues then today all of a sudden receiving this error. The error displays when trying to 'create' the dataset meaning I am able to navigate through the scheme browser, select and view the dataset I want to connect but once I get to the final menu and…
-
Is there a reliable way to make Magic ETL intentionally fail?
I have an ETL that uses, among other inputs, a Webform that isn't always maintained perfectly. One recent problem involved two rows for the same identifier, with different text in the description column. What I'd like to do is make the ETL fail if something like this happens. I tried doing a Group By on the identifier…
-
Capture error in a Card
We're currently using a Range Selector card to allow users to filter our data based on a MIN and MAX date. The problem is that we sometimes have no data when users initially access our platform and they see the error "Error: The maximum value is less than the minimum value" and that leads this to thing that there's an…
-
Unsupported post request. Object with ID 'act_20017474'
Hi guys We have been using the Facebook API for months now with no issue and a few weeks ago it just returned the below error. It has returned this error every day for the past few weeks. Has anyone come across this issue and found a solution? "Facebook returned an error: Unsupported post request. Object with ID…
-
Trouble connecting TikTok through email connector (Download directly from link in email)
Hi, there are a few TikTok metrics that are not available via the API connector, so I am attempting to use an email connector. The emailed report contains a download report button that triggers a link to open that automatically starts the download of an xlsx file. (I also tried with a csv) I set the connector to use the…
-
Rolling 3 Mo Avg - Breaks Card
I want to calculate rolling average of the previous 3 months. I was going to do this using windowed lag functions ( (LAG(SUM(`Sales Amount`),1) OVER (ORDER BY `YEARMONTH`)) + (LAG(SUM(`Sales Amount`),2) OVER (ORDER BY `YEARMONTH`)) + (LAG(SUM(`Sales Amount`),3) OVER (ORDER BY `YEARMONTH`)) )/ 3 Each Lag works individually…
-
Line breaks and special characters are being added to a webform
We use a webform for our Sales roster. We have had an intermittent issue with line breaks and special characters being added to the rep's names which causes quite a few issues. The very first sales rep on the roster is getting a line break added to her name. There's another sales rep getting multiple line breaks and…
-
Improved Error Handling in Analyzer
If the column names of a dataset change, the Analyzer does not show you where the problem is if the column name change affected a beast mode calc. Instead, you receive this generic message. This requires you to go through every beast mode that is being used on the card and click validate within the beast mode editor each…
-
Redshift Unable to create database.
We are getting the below error when trying to build a Redshift dataflow: We are unable to run previews, and we are unable to run the dataflow itself. It fails every time we try to run. Any idea what is causing this issue?
-
Email Connector unable to find link in automated email, but can find link in forwarded email
Hi Guys, I recently encountered an issue with DOMO email connector. I scheduled a report sent to DOMO email connector and myself with link in the email body that leads to a file download. When the automated email was sent the DOMO would show error: "Domo is ready, but was unable to find any links in the email." However, if…
-
Multi-Value chart percent change error?
Hello all, Wondering if there is a way this value is calculated and where the error could be. Chart 1: Current Month - Value 94.83 | Change is -0.62 when compared to 1 month ago (aka previous month) Previous Month: Value = 95.42% Difference Actual: 95.42% - 94.83% = 0.59% Why does Domo calculate this as 0.62% and this…