-
Calendar Creation
Hello - Can I create a calendar table based of a start date and end date? I have the start date and end date that encompassed a week, and then the columns for sunday to saturday what I am trying to achieve is, to put dates as well to the columns for sunday to saturday for example: the start date is 9/4 and end date is 9/10…
-
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…
-
Import CSV File via Python (Domo API)
Hello, community, I am currently writing a python app that will allow me to import CSV data (per the requirements of the developer.domo.com API reference). When uploading the CSV file via the python SDK and/or using PUT command, I get a 400 error. Error: Error uploading DataSet: {"status":400,"statusReason":"Bad…
-
Datasets join issue
I'm trying to create a card that can be used to present to budget owners how much they have currently spent for the month compared to the budget they've been given. In order to do so, I have to create a dataflow that involves joining 2 datasets; One is Netsuite, which stores all the journal entry transactions, and the…
-
Ignore Row Context / Power BI 'ALL()' Equivalent?
I mocked up a simple example to illustrate what I'm trying to accomplish. The question is: how to create a beast mode which will ignore any filters and/or table row context applied to a column, in this case `Store`. The goal is: calculate Average Order Value for the entire dataset (Total Company), so individual Stores can…
-
Attempting to create unique rows for each possible value in a chosen column
Our business model currently offers multiple product options. I'd like to create brand new rows for each customer, 1 for each product, whether they own that product or not. My thought is to use new columns and then use a dynamic unpivot. Need help creating the new columns first though.. Currently have this: Account Product…
-
Dataset/Card Certification History
Hello, I was wondering if there is any location in Domo where one can go to to view the history of a dataset and its certification status history. For example I have Dataset A and it is currently certified but a change was made in the ETL and it now has an expired certification. I now need to resubmit the certification for…
-
How can we download list of beast mode made on particular Dataset ?
Like I can see the list of all beast mode on a particular dataset on beast mode manager .But I want to download them also as per the particular dataset . Suggest me some way if there is any .
-
How do you pull Revenue data from Facebook connectors?
I'm trying to create a marketing dashboard for my company that looks at revenue, spend, ROAS, etc. I am able to pull spend and a value for ROAS, but I can't seem to find the variable for revenue. I know Facebook usually refers to revenue as "purchase conversion value" but I can't find that variable when selecting the…
-
When I click on Edit View domo goes blank and I can't edit. What is happening?
This is something that happens somewhat frequently with different aspects of Domo. Has happened with views, ETLs, beast modes, and cards. At this point, we are starting to transfer dashboards to Power BI. We're paying extra for a personal support team from Domo, and they take forever to respond, and when they do they give…
-
How to join to a table multiple times?
I'm struggling to replicate a simple type of join my company does all the time in SQL Server within a Domo DataSet view. Perhaps this isn't possible to do yet. I'm hoping someone can help out. Attached photo which has most of the complexity removed, but shows what I'm trying to do. We see "Transactions" in one table, and…
-
Why would I use a DataFusion instead of a Dataset View? Will DataFusions be deprecated?
If a DataFusion has limitations on what can be edited after it's created, why would I use one instead of a Dataset View? When making certain changes to a DataFusion, you get the prompt that it is "no longer editable as a DataFusion", and must be saved as a Dataset View. Since Dataset Views are a lot more powerful (but…
-
Facebook Ads Advanced Connector Error - "You are calling a deprecated version of the Ads API. "
I have facebook ad level data and Facebook campaign level data being pulled in daily - today it didn't run automatically and is running the error: "DOMO is ready but Facebook returned an error: (#2635) You are calling a deprecated version of the Ads API. Please update to the latest version: v13.0." What do I need to do to…
-
How to create 2 Output Dataset in DOMO (unable to load this dataset issue)
Hello everyone - Good Day! I just need some inputs. I have a dataflow with 4 input dataset and 1 output dataset. When I add another output dataset and hit preview, it showed all green checks. However when I saved and ran it, that 2nd output dataset shows as "unable to load this dataset"? any reason why it is unable to load?
-
Filtering table -- cells can have multiple values
I have a dataset table with filters. Some cells have multiple values. Say I have a column called "Device." Row 1 can have "Desktop, mobile" and Row 2 can have "Desktop." I want to have a filter called "Desktop" that shows all rows containing any instance of "Desktop." When I do the beast mode formula: case when `Device`…
-
Period over Period in a table
I'm attempting to do a Period over Period in a table, but want to keep the date range to previous week/month/quarter to keep it auto-updating and grouping the data in a particular way. My idea was to create a new column in ETL that is the same as the column I'm trying to do a Period over Period calculation, but from the…
-
group by and sorting by date
I have daily data (years of it) that will be grouped by category (columns summed by group), but also need it to happen within different date ranges. Last week, MTD, QTD, YTD etc. The only way I can think to do this is maybe in the ETL creating a new column with case statements for each category/date possibility, but this…
-
Reverting Back to the old dataSet version
Hi team, I changed a few things in my recursive ETL dataset and lost all the rows of data that were recursed in it. When I try to revert the flow to a previous version, it does not show the lost data rows. Any way to retrieve those?
-
How to remove empty columns from a dataset?
I am using a DOMO connector to import Salesforce data. The imported data has 30+ columns with no value. Can a query be written to remove all the columns with no values? I know I can write a script using Python/R but we don't have a scripting tile in our package.
-
Adding values from two datasets
Hi, I'm looking to add values from two datasets into one value. One dataset is Completed panels in 2022, the other dataset is Completed awaiting power in 2022. What is the best way for me to do this?
-
Adobe Analytics JWT v2 Connector Multiple Segments
Hi, I'm wondering if there's any way to apply 2 (or more) segments to an Adobe Analytics report built through the JWT v2 connector. I realize a possible workaround is to just go and create a new segment in AA which combines the rules from the 2 or more segments, but this is not always feasible based on the number of…
-
Pendo connection: how to add a date column to a dataset?
Hello! I have created a Pendo connection to domo but a date column was not pulled over with the data. I was wanting to add a column to the dataset and put the date that the corresponds with the data but am struggling to do so. Does anyone have any ideas on how to do this?
-
Has anyone pulled data from ActiveCampaign?
I am working on getting data from ActiveCampaign into Domo and wanted to see if anyone has succeeded in this.
-
A connector more reports every report put data in a different dataset
Hi to all, i wish to have a connector where every report make a call to a different endpoint of an API so i wish that every report write the data in a different dataset. I know how to build different report but I havent found the way to put the data of a report in a specific dataset and the data of another report in an…
-
Comparing two datasets for missing sites
Hi, I'm looking to compare two datasets from Smartsheet to identify which sites are missing from one dataset. For example, show me all sites that are in 'Master Schedule' but aren't on 'Secondary Schedule', both sheets have identifying numbers in column 'URN'. What would be the best way for me to do this? Would I join…
-
How do I change the data from being horizontal to vertical using a calculated field?
My data is currently horizontal so each column has a different month with the totals below (example below). I would like the data to be vertical so that it is easier to display the data visually within domo. I have placed an example below. I am not sure how to make a calculated field to display the date and totals…
-
Workbench Job to DOMO stuck on "Connecting"
I have a workbench job that has been in the "connecting" state on the DOMO side for over 4 days. Is there anyway to kill it? The job on the workbench side has already been stopped.