Dataset

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.
External Trigger to begin Dataset Import
Today for datasets we only have a scheduling mechanism to update a dataset. It would be nice if there was an API or webhook we could trigger externally that as soon as data is available, to have Domo to pull in the fresh data. This idea has been talked about before but the discussion was closed. I wanted to add my voice…
Ideas for new features in Domo from AMRO
Hi! We came up with some suggestions for new features in Domo in one of our recent internal discussions, that we would like to share with Dojo members. We think these enhancements could be useful not only to us but other Domo clients too. (if the image is not clear please see the attached excel instead) Really looking…
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…
Grant that allows viewing of datasets but not editing
Currently, if I'm not mistaken, there is no grant that allows a user to view datasets in the data center or the dataset detail view without also being able to edit datasets they have access to.
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…
Dummy dataset for demos and internal use
It would be great if we could have Domo setup "out of the box" with a dummy (i.e. fully public, anonymised) dataset we can refer back to for demos and tests. This would prevent us from having to take existing data & sterilise it for use in presentations and tests. We can become familiar with this data and improve our…
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…
Mass dataset change on duplicated cards
I was using one dataset to create all of my dashboards and cards, but I had to split it up into smaller datasets for performance. Now I need to duplicate all of the dashboards with duplicated cards and change the dataset on each one. I would like to see a way to change selected cards to a new dataset. I saw the post about…
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.
Breaking data per month viewed per week
Hi DOMO - Good Morning! we have a data that shows per week data per resource. and we only have 2 date columns which starts from Sunday and ends on a Saturday. the total hours, and daily hours have all been already grouped by using magic etl.…
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…
Write your own SQL in Dataset Views
It would be ideal to be able to write your own SQL in the Dataset Views UI. The process for defining views can be very slow especially if you want to add a calculated aggregated column AFTER you've applied the GROUP BY clause -- because you'd have to ungroup the VIEW, define the calculated column, then reapply the…

Dataset

Discussion List