-
ETL: MySQL Identify field triggering Data truncated: Truncated incorrect... Errors
I often get Data truncated: Truncated incorrect... errors when setting up new ETL MySQL transforms. Is there a way to identify the offending field? Thanks in advance.
-
Design Studio App Dataset mapping
First attempts at building an app, hopefully an easy question. As I build the app in Adobe Illustrator, datasets are temporarily hard coded "placeholders" so that I can see would be values during development - ok, got that. When I bring it over into Domo I can attach the "placeholders" to real datasets, filter and group -…
-
Twitter ad - Cant retrieve "Similar to Folloers (followers) of User" Segment
My end goal here is to retrive the list of targetting data relating to handles( ie, when an ad is targeted by a specefic user.group). I believe this is the "Similiar to followers of User" segment ( by the way Domo, your dropdown entry has a spelling mistake ). I have tried returning this by Campaign, line segments and…
-
Updating of dataset isn't implemented as schedule I designed
I set schedule of updating spreadsheet dataset as updating in mornig , but updating never implemented as I set. Why does it happen?
-
Anyone connecting iTunes App Analytics?
New iTunes app analytics was launched in May by Apple. It allows you to see Sessions, Users Active in the last 30 days, Active Devices, and Retention of users. Is anyone connecting to this for their apps? Is anyone interested in it?
-
Textbox Font Size Different on Page View and Card View
Hi, I have several textbox cards next to each other on one page showing different values. I tried setting a font size in the General settings of the card and when I'm looking at the full card itself, things look fine. However, when I'm looking at the page showing all of the cards next to each other, it appears that the…
-
How to cascade filter single dropdowns in Domo App design Studio?
Hi, I'm creating "dashboard" in Domo App Design Studio (Adobe Illustrator extension) and need to cascade filter two single dropdowns values... I.e. when "Region 1" selected in Dropdown 1 then only relevant subregions for region 1 should be displayed in Dropdown 2 and so on... How can i do this? Thanks Karel
-
How to combine 2 cells in a table chart
I created a table card that inclues ID, category, lastmonth value, previousmonth value and % change. For each id, there are 2 categories, thus Id shows in both rows. I would like to combine the 2 rows for Id so that the ID only shows once. Can someone help me with it? Thank you. Olivia
-
Upgrade to 4.62 Can't locate DomoWorkbench.msi
I downloaded the .exe from Domo Admin tool downloads and installed it which did upgrade the Domo Workbench Monitor to 4.62 however I ran into an issue when I believe it is trying to install the newest version of Domo Workbench, see attached screenshot. I'm not familiar with this sort of error, is it claiming that when the…
-
Filled Gauge Chart Built off Results of Another Card
Hi! I'm trying to figure out how I can best make a filled gauge card based off the results of another card (not even sure that is possible). The basic idea is that I'm counting the number of unique dates every month associated with each individual user. So, for example, in July, User A has 3 unique dates associated with…
-
Calculation error in beast mode
I get an error when I try to validate this: CONCAT( '$', SUBSTRING(ROUND(SUM(`Transactions`)/1000000,0),1,3), 'U', '<br /><font size=-1>', SUBSTRING(ROUND(100*(SUM(`Transactions`)/10000000),0),1,3), '% Summary Title </font>' ) Even though this same code works on on a different data source. The transactions variable is…
-
What is a standard workflow for using the Stream API?
I have a OLTP database which I would like to stream/append hourly (new) data to my domo dataset. Since I won't be replacing the dataset in it's entirety, it seems like using the Stream API to push data is the best approach. There are no connectors for cosmosdb in the case to pull from Domo side. The API documentation and…
-
When will the Adwords connector be reinstated? Using the current suggested solution is not tenable
When will the Adwords connector be reinstated? Using the current suggested solution is not tenable
-
How to connect Domo with Goole Ads
When I am trying to add the Google Ads as one of the connectors, it says "This connector has been deprecated". Is there another way to connect it?
-
ETL Append Rows Not Matching Identical Columns...
Greetings all! Am trying to merge two datasets each of which result from an incoming data flow. Each dataset has a column named "Case Equivs" which is a decimal in both cases. However, when I go to Append Rows, it does not recognize that these two columns are a match and insists on adding them both or removing one or the…
-
Creating Workbench Jobs on Other Instances
Hi Everyone, We are setting up our workbench(s) to run unattended on multiple AWS instances but are having trouble coming up with a good way to update the jobs available to each instance - for example, although they are all logged into the same "account" only the jobs specifically imported/created on that machine are…
-
How can I get username of a person who logged in to view a card?
like, when I am logged in it gives my name. when someone else is logged in that user's name is got. basically to customize the report such that when a user opens the card, the data based on his/her name is displayed
-
Can you search for a Metric on a Sumo Card? Scrolling & dragging is hard
Sumo cards are great for data exploration, but one thing that is a little tricky is finding a CATEGORY or VALUE in a dataset with dozens of columns. If there was a way for a user to search categories and values that would make the UX much better. Also if the developer could arrange metrics into "Metric Groups" (example…
-
Get KPI Id by API
We are using the Domo Everywhere (embedded) function with a large number of cards. I'd like to find a way to efficiently get the kpid for these cards programmatically so the UI where we expose these cards can be easily kept up-to-date. Any advice here? Do you plan on offering a card API? We are also using the Domo Publish…
-
Re: Help writing an HTML Beast Mode
Greetings, Can someone help me out with writing an HTML beast mode? I want the sum of this beast mode to display red if negative and green if positive. Can you help me out? Beast mode: SUM(`OrderDollars`) - ('929846')
-
Bubble chart malfunction after update
After the latest update we have observed Bubble chart malfunction. If you add a series to the Bubble chart it stops working and you can see gebbrish values in the Xaxis. Thus you cannot use the color rules or any series for the Bubble Chart
-
BigQuery Connector Permissions
I'm trying to make a BigQuery connector work for some app analytics data. After I set up authentication and a query, I get the following: Domo is ready, but BigQuery returned the following error: Access Denied: Dataset *dataset name*: The user *user name* does not have bigquery.tables.create permission for dataset *dataset…
-
convert number to text
When I upload my excel sheet, the numbers are all formatting as numbers containing commas. How can I get DOMO to see as text? Can I achieve this in excel? I dont want to have to perform a transform everytime I upload an excel sheet with numbers.
-
JIRA Connnector - Can I keyword search?
So I have my JIRA instance connected to Domo. I am able to create charts based on all the fields within JIRA but I can't seem to keyword search? For instance, If I wanted to make a chart that showed all tasks containing the text "Red Flag Alert", how would I go about that? Thanks in advance for the assistance.
-
How to make a stacked bars within Grouped bar chart in one card
I am trying to make a Grouped bar chart where I need to aggregate on two categorical variables and group them. I am looking for a way to have a grouped chart with one set of variable and color the bars in group with the second variable ( stacked chart). Please let me know if this is possible in DOMO. I have tried pretty…
-
How do I share ETL with a Privileged User?
I am trying to share a few Magic ETLs and MySQL DataFlows with a privilaged user. He sees some of them but not all that I intended. I suspect that the etls visible to him corrispond with the cards I have granted this user permission to see, but can not be sure. Some of these etls inform other processes and thus have no…
-
Favorite Color Palettes
With being somewhat limited in what colors we have access to, I thought it'd be fun/helpful to share some of our favorite color combinations to use when building new cards. Outrun / Vaporwave: Cool / Warm: Cool Beach Sunset: Would love to see some yours! Valiant
-
magicParseXML help
Hello, I am running into an issue where I cannot import an XML file that contains more that one set of records. For example, a single record that has 3 columns imports fine: var test = httprequest.get('https://www.w3schools.com/xml/note.xml') datagrid.magicParseXML(test); However, if I try to import something with…
-
Waterfall Chart w/ Variance Sales by Category
I am trying to create a waterfall chart where the first column is the sum of the budget sales (month to date) and the last column to be the sum of the actual sales (month to date). I want the middle columns to be grouped by categories with the value for each category being the variance between the budget and the actual…
-
Amazon Marketing Services Data (AMS)
Hey all, New to Domo and the dojo. Hoping someone can help me with my Amazon connector. First, what I am trying to do is to get all of my marketing spend feeding into a single location. I use AdWords, Bing, Facebook, and Amazon for Ads right now. Does anyone have any success with getting Amazon marketing spend importing…