-
Can not run Quickbooks jobs in Workbench. Access denied.
All my local file and ODBC jobs are working perfectly, but when I try to run Quickbooks jobs in Workbench it fails with the following error message: "Access to the path 'C:\ProgramData\Domo\Workbench\Pipeline\PipelineSegments.store' is denied." I have tried running Workbench as administrator, but get the same error. My…
-
Use domo.js in an Angular 2 Application
Hi all, I need to use domo in an angular 2 application. How to bind domo with the angular 2 app? Thanks.
-
Reading User ID from API based on OData filter on email ID
I want to retrieve users without {id} using get API for users . Is it possible to use odata filters on email ID to retrieve user ID ? https://api.domo.com/v1/users/{id} I want to create or update users via API using program. If Get is unsuccessful then I will be calling POST otherwise PUT method .
-
Creating custom date ranges for display
I would like to display my cards with a custom date range that doesn't exist. I need financial year to date for Australia. Our financial year runs from 1 July to 30 June and so all our clients here would like their data displayed that way. How can I do this? There isn't an option in the date range field to do this. Domo…
-
"Use Scale Abbreviation" is not working for Line+Stacked Chart
Hi All, When I use the option "Use Scale Abbreviation" in Data Label Settings is not at all working for the "Line+Stacked Chart". For example, My data has huge numbers like "12345.32". And the scale abbreviation is like "100.00k,200.00k etc", but when I use the above option the number should display like 124.32k. But,…
-
Setting up the Dynamics GP Connect and Company Code Issue
I am trying to set up the Dynamics GP Connector and its asking for a Company Code. I ran this through DOMO support and they couldn't tell me what or where this number would come from. I found a post about this going back to 2016 and there was no answer back then. I have reached out to our GP VAR and they have no idea what…
-
Domo Embed Everywhere Help: Filtering
I am attempting to use Domo's new "embed card" feature. I need to be able to filter on multiple cards at once similar to page filters but with the embedded cards. Is this possible?? Trying to solve this or get a way around it, 1. If I embed a card from a page that has filtered the card, the embedded card does NOT retain…
-
Streams API - benefits?
Are there any speed benefits to using the Streams API for uploading data? For example if you wanted to upload a billion rows as quick as possible. I've written a python script to upload data via the streams api and it doesnt seem much faster than the workbench. I've even tried writiing the script in an asynchronous manner…
-
Bug?: Running Total zero value missing bar
Hi Dojo, Has anyone else experianced the following? On a running total card, if a period has no data to add to the total the bar is missing for that period. Here is an example, we have a 30 day running total bar chart where on the 16th day no data exists to add to the total. This should display the same bar value as the…
-
DOMO Objects Metadata Management
Hi, please correct me if i'm wrong. 1. There is a dataset named "Card Usage with Datasource and Owner Information", but the data refreshment frequency is daily and cannot be increased, so the information like "Last Viewed", "Last Updated Date" is misleading. 2. There is no dataset that shows the relations of datasets and…
-
How to report on Facebook Ad metrics by campaign?
I'm new to Facebook metrics and am trying to work out how to configure the Facebook Ads connector to bring in metrics per campaign. I'm very familiar with Google Analytics, but Facebook is completely different. I've been trying the Insights report but I haven't found a way to have the campaign name as a dimension with it's…
-
can i connect to an excel file with .xlsb extension?
-
Create a histogram
So I already have all the data that I need to create a histogram. As dipicted by this Excel pivot chart Histogram I am plotting NPS scores for my firm and also against competitors. In excel I would use =frequency(data array, bins array) and then it would sort it into groups and from there I would do my histogram. In Domo I…
-
Table Visualization Sorting/Filtering
We consistently use the Table Visualization as our base drill-through visual, would be great if we were able to sort and filter on the Table Visualization. I know you can do it on the table view of any card, but you can't format the table view.
-
Domo Administration approach
Hi all, we have been using Domo for 3 years and struggle a lot with the administration functionality. We are very much behind the idea of having one source of truth for everyone in the company. But between PDP, dataset sharing, groups, publication groups, card and page sharing as well as roles, we haven't found a good way…
-
Case Statement in Magic ETL
Hello, Is there a way to implement a Case Statement (not nested Case Statements) in Magic ETL? Thank you, Nick
-
How to highlight with HTML in a table card?
Hello, We used to be able to highlight keywords in a paragraph of text in a table card. We insert a <span> tag with a background color to highlight the keyword we've chosen (this is all done in the dataflow before it hits the card). The <span> tags have worked great up until recently, now it seems the system doesn't…
-
Embed Card in Salesforce Account Page
Has anyone placed an embedded card directly on a Salesforce Account page? If so can you share how you did it? If I have customer "ACME Widgets" I want to be able to place a card on their account page that shows how many Widgets we have sold from my widget card I built in Domo for all accounts. I want the card basically on…
-
case when statement in ETL mode, incomplete data result
Hi, When i ran case when statement in ETL mode, there's some condition that haven't shown the result in the right place Below is the same dataset ran in the ETL mode and preview the dataset, my 'Non-paid users' statement didn't shown in the preview nor in my card, tried many times to update.... did anyone met the same…
-
beast mode can fill in the SQL statement?
beast mode can fill in the SQL statement?
-
Beast Mode, text field and number together
Hi, I want to show avg price based on the text field (section). But can't get those 2 together datepricesec 12.18120loge 4 b 12.18 485loge 4 a 12.19 22loge 20 b 12.19 48.5floor ga 12.20 18terrace 14 12.20 527floor 12.20785floor For example, for this 14th December, It would be awesome if I could see for this balcony 3l avg…
-
OLAP direct connector
I am looking for an OLAP connector which can directly connect to a cube instead of via workbench. This will help me to write MDX queries on DOMO cloud itself. Thank you.
-
MySQL Connector Issue
Hey community, We are trying to connect to our open MySQL database. However we encounterred a connection issue. A screenshot was attached below. The note says that 'Failed to authenticate. Verify the credentials and try again. Error setting up SQL connection. Trying to connect with ssl, but ssl not enabled in the server'.…
-
Beast Mode Scale Markers?
I have a chart showing a performance metric across various ads. What I'd like to do is add a threshold scale marker, so that when things fall below we can take action. However, the scale marker calculation is different from my beast mode. IFNULL(SUM(CASE WHEN `Objective` LIKE '%BRAND%' THEN (`EARL`) ELSE 0 END) / SUM(CASE…
-
Removing Comma's from string in Beast Mode Numeric Values
I have a Beast Mode that I'm using to trim a value from a string, the issue is that the trim contains a comma which prevents me from treating the resulting values as a number and therefore suming the totals. Here is the Beast Mode that is producing the trim value: Case When Month(`EventDateTime`)= month(CURRENT_DATE()) and…
-
Admin unable to run update on GoogleSheet Dataset
Recently, a fellow Admin user attempted to run a manual update of a GoogleSheet that has been succesfully updating since October. The GoogleSheet in question and the Domo dataset it powers are owned by another user with Privileged access. The Admin in question (who also has access to the root GoogleSheet) changed the login…
-
Merge not available via API
I would like to update records in DOMO using a specific column/key. This seems to be a part of the "Merge" function when creating a Data Set. I notice the option to "Merge" is available when using the web browser interface but not available when using the API. Do I need to update my DOMO API jars/sdk? See the attached…
-
How to update a Domo dataset linked to a Domo app from the app?
I have built a Domo app and successfully uploaded it into the App design, and linked it to a sample dataset uploaded using webform. Another app used CSV dataset. My question is, what is the code to add new data to the dataset from the app? Is there any JavaScript code or any advice that anyone can pinpoint me to? Thanks!
-
Anyone ever received this error message ? "Domo encountered a maximum allowed usage exceeded "
Has anyone ever received this error message ? "Domo is ready, but Domo encountered a maximum allowed usage exceeded."
-
Calculate and Display Churn
Hi community, I wondered if anyone has been using domo to calculate and report on churn? I'm having a hard time figuring out how to do this. Any help would be greatly appreciated