-
Using Python API to Update Already Created Datasets
Hi Everyone, I am trying to find a way to upload information from a python script into a domo dataset weekly. I am finding that you can't update an existing dataset with this method, only create a new one and update that newly created one. Has anyone found a workaround for this? In the documentation it appears this is…
-
Why do all Redshift Datflows (still) convert all variables to lower case?
Hi, we're currently doing an audit and noticed that legacy datasets have 2 versions, with the 2nd version just capitalizing the variable names (often a magic ETL). The first version is in Redshift - building dataflows in redshift is quite popular within our team because it has fuctions that mysql dataflows doesn't have.…
-
Can I search for column names across all datasets?
How can I search ALL datasets for a word in the COLUMN name? For example, I want to see all datasets with a COLUMN name containing *address*. Search on the Datasets screen only searches within the dataset names.
-
Refresh Excel datasheets that have been uploaded via Plugin
I recently started using Domo and have an Excel spreadsheet with several tabs that I uploaded to Domo via the plugin. I created a dataset for each tab and then appended them for a single output. This spreadsheet is updated by a few different people and I need to update it probably 2-3 times/month. I tried searching the…
-
Trimming and converting a Date/Time Field
My goal is to filter all times between the hours of 9PM-5AM, but the data in my field looks like this: 2021-12-31T21:20:49 How would I trim this field to get the time exclusively and possibly convert it to 12-hour format? Thank you for your help
-
Can we export output data from a workflow in ETL?
Hi All, I wanted to know if there is an option where we could get the output data as an Excel file(like a downloadable excel file) or even have the feature where the output data can be uploaded to a service/server from the workflow or at least have the output in format of a downloadable excel file.
-
SyntaxError: Invalid JSON when using the DOMO Governance Datasets Connector
Hi DOMO - I just want to know why I am getting this error when I try to create a dataset using the DOMO Governance Datasets Connector > SyntaxError: Invalid JSON: <json>:1:0 Expected json literal but found N No subject alternative DNS name matching five9.com.domo.com found. ^ at line number 24 Need help to know what I am…
-
Data Type Reference in Datasets
So I have been digging for a bit and I found a few threads that list the data types available in a dataset. But all the information seems to be embedded in other items. See this post https://dojo.domo.com/main/discussion/44484/datatype So I am looking for a very simple table that shows the data types available in domo.
-
Export card to Excel using API
I have a card containing numerous beastmodes and I can export to Excel through the UI and maintain the look of the card as well as all the filters. Is it possible to do this same action through the API? From the documentation I only see the option to query datasets, which we have done extensively, but I would want to query…
-
Is there a way to retrieve or export cards data to csv using Domo API?
I have a page created with a number of cards. Is it possible to retrieve card data or export to a csv using the API? I know API allows to export datasets to csv, but I can't find a way to do the same for cards. If not possible, is there any workaround to set it up in Domo so I can only retrieve card data with the API and…
-
How do I format?
Hi all, I am working to generate a report but am not sure how to calculate in Domo to get the visualization right Right now, we are looking a property type breakdown by year - included on the y-axis is the number of loans we had each year. We are trying to keep the years on the x axis but only show the property type…
-
How to properly partition in Workbench while allowing older data to come in?
I have a SQL Server dataset of 50M rows. Workbench runs the APPEND Update Method HOURLY. I use the table ID as the UPSERT key and the processing query checks the past 7 days ("Insertion Date") for new records. This updates older data unnecessarily with the same data, but protects against issues with the job not running for…
-
How to Remove Duplicate rows in analyzer?
I have used the LinkedIn connector to export the stats. I see duplicated rows. How do I avoid them?
-
In Dataset Data tab, add null as filter criteria for date fields.
I need to be able to filter on the presence or absence of NULL in a date or datetime column when looking at a dataset on the Data tab. If there's a way to do this that doesn't involve creating temporary subsets that filter based on a formula or beast mode, please let me know.
-
how to break a week between months
Hi DOJO - Happy Weekend! Basically, we have a dataset with date columns based on the start of the week and end of the week only. on the example below, I just concatenated the start and end dates so it shows Aug 28 to Sep 03. if its not concatenated, I can put start date and it would show the start of the week which is…
-
Data Center Folders
Customers with hundreds of datasets would benefit from a hierarchical folder system to organize and categorize their datasets.
-
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 .