-
Recover Deleted Datasets?
In the process of cleaning up Domo, I accidenly deleted some important datasets. Is there a way I can recover them? These must be backed up somewhere right? Any help is greatly appriciated. Thank you!
-
Modify Business in a Box derpartments
Is there a way to modify the Departments shown in hte Business in a Box page. I like the idea of the Box but non of it applies to us. I can add custom dashboard but as not even the Departments titles work for us it would be pointless in helping people find things. I would like turn the Box into a sort of Library of pages…
-
Near Real-Time Dashboard using Domo Stream API
Has anyone had any success getting near real-time data set refreshes using Domo Stream API? Would you mind sharing the design pattern you used to achieve this? Thank you!
-
URGENT- Please Help: Shopify data connector not working
Hello, Today our Shopify data connector dropped from 69K rows to 9K. We made no changes and pulled up the data connector history to confirm that changes were not made. Runtime average dropped from ~11 minutes to 1-2. How do we go about getting this fixed? We're dead in the water. We don't have a Domo support contract, but…
-
ActiveCampaign Connector
Has anybody created a connector for ActiveCampaign? It is very similar to Infusionsoft, ESP and CRM built into one.
-
How do you restrict the summary number to only sum the top x rows (already filtered in show x rows)?
I'm trying to have a summary number total the top 20 opportunites in our pipeline. I've restricted the chart to only show the top 20 by the "show only 20 rows" option and sorted by size of deal. However the summary number totals the whole pipeline and not just the 20 rows that have been filtered when viewing the card. Does…
-
Running Sum with Stacked Bar
I would like to build a card to show results by time period but also add a line to show the cumulative percentage. Something like the image I have attached. I can build the bars, but how do I add the line that is a percent of the total over these time periods? Thanks.
-
R-Markdown manifest.json creation
In the domopalooza 2018 app there is a video called "Create an app using R Markdown." I'm trying follow allong so I can get some of my data analyses into Domo. At one point in the video he goes to the terminal and runs a domo login command. My terminal isn't recognizing the commands. Where does it come from?…
-
Dynamic R Interface
I am currently working to develop an interactive interface of an R machine learning model we're developing. What we're doing is pulling data down from Domo, conducting machine learning, and then pushing two outputs: * Predicted values for existing data back to Domo (NOTE: This works seemlessly) * Predicted values for…
-
Percent change (WoW, MoM, etc) as a trending line in card.
I'm trying to create a beastmode that could be used in a card to show WoW/MoM/QoQ changes on a trending line. I'm picturing a 'Line + Grouped Bar' graph that would show the actual number value (bar) as well as the percent increase/decrease for each datapoint (line). We've been successful in creating percent…
-
How to change schema of a Dataset created through the Streams API?
Hi, We have data that we want to visualize in domo, and we are planning on loading it into domo using the Streams API, and then building cards based off that data. However, we often need to add columns to our data (eg we start collecting a new property on an event). I can't see any way to change the schema of a data set in…
-
Report on Column with Multiple Unique Values
We are looking to build cards on a field/column that has multiple values from JIRA and need to report on it into DOMO. Fi eld Information: Field contains associates names, and can contain anywhere from 0 to 20 people in this field for each row. This field can contain anyone from hundreds of end users we have today in the…
-
How to reset colour rules saved to a dataset?
We have a situation where some colour rules have been saved to a dataset (ie. apply to all cards) and now want to remove the rules, however can't find a way to do so. The user deleted the card and recreated it so we can't reset the colour rules. As a workaround we set up a beast mode which returns the required values and…
-
Dataset and Card Validation
Hi Everyone, We're trying to decide on a process for dataset and card validaiton so that end users can see department approved metrics and know they are the source of truth for the information they're reviewing. Is there anyone who has a defined process they wouldn't mind sharing? Cards so far: We have sandbox tabs for…
-
Exposing Domo Content to an External Customer - Please Share If You Have Done This
This is an open-ended inquiry. We currently use Domo purely for internal analysis and reporting. I'm curious if anyone has developed functionality to share results with customers, and if so, what DOMO functionality you utilized (eg, Publications, Publication Groups, etc.), what you have found success with and any pitfalls…
-
53-Week Years?
Hello, We often use a 4-4-5 Retail Calendar. We recently discovered Domo consistently shows 53-week years for 2015, 2016, and 2017. Meanwhile, our 4-4-5 calendar only shows 52 weeks for these periods. Upon further review, we determined Domo reports the true retail week 1 as week 2, offsetting all subsequent weeks by 1 and…
-
Quick Filters on a Drill Path Card
This took me a few minutes to figure out, so hope it may help someone else as well! If you add a quick filter to a drill path card, even though it appears in the analyzer/editor view, it will not appear on the saved card -- UNLESS -- you also add that same quick filter to the TOP LEVEL CARD. May be a bug, may be by…
-
MySQL SSH - Provided key is ivalid
What is the format for the SSH Private Key for the MySQL SSH connector? I have verified that I can connect using this user and key in Putty, but I'm getting "Provided key is invalid" in the connector. There shouldn't be any need to whitelist DOMO's ip addresses as the ssh server's ssh port is open to all. The database…
-
Doing UPSERTS via Redshift
As my luck would have it, the genius architects back in IT do an awful lot of INSERTS and UPDATES. At least, it looks that way to me. Out of a 63M row DB, I find about 600K INSERTS and 1M UPDATES weekly. What's a MajorDomo to do? The support for UPSERTS via MySQL and Domo isn't all that good. I tried but just could not…
-
Scheduling
Using R to predict future values based on current data. The workflow is 1. Run Domo workflow to get data from Trello and create actual values dataset in Domo. 2. Run R script using the R plugin to calculate predicted future values and create dataset in Domo containing actual and predicted values. 3. Display actual and…
-
0 Rows returned when trying to use xml tags
I'm trying to bring in some XML data and when I run the import by pasting in the xml, I'm only given one row while my xml data has hundreds. I tried specifying the tag but when I do I get 0 rows. Not sure what I'm doing wrong. Also haven't worked with xml too much. Here's a sample of what I'm trying to pull in. There are…
-
Is there any plan of adding the option to write python code within a magic ETL?
Or even instead of and ETL (similar to MYSQL or R plugins there are today)
-
Can you duplicate a column on a Sumo Card or freeze columns when scrolling?
Can you duplicate a column on a Sumo Card or freeze columns when scrolling?
-
Can we format the scheduled reports in the email? The Report in the Email get's cut off
I've got a card i want to send out for today's wins that's a simple table of the name of the opportunity, the value, and the brand they purcahsed. However, not all the fields show up in the email. You have to click on the link to view the card to see everything. Is there anyway to get it all in the email, so all the…
-
Random Sample from Population already in Domo
I am interested in running experiments with dataset(s) already in domo but want to be able to sample, is there now or are there plans for a way to randomise cases in one or more datasets in domo to build a sample set to run projections on? Preferably Random/Stratafied random sampling. Has anyone found a way to mimic the…
-
Formstack Connector
Has anybody built a connector to Formstack? I know it is an oAuth 2.0 connection and would appreciate any help or insight!
-
Can we get zip code maps in Domo, please?
One map card that is definitely needed is a zip code map card. Please, please build one for us.
-
Can Domo connect to an Excel located on Sharepoint and refresh the charts automatically?
I have an Excel located on Sharepoint Many users update the data through out the day. and at the end of the day I download the excel sheet from SP and then manually upload to Domo whcih refreshes my charts on Domo. Is it possible that Domo can be connected to Share Point, so it can read the excel sheet once a day and…
-
Problems with Microsoft Sharepoint Online Connector
Hi All, I am trying to upload a specific file within a Sharepoint Online folder to Domo. My credentials are validated no problem, but I am getting the following error when trying to run the upload on the my comma separated CSV file: file: File extension specifed in relative url doesn't match with the File Type selected.…
-
How to use a value in previous line of table
I know this could be done in the SQL code and brought in with my table, but hoping it can be dne in beast mode as hat would allow for greater flexibility. I have a table - (sample below) - Assume it is April 15th - end of the day (50%) of the way thoguh month. DateOne, Plan and Actual all are pulled in from an SQL query.…