-
prioritize recent data for input datasets in dataflows for preview
We all run into the situation where we have two tables with hundreds of million of rows and we drop them in the dataflow and know that our join transforms will never match up. Could we get the most recent 10k rows from the input datasets rather than something seemingly random? That would really boost our ability to…
-
Adrenaline dataflows should not re-evaluate the schema of an inbound dataset.
I have discovered that a dataset being brought into an adrenaline dataflow, will have its schema re-evaluated based on the first x number of rows coming in. In my case, this resulted in a google sheet dataset coming into the dataflow with an important text field being reassigned as a number. all the text values were then…
-
Open dataflow version comments for edit after the save
We have a difficult time getting people to document the changes they have made to a dataflow. I would like the ability to go back and document a certain version of a dataflow after it has been saved.
-
Anyone else wanting to join to the same table multiple times in a view?
I have a dataset with regional director id, regional vp id and senior vp id and I want to join to my employee master on each of them but you can only bring the table in once. it would be really convenient to be able to use a view rather than a dataflow.
-
Notification on Domostats dataset failures
I just saw that some of our domostats datasets had not been updating for almost 30 days. I discovered this because I was alerted that some had just been deactivated for failing for the last 30 days. I use the user dataset and the activity log dataset to boot inactive users. I need a notification when the dataset fails, not…
-
Ability to impersonate a user
We frequently have situations where a user can't see a page or they get "request access" on the cards. To help us diagnose the issues, we would like to be able to impersonate a user, to see what they see.
-
column heading in pivot table cards spanning multiple columns
We have some pivot table cards that we want the header to span all three columns for the week but we have not found a way to get Domo to do this. See below, the date range of the week should span counted, hit count, and hit ratio. I would have expected that behavior, not having the dates scrunched into the middle column.…
-
Drag and Drop between Adrenaline dataflows
I am in the process of splitting a dataflow that developed for two purposes over time. It would save me a HUGE amount of time if I could drag a transform from one dataflow to another. For that matter, dragging a transform within a dataflow to re-order them would be very helpful. This is within Adrenaline. We use adrenaline…
-
Error in Workbench
I recieve the following error. has anyone seen this? C:\Users\a111661>"c:\program files\Domo\workbench\wb.exe" queue-job --server radioshack.domo.com --jobid 191 No connection to radioshack.domo.com I have not been able to find any entry in any logs related to this.
-
waiting to send a report until critical dataset updates - hope this helps somebody out.
We needed to wait until a certain, slow running dataset had finished before sending out reports. With lots of help from Domo, here is what we came up with. I am trying to scrape the interal info, hopefully I do not scrape too much. This is a powershell script we call from a bat file scheduled in Windows scheduler. you need…
-
How do you Whitelist the Domo.com domain so messages are not blocked as spam or marketing
I had to ask this question when I was at RadioShack and now at Daltile. This relates to alerts, notifications, and scheduled reports that get relegated to the spam folder or outright blocked. The answer from Domo Engineering is this: "We use AWS best practices for sending our emails through Amazon SES (Simple Email…
-
anyone pulling statistics from STatCan (Canada Statistics) ?
They have some APIs but I cannot get them to work with Domo... I am hoping someone else has already invented the wheel. https://www.statcan.gc.ca/eng/developers
-
Reference to the row number in a beastmode
We are loading data from Domo exports into another system. We created a card that looks like our import file and simply export to Excel. The first set is 500,000 rows but must be uploaded in chunks of 20,000 rows each. I wanted to create a column that gave me a number incremented in chunks of 20,000. This was simple in…
-
Audit API not returning times or actor info
Following the example code provided at the API training, I created a script to read data from the audit logs to push back into Domo. I got it working with one small issue - The actorId is always "0", the actorType is "undefined", and eventTime is "undefined". We got a few records with an actorId but they were all Domo…
-
Is there a way to create a URL to a page adding a custom page filter
I would like to create a link to a Domo page (in a card) that would be filtered based on the value clicked. Much like the link from Salesforce data into SalesForce, I want to be able to click through the sales data down to a specific customer, then click that customer and have it take me to a page that is the customer…
-
Is anyone using the DomoApi?
I was not sure where to post this question but "New to Domo" seemed as good as any- I did not see a board for DomoApi or SDK. If there is anyone out there that is using the DomoApi and c#, I could really use some help. here is my code, and question: public async void GetPayPalSettlementFiles() { String DataSetID =…
-
We use 3000 as the year for "forever" it shows in data preview but not in the final dataset
Our employee team assignments are dated with a start and end date. If it is their current assignement, the date is 1/1/3000. I discovered that when I bring the data in through workbench with a select *, it recognizes it as a date column and displays 01-01-3000 in hte data preview but when the dataset is created, it is…
-
How to do a partial replace in a dataset?
Time card data gets updated very frequently and is in a parent child relational database. I want to keep that structure at the base level in Domo. The tables are work summary and work detail. The details are deleted and recreated in the applicaiton when the time card is updated. How can I update the work summary record in…
-
Is there a way to join data on a date between a start and end date?
This is really a data flow question. I have assignments in one table that have a start and end date. I am trying to join this to daily activity. set one look like code start_date end_date sm 1/1/2015 2/1/2015 asc 2/2/2015 6/2/2015 then there is daily activity and I need to see how much daily activity happened under each…
-
add groups dropdown in user maintenance
The add to a group dropdown in the user maintenance page under governance, needs a scroll bar. We have almost 5,000 groups, many with very similar names and there are only 10-12 slots in the dropdown. Go to Governance, people and select a user. Then click add to groups. click the search dropdown. very limited search…
