-
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…
-
Scheduled Workbench Jobs not Running: The communication object, System.ServiceModel.Channels.Service
We have several scheduled Workbench jobs that are extracting data from SQL Server tables and loading to DOMO data sets. The jobs are failing to run at their scheduled times, but I am able to run them manually without issue. They are showing this error: Strangely, only some of our jobs are showing this error. We have other…
-
Email connector not finding link
Hi there! According to the KB article for the Email Connector this should be working correctly, but here I am :) I receive a nightly scheduled XLSX report from a third party reporting tool. They recently stopped attaching the report to the email and instead put it a link to a page which then downloads the file from AWS.…
-
DOMO Workbench 4 Log Export
We have been having some issues recently with Workbench jobs and I would like to be able to compare the job activity between jobs that were successful and jobs that had errors. I can select only one line on the log at a time and export that (using copy/paste) I was wondering if there was a way that I could export all log…
-
Workbench crashes every time - Workbench Service WILL NOT STAY RUNNING
Hello, I created an account on developer.domo.com and started working on a custom workbench plugin. However, there now seems to be a problem tied to my account because anytime I try to pull any data in workbench it crashes. This issue is not tied to my machine. After MANY, MANY uninstalls and reinstalls, I just created a…
-
Domo Everywhere - Private Embed with pfiltering - anyone done this with Inline Edit?
We set up Domo everywhere to work with pfiltering via a security overlay app. the idea is to not have to set up external partners with id's in domo and prevent accidental sharing of sensitive information. one thing we want to do with our vendors though is to enable them to update the status of the progress of their work.…
-
"Failed to start data processing engine"
Hi, I get this error message across various datasets a few times a day. It only occurs from scheduled/dataset updates. It's not a major problem as the dataflow succeeds on the automatic retry, but the notifications can be annoying. Has anyone else had this issue? Is there a fix for it (or can I at least remove the…
-
DOMO CustomApp - How get the the ErrorMessage of a domo.post?
Hi, I have built a Domo Custom App to call an AWS Lambda Function with domo.post. There's no problem in managing the response when all goes fine. But I haven't found how to extract the ErrorMessage from the response when it gives an error (HTTP errorcode: 400) Can someone tell me where domo keep this information? Thanks
-
Option to Remove the 10,000 Duplicate Error for ETL
Because of how fast/easy ETL flows are, I prefer to use them for most flows. My problem is that sometimes I hit the following error, "Error joining data. The left input cannot include over 10,000 duplicates. Please switch your inputs, group your data, or remove duplicates before joining". The Dojo suggests that this error…
-
Data Connector: Microsoft SharePoint Account
I'm trying to use the "Microsoft Sharepoint Account" connector to attach to an .XLSX file on our SharePoint site. The user credentials for the connector has read+write access to the site/file in question. However, the DOMO connect will not connect and I'm given a very generic error "Domo is ready, but the associated…
-
App Design Studio - app won't upload to Domo
Hi All Trying to buid my first custom card design with App Design Studio. I have the latest version of both Illustrator 2018 CC and the 2.2.8 App Design Studio plugin from https://www.adobeexchange.com/creativecloud.details.14699.html I was able to layout my widgets OK and the preview looks fine. When I click the…
-
Magic ETL appears to run all the way to indexing, but fails with an un-specified “Server Error"
My ETL appears to run all the way to indexing, but keeps failing with an un-specified “Failed while executing....The server experienced an error". When I view the details of the "Run", each of the steps has "no additional details" It is an extraordinarily simple: two inputs, group one, join both, output. I have used both…
-
Beastmode calculation error dividing
I'm trying to create a BeastMode that will give me 'average views per user'. (tool 1 views + tool 2 views) / total users = average views per user CONCAT ( (sum(`Tool 1 Views`)+Sum(`Tool 2 Views`) / (SUM(`Total Users`))) ,'Views') My issue is that it VALIDATES the code but then gives me the following error: "An issue has…