Domo is a hosted business intelligence platform which creates reports using data from disparate data sources.
Questions tagged [domo]
76 questions
0
votes
1 answer
MySQL Domo AWS RDS Connector
I'm having issues connecting Domo to a MySQL database hosted with AWS RDS. Whenever I try to authenticate I get this error:
"Failed to authenticate. Verify the credentials and try again. Domo is ready, but the credentials you entered are invalid.…
user12392643
0
votes
2 answers
403 Access Denied Error while creating a dataset in DOMO
I'm getting an 404 access denied error while trying to create a dataset in DOMO, anyone who is good in DOMO please help me,
import logging
from pydomo import Domo
from pydomo.datasets import DataSetRequest, Schema, Column, ColumnType, Policy
from…
Eager2Learn
- 31
- 3
0
votes
2 answers
Percentage of total purchase for qualifying customers per date period
I need to find the percentage of chocolate sold of customers which have purchased chocolate by month.
Take for example the below example table with only a single Month entry:
Cust_Id Customer Quantity Item Amount in $ Date …
mmenschig
- 1,088
- 14
- 22
0
votes
2 answers
The database reported a syntax error: Duplicate column name 'Product_Number'
It says that The database reported a syntax error:
Duplicate column name 'Product_Number'.
Below is the code:
SELECT *
FROM `df_all_orders_merged_la`
LEFT JOIN `product_database_la`
ON `df_all_orders_merged_la`.`Product_Number` =…
0
votes
0 answers
Why can't I connect my Sql Server to DOMO?
I've been using PowerBI to create visualisations for my Sql Server data, but it's quite unyielding and clunky in my novice experience.
Deciding to try different solutions, I've given DOMO a try but I'm unable to connect to the database:
I've…
Ant
- 73
- 9
0
votes
1 answer
how to add sum of all the values in sql as a separate column
My table currently looks like this:
Partner Date Ad Unit Revenue
App 1/1/2020 x 10
App 1/1/202 y 3
I need the additional column with sum of all revenue for the day so it…
Chique_Code
- 1,422
- 3
- 23
- 49
0
votes
1 answer
Percentage calculus based on multiple tables in sql
I have two tables in sql and I need to create another table performing the calculations based on two other tables.
The first one has the sum of revenue for each Ad Unit, table name is ad_unit_table
SELECT
d.`Date`,
'App' as `Partner`,
…
Chique_Code
- 1,422
- 3
- 23
- 49
0
votes
1 answer
DOMO - MySQL unpivoting tables and creating unique sequential number for each row
I want to be able to unpivot tables that I currently have. I always forget that DOMO doesn't allow certain functionatlieis. with the code provided below, how can i translate this to DOMO mysql?
Code Starts here:
select o.*, isnull(c.Qty,0) as…
David Han
- 47
- 3
- 8
0
votes
1 answer
How do I omit certain data in a row without removing it all?
Domo zero example
I imported data from SQL into Domo. I am building a card and want to remove select 0 values without removing the entire row. Is this possible? The data type has to remain as integer because of the financial formatting.
Chris
- 7
- 1
- 6
0
votes
1 answer
If Contains Statement for a new variable SQL
Need help correcting my code for an if statement to create a new variable.
This is for help cleaning a data set for a project for my business. I want to search a column for multiple values and if that column contains any of those values it will add…
Wade
- 1
- 2
0
votes
2 answers
How is joining with a subquery different from joining without a subquery? Looking for difference between two similar queries
I want to see which user created floor equipment for which customer -- both of these queries do what I want. The second query, however, results with 700 more rows than the first. Could you please explain the difference?
I ran another query that…
Dillon
- 11
- 2
0
votes
0 answers
How can I connect Domo data tables to R Studio?
I am trying to connect directly to a Domo data set within my datawarehouse in Domo. Is there a way I could make a direct connection to the Domo dataset in R? I simply want to have a connection directly to the dataset so as to avoid having to…
Michael Lopez
- 79
- 2
- 11
0
votes
1 answer
How to change BigQuery scopes?
I am trying to write a query that pulls from federated tables in BQ. In BQ I can run the query and get results. However, when I run the same query in Domo, I get the error: Domo is ready, but received a Access Denied: BigQuery BigQuery: No OAuth…
aavolo
- 29
- 1
- 1
- 2
0
votes
2 answers
Vlookup Value From A Range of Values
I am trying to vlookup a value (rdate from table 1) within a range of rows (table 2), and return a "yes" if the value can be found within table 2 (with a specific set of criteria)
Table 1 - Sales by Date
rdate strcompanynodename …
James
- 9
- 3
0
votes
1 answer
Can I use JSON_EXTRACT in a Domo SQL DataFlow
Domo calls one of the DataFlow types a "MySQL DataFlow". MySQL has a function called JSON_EXTRACT. How can I use this on a field that contains some JSON encoded data? I receive back the error:
The database reported a syntax error. FUNCTION…
Philihp Busby
- 4,389
- 4
- 23
- 19