-
I can not see the bubble icon to group a column in my card
http://wiki.domo.com/confluence/pages/viewpage.action?pageId=44827298 i cannot find the group option
-
Transforming Datetime
OK so this should seem simple enough: I have a csv file with lots of datetime fields. The values have no seperator and I am transforming for each. Example of typical value : "20141126152526000" so... I have it set YYYYMMDDHHMMSSfff. on 500 test records each of the datetime fields are causing an error. So the question is…
-
MongoDB - non-SSL connection
When adding a data connection to to a MongoDB instance I am repeatedly getting the following error: Failed to authenticate. Verify the credentials and try again. Timed out after 30000 ms while waiting for a server that matches ReadPreferenceServerSelector{readPreference=primary}. Client view of cluster state is…
-
How to create a unique identifiers with the ETL Transform tool?
How do you create a unique identifier as a new column in any data set? I'm trying to create a column where I can have a dataset that looks something like this: Domo1 Domo2 Domo3 Domo4 Domo5 The reason I'm doing this is because I'm trying to join two data sets that have nothing in common, so this would be creating a column…
-
Export card from card details view ignores filters
Wondeing if anyone has come across an issue like this. I've navigated to the Card Details view from my page and selected a different time range than it's set to as a default (card is set to "This Year" - change date range to "Last Year). When I export the card to Powerpoint I only get the current month's data rather than…
-
How I can put Colors in a Table Chart
I need to put some colors in a table chart
-
Is there a way to view the underlying query?
Is there a way to view the underlying query in an ETL? I have an error in ETL and need to re-create it. But in order to see the columns I've selected and which fields are used in the joins I need to open each action individually and jot down what I've done, then make the corrections. Seems tedious. Is there a way to view…
-
Showing percentage gains in bar charts
We have several bar charts that show revenue/bookings per fiscal quarter (or per fiscal year). The question that always gets asked is, "what's the percentage gain/difference between 2 bars?". Any clever way to show this (maybe on a hover or something)? Thanks!
-
Is there a way to pull in Google Analytics Dimensions via the pre-defined GA connector?
I am currently looking for a way to pull in our Google Analytics custom dimensions but cannot seem to do so using the pre-defined GA connectors. I saw in some posts from 05/2015 that people were having to reach out to their Domo support team to have this set up... have there been any updates on this front? I would really…
-
does anyone have a system in place to addresses multiple file uploads and capture through domo
I have requirements to setup an FTP daily, it will take an intial file dump and every 5 minutes following files will be uploaded with changes. Keep in mind Box is our current connector with Domo and our FTP host. For those of you who know, there is a delay between files upload to Box and when Domo can recognize files that…
-
Why do I keep getting an 'out of date' error display on my data sets?
I have most of my workbench data sets scheduled to run periodically. I seem to see an 'out of date' error on many of them, and I'm not sure why. I run them manually and the error goes away, and then the next time the update is scheduled to run, the error reappears (even though according to the workbench 'last execution' as…
-
Import Jobs
We had a job created for testing on workbench 4 and this need to be scheduled on the prod server which is running workbench 3. Due to version change we were unable to import the job. We tried to create brand new job on the server insteading of importing which actually another dataset on DOMO with the same name. Please…
-
Converting data from categories to values
I am uploading datasets from Excel and Domo is pulling specific rows as categories when it should be values. This is making it impossible to create cards with the data. How to a massage the data and put the appropriate fields as values?
-
Best of December 2015!
Greetings and Happy 2016! We finished 2015 on a very strong note kicking off our inaugural Domo Dojo Day event which was a huge success. @nalbright made a very strong return to the Dojo with some very impressive numbers in December. 29 posts, 1 Accepted solution, 2 ideas posted, 19 likes received and 164 likes given!!!!…
-
Using Sumo Cards with Publication Groups
I have a dataset currently running a few cards on a page, and i have multiple publication groups filtered off of this page for various users. I created a sumo card and added it to the "master" page and it shows up in the individual publication group pages, but the sumo card still shows all data, not data filtered by the…
-
Run of Dataflow Times Out
I've got a dataflow that times out whenever I try to run it. The eror message says "Cache file timed out", and it looks to happen somewhere around 10-12M rows. I'm filtering one of the tables to reduce the number of records to process, but the time-out error occurs before it gets to the filter step. Any suggestions?
-
生年月日のデータを元に年齢を自動算出する方法について
皆様、はじめまして。初めて道場に投稿します。 今回ですが、DataSet上に存在する社員テーブルの生年月日を元に現在の年齢を自動算出したいです。 DataFlowを新規作成しまして、下記のような変換ロジックで無理くり年齢算出を試みようと思ったのですが、 変換の手動実行では上手く動くものの、何故かDataFlowの自動実行では該当箇所でエラーになります。 変換例: (YEAR(CURDATE()) - YEAR(生年月日)) - (RIGHT(CURDATE(), 5) < RIGHT(生年月日, 5)) 代替案として、BeastModeでも年齢算出も考えましたが下記の計算サンプル内に年齢の算出方法が存在しませんでした。…
-
how to add oracle dataset
I'm new to Domo. How to add Oracle dataset? All my data in Oracle DB
-
On a table card, how do you freeze the top row for scrolling?
We are trying to build a table card where the top row is frozen for scrolling.
-
Can Workbench queries support Common Table Expressions?
Can Workbench queries support Common Table Expressions (CTE's)? Are the CTE's supported dependent on the flavor of SQL database the user is connecting to? Thanks!
-
Please recommend a better editor than whats in the dataflow Transform to buid and de-bug MySQL
Can anyone please recommend a better editor than whats in the dataflow Transform to buid and de-bug MySQL code. We are a Microsoft shop trying to learn MySQL. Just like TSQL uses Management Studio to buid and de-bug code, I need a better editor for MySQL.
-
Is there a connector to be able to pull data from Generic Jdbc or a HBASe database?
Hi, We currently have all our data in mySQL and Salesforce. We are migrating our MySQL databases to Hadoop, which has Hbase as the database. All our current applications will be changed to use a Pheonix JDBC driver to connect. However, we're not sure how to connect DOmo to this new Db. Can Domo connect using a generic…
-
Why are my values in an excel file being view as text?
Why are my values in an excel file being view as text?
-
Can I perform a calculation in the DATE_FORMAT command to convert UST to CST?
I currently have a beast mode calculation for the hour DATE_FORMAT(`created_time`, '%l %p') I would like to subtract 6 hours from the UST time to arrive at CST
-
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…
-
Is it possible to take multiple linear graphs onto one card?
I have multiple cards with a Running Total Line visualization choice. Now I want to place all these cards side by side or place them on top of each other. (THEY CAN HAVE THE SAME X-AXIS) However each should be able to get their own y - axis. I understand if this is not possible, which is why I created multiple cards...…
-
How to create a drop down list in DOMO
-
Privacy Settings When Creating Groups
Hi, I have 3 departments within the company that will be using DOMO. I want each department to be able to collaborate and share cards/pages/data with each other. However, I want to keep data attached to the cards private when sharing cards or pages across these 3 departments. I set up 3 groups in the administration panel…
-
Customizing tabular cards?
I am wondering if there is anyone out there that is familiar or know of any method to customize tabular cards?
-
How to best get Geonames Data into DOMO
We want to do a lot of mapping. We do not have Latitude and Longitude for the addresses. However if we use Geonames data we should be able to getLatitude and Longitude based on Country, City and possibly state/province. Right now getting all the data from geonames is painful. Its tab delimited data and many do not have the…