-
Reporting on a dataset e.g. duplicates, null values and data types
I was wondering if someone could help? I have a dataset containing 196 columns, I would like to know which of the columns are entirely null, which contains data, what level of duplication the field has and what type of data is in the field. There is a similar question here, but this is more about removing as opposed to…
-
To create ETL
I want to get a new etl by connecting two datasets. All stages are working, but they do not pass to the output part. When I press the save button, it does not save my work. Also, I was able to combine a data set and a file that was on my computer before using the "join data" command. Now this option is not active. I cannot…
-
Dataset Archiving
We would like to be able to see whether a dataset is archived or not within domostats datasets, and we would like the option to 1) manually set a dataset into archived state, or 2) prevent a dataset from going into archived state.
-
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…