-
Pulling PNG Images into DOMO using FTP server calls via SKU keys
Hi, I have sales data with product information that aligns with our PNG files names inside our ftp server, where all our images are stored. Is there a beastmode where it will populate an image to the table view through calling the ftp, using credentials and some sore of concat(key in below examples) of the data's…
-
Re: Period over Period using stacked bars
I was looking to add an extra layer of granularity to my period over period chart. Basically I want to combine a Year over Year card, and a stacked bar so we can quickly see that the balance between the two components isn't changing. With this chart I'm just looking to see the quantities, and I'm not going to be digging…
-
Scope "audit"
Hi, When I am trying to call Activity log endpoint - https://api.domo.com/v1/audit, I am getting the following error: { "error": "insufficient_scope", "error_description": "Insufficient scope for this resource", "scope": "audit" } Scope "audit" is required to perform this action. On new client create form only three scopes…
-
Can we copy Magic ETL actions from one data flow to other data flow?
Hi, When I have some complex requirements, I create a copy of ETL and test it there first. Once it is worked then I used to replicate the same steps again in he actual data flow. Can we copy the Actions directly from test ETL to the original ETL instead of doing all the steps again in original ETL. Please advise. Thanks…
-
Can we have different goal for different category in the same card?
Hello Team, Here is the example where I am looking for some ideas. We have mutiple serieses and want to show different goal value for each series in the card. Currently I am seeing only one goal option which is common to all series. Please advise. Thanks Bandla
-
List users endpoint bug
When I am calling list users endpoint and set offset parameter value, which is more then actual users count, instead of empty list I am getting 500 Server Error. For example if I have only 10 users and I call list users endpoint like this - "https://api.domo.com/v1/users?limit=100&offset=10", I will get following error:…
-
Hi! has anyone built a Pepperjam or Twitter API connection for DOMO?
I'd love to utilize what you've built! thanks so much! amy
-
Calculating time increment/differences between Agent Statuses & variance between them
Hello Dojo's! Trying to see if the request we received can be done at the card level with a beast mode calculation rather than a MySql Dataflow, similar to something that was used in this instance (not the exact same but in the ballpark, so to speak:…
-
Anyone else having performance issues on their instance?
From being stuck in "preparing" state for a csv file that contains 1300 rows to taking 4+ minutes to index a very small Magic ETL job...my instance seems slow today. Is anyone else having problems or have a solution? I've proposed in the past giving us a performance counter on underlyting metrics of the AWS platform so…
-
Line + Nested Bar
Hello - Has anyone had any luck with using the chart type " Line + Nested Bar" ? I'd like to show all of our sales reps' opportunities in their various sales stages in a nested bar with the total value of their opps as a line using this chart type. The problem that I'm running into is, how do select the values for the…
-
Anyone have Visa IntelliLink connected?
Hi all, we are trying to figure out a way to bring in Visa IntelliLink data into Domo and wanted to know if anyone has been successful at it. We use it for all our corporate purchasing card activity and right now are using a manual process. Thanks
-
Submitted update to connector on December 12th 2017. Still has not been updated in production.
Hi, We submitted new code for a connector on December 12th. That code is still not in production. We've since contacted the support team but they said they don't have access to know what is going on. We've submitted the code two additional times but nothing. The code is still not updating in production. This case has made…
-
Maps not displaying percentages correctly
Has anyone seen issues with displaying Percentage formats in Maps? Specifically, I want the data and the legend to display as a percentage, however, I can not get the format to stick. When I edit the STATE VALUE format to display as a Percentage (and check multiple by 100), it initially displays correctly as a percentage…
-
Name a column dynamically with a beast mode or formula
Is it possible to name a column with a formula? I.e. I have a table that shows growth over years: Region | Prev Mo 2016 Vol | Prev Mo 2017 Vol Region A 80 100 Region B 90 99 Can I have it name what the previous month is automatically, i.e. it would say July 2016 Vol if I am looking at the table in August?
-
Is anyone else having issues with the fields changing in the Zendesk Ticket with Users Report?
We used the Zendesk Quickstart App and it was working fine for our needs for a while. It seems the data within the Zendesk Ticket with Users report has changed. The assignees, submitters, and requesters are no longer available in the dataset. The Quickstart app has "Top Requesters" and "Top Assignee" but these no longer…
-
How to add percentage to stacked barchart when cursing over (not the hover value)
Currently in a 100% stacked bar chart, when a user hovers over a series, the absolute number hovers above the highlighted bars. How can this be a percentage of the total rather than absolute numbers? I'm not reffering to the 'Hover Text settings' which changes the 'call out bubble e.g %_SERIES_NAME…
-
count specific values in a column
Hi, I have the following table and want to calculate Date /Time Status ------------------------------------- May 1 00:01 pending May 1 00:05 accepted May 5 11:01 accepted May 6 12:01 finished I want to calculate acceptance rate, which is the ratio of #(accepted+finished)/#total How can I use the count function to count…
-
Criteo Data Upload
Hi there! DOMO only has a connector for Criteo Premium Publisher Platform. We don´t have a publisher account, but a normal one. I don´t know how to get those information automatically into DOMO on a daily basis. Maybe someone was in the same situation and can explain me how to proceed further! Many thanks
-
Importing a MySql Dump .sql file
Can you import a .sql file (dump of MySql)
-
Using Last Year Data on a Card Filtered to the Current Year
I have a card that shows This years Sales by month v Budget - works fine. I want to show a summary number that is YoY% - formula wise, this is not a problem - except that as the date filter on the card is set for current year...meaning last years sales are not available to use in the YoY formula. Any ideas?
-
Beast mode calculations with multiple conditions
Hi! Has anyone got a formula for a calculation which uses multiple conditions/parameters? For example: If Ad = Rewards and Activity = 'App Complete' then click through conversions I'm trying to identify which ads delivering what kind of conversion. Anyone please help
-
Alert when change from previous month
I am looking for a way to set up an alert that will be triggered on a change from the previous month. Example is if a client has a 34% conversion rate for the month bu the previous month they had a 38%, and an alert is set to notify of a change of -2%. Can this be done?
-
API to access cards and get capture of the graph/chart
Hello everyone, is it possible through the available API, having access to the cards and get a capture of the graph/chart as well as some information available through the filtering system? thank you very much max
-
PDP Question
We are working on expanding our Domo users to include our outside account managers. In doing this, our leadership wants those guys to each only see their individual information. In other words, if John Doe logs in, he will only see information for the customers he is named as the account manager. My first thought was that…
-
Alphabetical Sorting Order
What is the exact logic of the alphabetical sorting on fields? I have a field called advertiser and find that it's sorting by upper case, sentance case then lower case. Is this what it's doing?? I need it to sort alphabetical regardless of case.
-
Magic ETL - Using Group by - run time impact question
Wondering what is the best practice to reduce overall run time of a ETL dataflow... I've got 5 input datasets totalling about 14M rows of data that are ultimately appended together in the final result. Is it better to use group by in the magic ETL for each dataset (5 steps) or one consolidated step after the appends? Also,…
-
Create a Letter Grade or Number Grade Based on Multiple Fields
I'm going to experiement with using the calculated field to create what I might call a Health Grade for our customers. Short Context. People can send us data. The data can process correctly or a % might fail. I summarize this % per month for each account. I would like to do something like taking the %fail data and…
-
Is there a trick to get a client with 'user' scope using the API?
I'm just trying out the API and can't create a client with data, dashboard, and user scope. If I leave out 'user', I can generate a client instance. I'm logged in as an Admin user. Is there some trick or setting that I need to know about? Thanks!
-
LinkedIn Ads Connection?
Team, how do we connect to LinkedIn Ads today? Thanks
-
Custom Connector dataset population issue
This is the first time I've tried to build a custom connector so forgive me if I've missed something obvious, although I don't think I have. I'm trying to build a connector to pull data from one of our reports in Webtrends Infinity. I've followed all of the instructions & am at the last stage. However, when I run the…