Stack Overflow
Stack Overflow

Questions tagged [domo]

Domo is a hosted business intelligence platform which creates reports using data from disparate data sources.

76 questions
0
votes
1 answer

Domo ryuu login does not work: Full authentication is required to access this resource

I am building a Domo custom app and the domo auth process is managed by the npm package ryuu. When launching my app locally, I get this error: error: {status: 401, statusReason: "Unauthorized", path: "/domoapps/apps/v2/contexts", message: "Full…
ypicard
  • 3,593
  • 3
  • 20
  • 34
0
votes
2 answers

Using SQL in Domo to apply multiple groups or filters

I am trying to filter for unique UserIDs and then see which IDs have a value of >1 in another column. I have tried pretty much every example from SQL - Selecting unique values from one column then filtering based on another and at least 1 or two…
Michael Sweeny
  • 1
  • 3
0
votes
1 answer

JavaScript, how to return a value I can only see in console?

I'm completely aware that this is probably covered in another thread however, i'm new to JavaScript and Node and not completely sure what i'm looking for. I'm working with a presentation layer called Domo and attempting accessing their API in order…
nblack8
  • 1
  • 1
0
votes
1 answer

Query to transfer from ODBC

I have a database connection using ODBC.. i want to write a query to transfer all tables and columns to export the data in DOMO.. select* from database () Can someone help in a query where i can replace only with the new data?
user8405880
  • 1
0
votes
1 answer

Okta integration possible with existing system?

We have a custom built web app backed by a REST API. We already have existing user accounts that are created via our system. We've just recently integrated Domo to do reporting and they recommend Okta. Is it possible to get have users sign in on…
Jamie Taniguchi
  • 387
  • 4
  • 13
0
votes
1 answer

415 Unsupported Media Type error - Domo Connector

So I'm building a connector using the Domo developer tool (they like to call it an IDE) and I just can't seem to get the authentication piece working with their libraries. Domo uses httprequest library for basic and oauth types of…
amigo21
  • 381
  • 1
  • 4
  • 18
0
votes
1 answer

How Can I find a Null Value within a number?

I'm using the BI tool Domo, which uses Amazon Red Shift. I have a dataset that runs nightly using Zendesk data. I'm getting this error: OnboardFlowExecution(2794) data flow execution id (724670342c4c48a9a61e7a617e6462c1) failed:…
donviti
  • 284
  • 4
  • 12
  • 27
0
votes
4 answers

Days Since Last Help Ticket was Filed

I am trying to create a report to show me the last date a customer filed a ticket. Customers can file dozens of tickets. I want to know when the last ticket was filed and show how many days it's been since they have done so. The fields I have…
donviti
  • 284
  • 4
  • 12
  • 27
0
votes
1 answer

Assertion error on ZeroMQ Majordomo worker

I got a problem with the ZeroMQ Majordomo worker API, which fails on an assertion, using this simple worker, client. The broker I am using is all from the example section from ZeroMQ site. What's the m_reply_to used for and when is it…
Johan Engblom
  • 215
  • 1
  • 12
0
votes
2 answers

SUM of COST when SKU is like CP% DOMO SQL

I'm working with DOMO which is very similar to MYSQL. I have a table with many columns but there are two important ones: Item_sku and Item_cost. Each sku has two letters at the beginning that declare type of item. There are five item types. I'd…
Bartonb12
  • 33
  • 7
-1
votes
1 answer

Self Join? Were Staff Who Worked the Previous Week Active 3 Weeks ago - MYSQL

I'm trying to add a column to a production hours dataset that will tell if a provider who worked last week was also working three weeks earlier. The current dataset looks something like this: RowID | ProviderID | ClientID | DOS | DOS (Week)…
nkamlearn
  • 3
  • 1
-1
votes
1 answer

query between two dates in MySQL grouped by range of days

I am using DOMO with SQL. I have two columns in my dataset: Date and Revenue. I only want to grab the data starting from March 1st, 2019 and group it weekly, so I only see the sum of Revenue for 1 week from March 1st, 2019 and going forward. I want…
Chique_Code
  • 1,422
  • 3
  • 23
  • 49
-1
votes
2 answers

TRIM the values from the middle of the string with MySql

I have the data in domo platform, that I need to trim using sql. My data looks like the following: id Partner 123 'HDM | R | Verizon (Tags)' 124 'JAM | R | T-Mobile (Tags)' 125 'EBDA - ALL | Aetna (Tags)' 126 'EBDA -…
Chique_Code
  • 1,422
  • 3
  • 23
  • 49
-2
votes
1 answer

How do I subtract these two columns in SQL and make an extra column that shows the difference?

Begin_Term End_Term 2018 Current -select- Current 2015 2019 -select- 2018 I used using the case when SUM('End_Term') - SUM ('Begin_Term) then 1 else 0 end but it only shows 0's and 1's for the results. I'm also using DOMO so the…
jeff
  • 1
  • 4
-2
votes
2 answers

Power BI to DOMO

My company is moving to DOMO from Power BI as its single source of truth. Does anyone have any pointers or things to look out for or best practise for moving reports already in Power BI into the new DOMO arena?
Pops
  • 11
  • 2
1 2 3 4
5
6