-
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.
-
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?