-
Reports Not Sending
I've set up scheduled reports and I've even just tried to manually send reports but nothign is getting sent out from Domo. I went through and created a second user account on a basic gmail.com domain just to verify it wasn't the ESP, but the reports still aren't coming through. Am I Missing something?
-
do we have any app connecting soccer world cup results?
-
Connecting to Database
Hello All, Good day to you. I am new in DOMO and trying to learn it. As of now, as per my understanding, if I want to bring any On-premise data in DOMO, I need to use Workbench. Now for example, I wanvt to connect one SQL Server Database from my computer. To connect that I can use Workbench and also I am seeing there in an…
-
ETL filter with two criteria on same field - fail
I have a dataset that i'm trying to filter on a text field in magic ETL. I set the filter for Contains, Specific Vaule, ABC. It runs just fine. But then I add a second filter rule on the same column for DEF, expecting a result of all rows with ABC or DEF. as soon as I add any second rule on the same column, the result is…
-
Analyzer for Participant Users
We want participants to be able to use the analyzer, but we do not want them to be able to edit cards on our company pages. Is this possible?
-
Square Root Beast Mode
Is there a way to do a square root in beast mode? This leads to my bigger question about making a beast mode that calculates statistical confidence. I'm not very savvy when it comes to SQL statements, but I can usually manage to get what I need until I tried to recreate the formula contained on this page. If anyone can…
-
how do i expand the number of rows that appear in my report email for a given data table?
Hi there! I have a data table with 70 rows. I created a card that shows the table and scheduled a report to be sent out via email. However, the report in the actual email only shows about 10-15 rows rather than the full 70. I would like the card in the email to show all 70 rows. Is there anyway to adjust how many rows are…
-
Custom connector - append all rows with an ID greater than last appended
I am making a custom connector. The data vendor’s api needs me to send the IDs of the rows I want to ingest, and they can then send up to 10-20k rows without a time-out. So, I need to break up my requests in blocks of 10k rows, and give the ID range each block. I can run this every hour, as each hour will be less than 10k…
-
valid operating systems
Is windows 98 a valid operating system for Domo
-
Transforms in workbench
Hello Admin, Can you please let me know what is the difference between transforms in the workbench and the one being applied at the tranformation level in the dataflow? Thanks, Bharti
-
Standard Deviation
I have a card that shows data points and then a colored range for standard deviation. I want to color the points to show which ones are within my standard deviation range and which ones are outside my range. I tried to make a beast mode but was not getting valid calculations. I also tried filtering the data but there is no…
-
Talkwalker cards
Does anyone has tried to build some cards with Talkwalker? I´d like to see some examples because sometimes I have to create them from the JSON file and I don't know is the best way to do it.
-
Name matching methods and solutions?
Hello everyone, I would like to get any methods the community has used when ingesting large datasets and matching them against data already stored in a database. We possess a large database of business records and ingest data given to us by partners. The criteria we match on are business name and business address to…
-
DO you have any example of Olark Chat Cards?
Hi, I'm trying to make an Olark integration card to know what my customers are chatting in a cloud word and some statistics.
-
Access Token API
I am trying to get API results by calling access token API in the web browser. How can I do that? In the documentation, it states that you could use curl function with -v -u options but if it is a regular url address how would it look like?…
-
Using complex logic with comma-separated column values
Hello! I have a dataset that looks like this (for the purposes of my question, anyway): ID Categories 1 A 2 A,B 3 B,C .. and I want to be able to use complex logic on this field. e.g., WHEN Categories IN 'A' should return 2 rows with IDs 1 and 2, or I want to have a bar graph where the X axis is based on the Categories…
-
How to merge two rows in one?
Hello Everyone, I have 2 datasets using the email connector. These 2 datasets contain information from 2 different platforms (Adform and Adwords), by means of a DataFlow I made a data unification of these two so that they remain in a single data base that I call "Merge Dataset". Now up here, I create some cards with the…
-
Parameter for Filename
Hi, new to DOMO and trying to figure out if I can pass a parameter for the filename when moving data into DOMO. Most of the connectors and the workbench both allow you to select a file from a dropdown but I'm hoping to pass a filename so that I can download multiple similar files with a single job. Thanks in advance
-
create a comma-separated string from multiple rows
If you think of it, it's basically reverse engineer the process of "splitting a string into multiple rows". I have a long list of values that are already split into different rows from the original data source, but now I want to put them back in a single string, separated by the commas. How do I do that? my data is…
-
Converting timezone to GMT
I have a dataset that is updated every 15 minutes with real-time performance data, but this needs to be used by folks in the UK. The card is set to "Today" as the date, so for the period that it is "today" in EST and "tomorrow" in GMT, my card breaks. Is there a beastmode formula that could force my card to be set in GMT?
-
Budget Limit Line w/ Stacked Bar chart?
Hey all, I have a chart like the above right now and have some questions: Is the best way to implement a Budget Limit line through a Beast Mode like this? I was initially thinking of using the 'Goal' function in the Y-Axis but I don't want it to say 'Goal' since this isn't a goal but rather a way for people to see if…
-
I am trying to read a dataset through domo API
While trying to read dataset through Domo API , I am getting the following error: HTTPSConnectionPool(host='api.domo.com', port=443): Max retries exceeded with url: /oauth/token?grant_type=client_credentials (Caused by SSLError(SSLError("bad handshake: Error([('SSL routines', 'ssl3_get_server_certificate', 'certificate…
-
Is it possible to have a text value in the summary number field? (e.g employee with highest sales?)
I know that it is possible to concatenate certain values in the summary number field, and use HTML to change colour. However is it possible to have a straightforward string, dependent upon values in the view? For example, the name of the employee with the highest level of sales over the past year? I hope that this makes…
-
City names on map cards in mobile
The new version of the map cards is really useful espcially with the option to show city names and that the names keep populating as the zoom function is increased. However, I don't see additional cities populate as the zoom is increased in the mobile version. Will that be added at some point?
-
"OVER" function not there in SQL Dataflows - Running totals calculations
I am not able to perform "window" functions (specifically "over" function ) in a SQL Dataflow that I have created. Also - there were no dropdowns that suggest "OVER" exists as a function within Domo for SQL dataflows. It is related to "Partition" and is used in Running Totals. Partition is there, but there is no "OVER"…
-
Adding multiple Sitemaps from Search Console Data Connector
Issue: We have over 90 sitemaps on average in our Google Search Console account that we want to report on. These sitemaps are added & removed regularly in Search Console using Google's API. Ie. one week we may have 92 sitemaps and the following week we may have 97 sitemaps. We want to aggregate the numbers from these…
-
Replacement Variable !{lastvalue:xxxxxxxx}! Date
How can i determine what value/format is acceptable for my replacement variable? The field is a basic date field, and i have not had luck trying a couple formats/ways to express the date. I keep getting a message that says "The '05-25-18' string cannot be converted to the date type." Has anyone used a basic date…
-
Is it possible to snap shot salesforce data on a daily basis to run point in time reports?
-
line chart with vertical line denoting before/after
Hi there, I'm working on a line chart with Date running across the X axis. I'd like to throw in a vertical line on a certain date denoting a "Before" and "After". Is this posssible in Domo? If so, can you give me some pointers? Thank you!
-
Remove duplicates but keep null
Is there a way to remove duplicates but keep nulls? I need to keep null values because that indicates a certain client hasn't reached a stage of our onboarding yet, but if data needs to be run twice in one day for some reason I don't want it to remove the nulls or else that defeats the purpose. Anyway, thanks!