Questions tagged [domo]

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

76 questions
4
votes
2 answers

What is the CA certificate path for a SQL Azure database?

I have a .NET web application which connects to a database hosted in the cloud on Microsoft's SQL Azure platform. Now I'd like to use Domo, a third-party cloud-based business intelligence service, to do some reporting on the data in the Azure…
Brian Rogers
  • 125,747
  • 31
  • 299
  • 300
3
votes
1 answer

Error in curl: Curl Fetch Memory - RStudio Curl Memory - Failed Writing Body

For Context, I have been using RStudio to pull data from our reporting platform (Domo) then I manipulate the tables in R, and send the df back into Domo at the end. The start of the code worked perfectly fine for a few months but is now returning a…
3
votes
3 answers

3 Month Moving Average - Redshift SQL

I am trying to create a 3 Month Moving Average based on some data that I have while using RedShift SQL or Domo BeastMode (if anyone is familiar with that). The data is on a day to day basis, but needs to be displayed by month. So the quotes/revenue…
user2427023
  • 107
  • 2
  • 4
  • 9
2
votes
1 answer

MySQL: difference between select * from table and select * from (select* from table)

What is a differenct in this SQL: first one: select * from table_1 a join table_2 b on a.id = b.acc_id second: select * from (select * from table_1) a join (select * from table_2) b on a.id = b.acc_id Because the first one is…
WBAR
  • 4,924
  • 7
  • 47
  • 81
2
votes
2 answers

Clarifications on the Domo dashboard

The tool I'm using to develop a dashboard is Domo Centerview builder. The graphs are not getting loaded when I open the dashboard but it appears only after selecting the controls.
Raghu
  • 817
  • 1
  • 7
  • 21
1
vote
0 answers

BigQuery returned Premature EOF

I have a table in bigquery with around 32 million rows and 85 columns with size of 22 GB. (It is a physical table not a view or temporary table) I am using this table as a datasource in Domo. This is the domo connector I am using:…
dataEngg
  • 11
  • 1
1
vote
0 answers

How to retrieve an url to a book cover only knowing its isbn

is there a way to obtain an URL to a cover of a book when only knowing the book's API? I have tried two approaches yet. First, https://openlibrary.org/dev/docs/api/covers which does not work for me since they did not find any covers for the…
Lasking
  • 11
  • 1
  • 4
1
vote
1 answer

Domo.js is trying to JSON.parse a png

While developing a custom app for my organization, I am trying to request the name and the avatar of the individual accessing the card. I am able to get the name of the individual without any problems, but when requesting the avatar image I get the…
Skouzini
  • 143
  • 1
  • 10
1
vote
0 answers

Domo - Split multi value comma-delimited column based on values

I have a data source in Domo with a multi value column that is comma delimited. I am able to split the column using the comma as delimiter, into new columns. Example- fruit, vegetables Gives new column 1 Fruit and new column 2…
Elby
  • 11
  • 3
1
vote
2 answers

Domo: how to identify recently deleted cards

I recently deleted a lot of cards. Is there a way in Domo to identify recently deleted cards/reports? Thank you very much.
Maria
  • 69
  • 1
  • 10
1
vote
1 answer

Domo dataset: OverflowError: Python int too large to convert to C long

I have 64-bit Windows 10 OS and I recently updated my python using pip. I use pydomo to connect to DOMO dataset I created and while importing, it's giving the below error only sometimes. Here is part of the code and error. import pandas as pd from…
rra
  • 809
  • 1
  • 8
  • 20
1
vote
0 answers

Trying to pull out the date from the File Name to turn it in to a metricdate using Regex/SQL

I have a file the name is: security_public_storage_account_performance_10_1_2021_to_10_31_2021.xls I am trying to use regex to pull out both those dates in the file name. I am using Start Date: REGEXP_REPLACE(_FILE_NAME_,…
1
vote
0 answers

Domo - Detailed Dataview Duplicates

We are running DOMO on top of Snowflake DB. My problem relates to a detailed view of a card, something like this: DOMO data view https://imagizer.imageshack.com/img923/1998/8P7Azo.jpg To get this results displayed, DOMO runs a DB query which looks…
1
vote
1 answer

MySQL - Compare rows within group

Using MySQL, I need to compare rows within the same group and return rows that don't match according to a particular field. For example, say I have the following table: cust note 1 foo0 2 foo1 2 foo2 3 foo3 3 foo3 3 foo4 I need…
dbzone77
  • 13
  • 2
1
vote
1 answer

Delete data based on date from DOMO

I need to delete data from a dataset. I read this post that I think would help (https://dojo.domo.com/discussion/comment/46624#Comment_46624) but Im not sure where to run this query to delete from the table. Please let me know if these are the…
KristiLuna
  • 1,601
  • 2
  • 18
  • 52
1
2 3 4 5 6