-
data sync failing
Since about 7am yesterday, when attempting to update a dataset from a csv url, I am receiving this error: Domo is ready, but the request timed out by remote service, please try again. If the issue persists contact the data provider for support. I have tested the data url and it loads in under 10 seconds when hitting it…
-
how do i export a subset of data within a dataset
how do i export a subset of data within a dataset? -Pete
-
Where are files loaded thru workbench placed in Domo?
Hi, Where are files loaded thru workbench placed in Domo? I ran a job to upload an excel file. When do I find it in Domo ? I cannot see it.
-
Understanding PDP, DataSets, and DataFlows
I've finally had a look at PDP as I need to retrofit a page with dozens of cards to filter the data on display for specific users and user groups. When I'm learning something new, I usually read the docs, try it out, and make junky little sketches. If I can't make a sketch, I definitely don't understand what I'm looking…
-
Happy Holidays everyone!
I hope you all take a good amount of time off with lots of rest, food, and visits with loved ones. And don't think about data while you're out. That's your best practice tip of the day! See you in 2018, dojosapiens!
-
Google Analytics Custom Dimension falsely interpreted as number
Hi everyone, I have created a custom report in the GA Connector but correctly importing the most important column doesn't work properly. The GA Client ID is a string of the following format: "1234567890.1234567890". When this is imported, Domo sees it as a number and cuts off some digits in the end. This is what I tried to…
-
Can you bring in Salesforce hierarchy into Domo
Hi, We want to bring Salesforce hierarchy into Domo, can this be done? Thanks, Michael
-
Using the Limit function for a beastmode
Hello, I'm trying a little work around to get a top 10 list for a domo card based on revenue. To do this, I was planning on organizing each company by most revenue and doing a beast mode to limit the companies by 10. I'm not sure if this is possible, but I see that "limit" is a highlighted function for the beastmode -…
-
SQL NetSuite Connector DATEADD Function
Trying to do a simple DATEADD to offset the UTC time change on our date fields. I've tried every which way to format this formula, but nothing works. Just keep getting the below error. Any ideas? SELECT TRANDATE, DATEADD(day,1,TRANDATE) as 'date adj', TRANID FROM TRANSACTIONS NetSuite][SuiteAnalytics Connect JDBC…
-
Two values on Y axis for grouped bar chart
Hi, I want to show two values on Y axis in a grouped bar chart to easily compare two values. Specifically, by project, I want to show budget hours vs. consumed hours. How do I do this? Thanks!
-
How to add widget to canvas in the Ilustrator? There is no visible button?
How do you add a widget to the canvas? There is no visible button. The 'Add Widget' option in the screenshot below gives you the list of widgets available. Clicking on a widget doesn't help either? How to add a widget to canvas?
-
Verifying Transport Settings
We recently upgraded to Workbench 4.5, and ever since then, whenever browsing to a dataset job & clicking on the "Source" tab, workbench takes an extremely long time on "Verifying Transport Settings". While this would happen on 4.0, it was never longer than a few minutes. But for example, yesterday I was stuck on this…
-
How do you filter out columns that have no summed results?
I have a chart where I'm using a Name as the group and some of the columns have a Zero Sum result that I don't want to see. See image.
-
Convert values using mapping with case
I have 2 columns, primaryAssemblies and secondaryAssemblies. A person could have "Clinical Care" as their primary assembly. They are allowed at least 1 secondary assembly. So it may look like "Critical Care, Pediatrics" I need to count each occurrence like so: (CASE when `PrimaryAssembly` like '%Allergy Immunology &…
-
Convert Date and Time string to Date and Time column using ETL's "Set Column Type"
Given a STRING column with a value as "1/13/2017 2:40:18 PM" I get error can't convert Is it possible in ETL?
-
ETLフィルターの「先頭の文字列」がうまく認識されない件に関して
現在ETLで様々なデータを作成しておりますが、 フィルターで「先頭の文字列」で指定した場合、うまくフィルターがかけられないことが続いています。 確認したところ、「先頭の文字列」にせず、「次を含む」にすると抽出ができました。 ただ、「次を含む」だと文字列の中盤・後半に含まれている場合にも抽出されてしまうため、できれば「先頭の文字列」で一致させるようにしたいです。 これはどうして抽出されないのかお分かりになりますでしょうか。 ちなみに、先頭の文字列に別の文字が入っているなどということはありません。 よろしくお願いします。
-
Goals vs. Actual
Okay, so I'm trying to visualize two sets of information on one card. The first is our stored Goal, which is in one datasource being pulled into Domo. It's stored by Month and Year (two separate fields unfortunately, but I can work with that in ETL), and is a given number for the goal value - let's just say 100 for…
-
MySQL ETL: Temp Table Functionality
Good morning, I have a MySQL ETL that currently has 15 transforms that are used to create a scorecard in Domo. I would like to reduce the number of transforms as much as possible. Can a transform support the temp table function in MySQL? @zcameron We discussed this a little bit at the Charlotte meet, but I really need…
-
Unique Customer Name and total spent
I'm trying to sort through a bunch of orders and get the customer name and the total spent for that customer. However, I have a customer name associated with each order. Meaning I can have 50 customer names. Same concept with the customer total spent. That information is totaled on each order row. In short this is what I'm…
-
Upload gzip data with stream API
According to the example provided, I can upload gzip data using the following: echo '"location","username"' | gzip -c | curl 'https://api.domo.com/v1/streams/888/executions/197/part/1' -i -X PUT -H 'Content-Type: text/csv' -H 'Accept: application/json' -H 'Content-Encoding' -H 'Authorization: bearer <my-token>' -d @- It…
-
Using calculated fields in Card Summary
We have two series listed on a stacked bar graph. Both series use a calculated field. We would like to show the totals across a time horizon as a summary number for the graph. However there seems to be no way to show values. Also it seems we can't select a calculated value. Is there another way to achieve this? Thank you.
-
Calculating Beast Mode YoY and MoM Type Calculation
Hi all, I want to calculate a YoY or MoM calculation for each month in which data is available for such comparisons. I would then like to possibly create a chart showing the trend of my YoY and MoM % changes. The Example data looks like this and I would like to calculate a column of YoY and MoM and trend it:…
-
Default Date Format (date in data has MM/DD/YYYY, DOMO defaults to YYYY-MM-DD)
Hello, I've got a datastream pushing dates through in MM/DD/YYYY format *(CONVERT(VARCHAR(10),Date_Field,101))* And DOMO seems to accept this no problem, but when I report on the dates, it pushes them into its default format of YYYY-MM-DD. I know a work around is to do a beast calculation and store as a date type- but I'd…
-
CURRENT DATE Issue
I have an issue with the CURDATE() function. I have the following beast mode: CASE WHEN `Closing Date` < CURDATE() THEN 'Past' ELSE 'Current' END I use this beast mode to not sure the incomplete data from the current day (so I filter on Current). However, the data for the previous day doesn't update until 11am. Our…
-
R Script Import Errors
I am simply trying to download a dataset from Domo into R Studio and am getting the following errors: Warning: 3 parsing failures. row # A tibble: 3 x 5 col row col expected actual file expected <int> <chr> <chr> <chr> <chr> actual 1 4036 transactions an integer 2628473349 <raw vector> file 2 36821 transactions an integer…
-
Best Way to Represent Dates as Columns in Table
First time I've come across a requirement like this. The goal is to see each month and have a calculation of the variance %increase or %decrease for that month and highlight them when it's a certain amount. The table view isn't necessarilly a requirement but the series contains over 200 records so i'm finding it hard to…
-
Multiple Series for Symbol + Grouped Bar
I am attempting to build a Grouped Bar + Symbol card where there will be three bar series based off of a value in my data. (Closed, Lost, Won), as well as a symbol which would be a calculation based off of those numbers. Right now the card appears to only let me use my one category as a single series as opposed to allowing…
-
App Design Studio Gauge Values as Decimal Percent
I am building an app in Illustrator and I want to display the value in a needle gauge as a decimal and percent (e.g. 18.7%), however, these gauges are automatically rounding to a whole number and won't let me use a prefix or suffix. Is there a way to do this?
-
How manage large Domo instances
Hi, I'm interested in hearing how others manage large numbers of cards and datasets, ... I'm looking through the API instructions and can see they cover page, and datesets pretty well by not the in-between, cards. How do others manage an ever growing domo instance?
-
Export Any DOMO Data Set As XML Using Python API?
Has anyone ever made a script to export any DOMO data set as XML (where each field is treated as a tag)? I was asked if DOMO could be used by someone other than our development staff when our clients need a particular summary report as an XML file that they could ingest. I imagine with DOMO, the business analyst could…