-
how can I link a dataset to all the tables in a database - using a SQL federated connection
If I have a valid federated connection - that I can browse all the tables - how do I link a dataset to all the tables? (I've done it once apparently - but now I can't figure out how to do it again)? Every option I come up without only lets me select one table at time - and that can't be right… I've got o be doing something…
-
How do I filter by most recent date?
We have a dataset that get multiple 'loan_id' entries recorded (shown below) However, when I go to remove duplicates on any of the columns, I generally get the wrong loan amounts. The correct loan amounts are always the ones with the latest 'time_stamp' I am hoping to remove any duplicate 'loan_id' based off the latest…
-
Retrieving Data from a partner's Domo sit
Hi everyone! I have been using Domo for a little under a year. Today I realized my organization pulls data from one of our partners domo dashboards manually which is then uploaded into our domo data each month. Is there anyway to create a pipeline between two organizations Domo sites to feed our datasets?
-
How do you restrict access to Admin Panel for normal users?
I noticed today that ANY user in Domo can access the admin panel - how do you restrict this? As far as I can tell there are no options for restricting this in either by roles or groups, and there's nothing available on admin/security options either. These end users are able to see the full list of other users setup in the…
-
How to disable SQL Editor on a View once it's been enabled?
I enabled the new SQL Editor on one of my views this morning to troubleshoot an issue: it's a wonderful tool, and helped me solve a very bizarre problem. Unfortunately, the editor takes up a lot of screen real estate, so I would like to disable it and return to the normal form of the view now that it's no longer needed.…
-
Considerations for migrating Salesforce to a new org
Our company uses the Salesforce connector and we bring Salesforce data into Domo with over 200 reports, flows and cards using this data. Our company was acquired and we are being asked to evaluate migrating into the parent company's Salesforce org. The Domo dependencies are one of our bigger concerns. We have a consultant…
-
Can a workflow be used to set off a dataset update and ETL run?
Can a workflow be used to set off a dataset update and ETL run? It's currently on a schedule for every 4 hours M - F but every Tuesday at 10:45 I need to run it one extra time.
-
Domo - Dashboards and underlying pages and users data or dataset info
Hi, I'm trying to identify the total Dashboards and associated pages and cards with users info, I'm trying to identify if there is any stats dataset that shows dashboards and associated pages and cards info. I see there is Dashboards info under Admin→ Content → Dashboards where its showing parent dashboard, dashboard and…
-
Card/Control could not load
I have some Cards and Controls that are not loading. I need to figure out why they won't load and also set some type of alert/notification when they don't so I can fix them (hopefully before a user accesses them).
-
Unable to save view
What could be issue with me being unable to save a view? I know it's not permission or browser related
-
Is it possible to do a background change (At once) to some or all cards on a dashboard?
-
Batch Move of Cards from the Appendix?
Is it possible to "batch select" a group of cards to move to a dashboard (rather than moving one at a time?) in the Appendix?
-
Assistance Required with Locking DataSet in DOMO
Hi everyone, I am currently in the process of uploading an Excel dataset to DOMO and am seeking guidance on a specific functionality. My objective is to restrict access to this dataset, ensuring it remains confidential. While I have noticed the option to lock cards in DOMO, I have not yet found a similar feature for…
-
Reporting/Exporting Domo Cards in a specific visualization
I'm working on Survey Data Visualizations and would like to compare the cards used in different visualizations. For instance, I'd like to know the specific cards referenced in a visualization but I don't know how the cards are identified in Domo. How are Domo cards identified or referenced? What is the Domo card field type…
-
Output Dataset
I am getting an error with my output dataset. Also, I need the output dataset to be the ETL data flow. What do I need to do to fix it. Thanks,
-
How to find out shared datasets
I am looking for assistance in understanding access permissions for multiple datasets. While its straightforward to check access for a single dataset through the share option. I am uncertain about how to determine access for multiple datasets. Is there a way to identify the users with access to multiple datasets? Thanks
-
I would like to do predictive lead scoring for my data
Hi, I have a dataset with the leads information (demographic, titles, etc..). What would be the way to build the predictive score in Domo? For example, Domo can help me predict the score of this lead based on the assigned columns. Thank you for your help!
-
How can I copy PDP policies from one dataset to another?
I have a dataset I needed to recreate for various reasons from an existing dataset with pdp. i want to be able to copy the pdp policies from the orig dataset to the new dataset. How can I do that?
-
Dynamic PDP
What could be stopping data from showing after applying a dynamic PDP? I created a dashboard that has about 5 ETL Datasets. I then created a user lincesed group of 27 people and all theses users I created an attribute called GROUPING and assign the locations they can only access or see that locations' data. I then set a…
-
Dataset Views - JOIN on date range?
In most database systems, you can create a join/view on date ranges like so: SELECT * FROM A1 JOIN A2 ON A1.ProductID = A2.ProductID AND (A2.SalesDate >= A1.StartDate) AND (A2.SalesDate <= A1.EndDate OR A1.EndDate IS NULL) However, a DataSet View in Domo only seems to allow joins on exact values and does not allow ranges…
-
Counting nulls/blank cells in beast mode
Hello everyone, I am struggling with the syntax a bit on how to count blank cells/null values in a column. Basically what I'm doing is COUNT(CASE WHEN column name IS NULL) Would greatly appreciate any help!
-
How to fix datatype of variables when upload data from R to DOMO?
Hi, I am trying to upload a data frame from R environment to Domo using ds_update. One challenge that I am facing is that somehow DOMO automatically changed one column into Date, from numeric. Because the value in that column ranged from 0 to around 890 thousand, I guess DOMO thought they were numerical date… (like in…
-
Remove individual members from view
I have created a view as an admin on top of an ETL and this view is shared with four groups. However, after some time I observed that individual users are being added within the user group, even though they are already members of the group. What should I do to prevent individual members from being added?
-
Flatten relational data for import?
Hi, First time using Domo. I have a highly relational database with about 20 tables in postgresql. Should I flatten these tables in pgsql before importing to Domo or should I be importing all 20 tables and doing the joins in Domo? What is best practice. Thanks
-
Getting Data
Hi, I'm new to domo and was just wondering if anyone could generally tell me how I can get data from a dataset in domo in a ddx brick? Thanks.
-
Dataset Tabs appear to be hidden for some datasets
Hello, When I click on a specific dataset (for which I have full edit access to) I seem to not see any of the tabs at the top like the overview, data, cards, etc. I thought maybe I have restricted access but if I manually input in the url "/data/table" after details, I can see all of the data. Any idea how to bring these…
-
Need Tips for Optimizing Data Visualization in Domo
Hi Domo Community, I'm working on improving data visualization in Domo and would love your tips. Any advice on creating dynamic dashboards and using advanced charting features? Thanks,
-
How to create a dataset based on another dataset
Hi everyone, I would like to create a calendar table based on an orders data base, based on min and max date from that. Do you know a way to do it? Thanks for your help Eduard
-
Moving Dataset,cards,dashboards between different domo site
Hi Team, We are planning to move the domo cards,datasets,dashboards created site1 to site2,site3 etc. Can any one suggest best way to migrate all content from one domo environment to other. Ex: j&J.domo to DCA.domo,JON.Domo.com
-
How can we create a Dataset from Excel in DOMO?