Domo is a hosted business intelligence platform which creates reports using data from disparate data sources.
Questions tagged [domo]
76 questions
1
vote
1 answer
NVM (for Windows) doesn't see local executable scripts
A lot of people have this problem but it always starts out with "I installed NVM for windows and now NPM won't work". That is not my issue. NPM works fine. My problem is with installing packages, but I should prefix this by saying that I'm new to…
Rich
- 181
- 1
- 5
1
vote
1 answer
join two dataset on two columns sql domo
I am using MySQL with DOMO. I have two tables that I want to join on both columns. My data looks like the following:
The first table represents 2019 Revenue
Week Name 2019 Revenue
1 Paul 576356
1 …
Chique_Code
- 1,422
- 3
- 23
- 49
1
vote
1 answer
calculate the percentage with sql and DOMO
I have a table where I want to calculate the percentage of revenue using the following formula: (Advertiser Revenue / Total Revenue) * 100.
Data =>
Partner Date Ad Unit Revenue Total Revenue
App 1/1/2020 x 10 …
Sonya
- 137
- 2
- 8
1
vote
2 answers
Execute a .jar file using shell script
I want to execute a jar file of DOMO CLI from a shell script. The jar file itself has some functions which I want to call after I call the main jar file. The problem which I am facing is that after it executes the jar file, I am not able to pass the…
Yogesh
- 47
- 1
- 10
1
vote
1 answer
DOMO - MYSQL Transformation Database table error
I'm Trying to replicate queries on DOMO from microsoft acccess. I assumed I had got the correct syntax but now I'm getting a The database reported a syntax error. Not unique table/alias: 'ga_wip_due_within_one_week'
SELECT `egl_inv`.Category,…
David Han
- 47
- 3
- 8
1
vote
0 answers
How to download from a data source extension into excel using VBA
I have an online data source that I've linked to excel using the domo excel extension. This enables me to download data tables straight from domo into a an excel doc. My goal is to use a macro to automate the following steps:
At a 12am ET on Sunday…
1
vote
2 answers
Populating a table with JSON Data
I'm doing something very wrong and I can't for the life of me figure it out. I'm a novice so that doesn't help.
var res = httprequest.post('https://us3.api.samsara.com/v1/fleet/drivers?access_token=xxxxxxxx','{\"groupId\":…
donviti
- 284
- 4
- 12
- 27
1
vote
1 answer
Mysql Group by 3 fields with count
See the attached image to see the data I have.
I am trying to get a result like this:
SessionNumber | Event Date| Critical Care Count | Pulmonary Circulation
G1 | 5/19/2018 | 2 | 3
G1 | 5/20/2018 | 5 …
user1098063
1
vote
2 answers
Domo - Equivalent to Tableau Parameter
zI'm a Tableau user and want to identify if something similar to Tableau parameters are in Domo. Here is what I am doing in Tableau:
dataset is all ZIP codes and multiple numeric columns
I built a Tableau boolean parameter for each of the numeric…
Ralph
- 255
- 2
- 18
1
vote
1 answer
Retrieving data from infusionsoft to DOMO using plain javascript
I am trying to create custom connector in DOMO to retrieve data from infusionsoft. I can use only plain javascript in DOMO IDE. The below code is what I wrote to make request to XML-RPC Api of infusionsoft but I am getting fault code response.…
Vishnu Yadav
- 11
- 3
0
votes
3 answers
compare today's data with same day last week
I am looking for a date function to compare data today vs lastweek sameday . e.g Wednesday this week vs Wednesday last week. I am particularly looking to write in Domo (BI TOOL) but any language(sql ) would be appreciated.
Thanks
I can not find a…
Gunjan
- 1
0
votes
0 answers
I am trying to create a tier structure for records that are in booked status
I want to create a aggregate nested case statement within my select statement. I want to count all the records that are in the status of "booked" and then from then create a tier structure for. so i can put it into a visual graph, expect
SELECT …
0
votes
0 answers
Having issues with Percentage calculation in DOMO card (BEAST mode)
Hi Experts,
I have a dataset with columns (count , type and date col) , and calculating the percentage of the count in domo analyzer , as sum(count)/total count. But the problem is the date aggregation .
Requirement :
When i use the date range…
S V
- 3
- 3
0
votes
1 answer
How do we create Domo Back Button?
I have creating a domo assets for back button in domo but the problem is the back button won't work
the back button cannot by pass the iframe which the back button is inside the card frame.
Any code that I can use for this? Your help much will…
0
votes
1 answer
Unload millions of rows of data from DOMO into Snowflake
Is there a way to unload hundreds of millions of rows from DOMO into Snowflake.
I know Snowflake has a Connector but that's from Snowflake to DOMO, I need to do the opposite. I tried exporting in DOMO to a CSV but I was unsuccessful.
KristiLuna
- 1,601
- 2
- 18
- 52