-
Details about, and alternatives to, the DataSet query API
I gave the datasets/query/execute v1 API a try today, and have a few questions: * What idiom of SQL is this using? It took me some time to get the name escaping done in a way that Domo tolerated. * Is there any dedicated documentation on the system, other than the sparse details I've found at…
-
Magic ETL can use Federated Dataset
Hi, We have number of cases where we want to use Magic ETL using federated Dataset. Can discuss them? Thank You. Best Regards, Tejal
-
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…
-
How can I use domo.onFiltersUpdate to stop App refresh while still getting filtered data?
We have a Custom App on a dashboard with multiple filter cards. We like how the app responds to changes in the filters, but we would prefer it not have to refresh. I found domo.onFiltersUpdate and see that the filter data is passed into the function for use in the event handler, but it's unclear how the filter data can be…
-
Power BI Writeback-Getting error when pushing dataset that has floating decimal datatype to Power BI
When trying to push data that has floating decimal as data type(I even altered the column to integer) from Domo to Power BI using the writeback connector, it throws 400 bad request error. If I remove those columns, it runs successfully. Has anyone encountered this issue?
-
How to compare Value Columns
Hi, Beginner to DOMO so excuse the question. I've created a Pivot table with 2022 sales vs 2023 preorder sales by account and would like to add in a % difference column at the end that shows whether an account is up or down for 2023. How do i go about adding that?
-
I'm stuck. Sum of a Windowed/Partitioned Sum???
I keep running into a wall with this. I think there is an easy answer, I just can't find it for the life of me. My dataset contains one row per store, per day. I want to display -- by region -- the count of stores with an average order value (AOV) less than $20. In order to do that, I first need to calculate AOV by store…
-
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.