-
Create a crosstab or table chart like below with variance
Hi Dojo Team, I'm new in domo and started to explore it. I need your help while creating a crosstab chart or Table chart like below image. I have three column which inlcude Date, Additions, Depreciation. From all these three column, I want to calcualate variance between two months like below table.…
-
Inner Joins
Hello, are inner joins supported in SQL for AppDB? var queryJoinTest = "SELECT REC.nombrer, RED.nombreo FROM Reconocimientos REC " queryJoinTest += "INNER JOIN Redeem RED ON REC.empr=RED.empo AND REC.empr ='" + EmpN + "';" I've tried it in the same code line and sepparate, and it works both ways with a normal query. But it…
-
Providing API access to a 3rd party vendor
I created a few data sets for my vendor to import data into. When he tries to import data, he gets the following error: Full authentication is required to access this resource Do I need to make an account for my vendor, in addition to the client id and secret? Does my vendor need to create the data sets in his own? When I…
-
AppDB Null Date
Hello people, when creating a dataset via AppDB, is there a proper way to specify that a field can be null, in this case, a date field? I need it null so then I can select null dates and do other stuff with those records based on an ID filter. Hope I explained myself, thanks in advance!
-
Create User Domo API with R in Rstudio HTTR 400 status
------Where I got the instructions------ https://developer.domo.com/docs/users-api-reference/users-2#Create%20a%20user POST https://api.domo.com/v1/users?sendInvite=true Content-Type: application/json Accept: application/json Authorization: bearer <your-valid-oauth-access-token> { "title": "Software Engineer", "email":…
-
Conditional logic in DoMo DataFlow
Hi, Is there any function or logic available in DoMo which can be used in Dataflow to determin -if the file size is less than an expected count then stop the dataflow -and only proceed if it’s greater?
-
Error using domo publish
Hi, Months ago i've created and published a simple app. The problem is that nowadays i'm trying to publish a modification and every time i try to do "domo publis" i'm getting this error: [ERROR] The domo cli tool has experienced an error. As it is [ERROR] possible this bug has already been fixed, please try updating…
-
waiting to send a report until critical dataset updates - hope this helps somebody out.
We needed to wait until a certain, slow running dataset had finished before sending out reports. With lots of help from Domo, here is what we came up with. I am trying to scrape the interal info, hopefully I do not scrape too much. This is a powershell script we call from a bat file scheduled in Windows scheduler. you need…
-
Alerts for dataflows when fails to upload
Hello, I would like to set up the Alerts for all of my dataflows for when it fails to upload. I am a Mac user and only found the solution through Workbench, which is not available for me. How would I set up the alerts in this case? Thanks for the help, Sonya
-
How to get data for the last 5 months from an year's data in magic ETL?
Need to get the data for 5 months from current 1st of month using magic ETL. It needs to adjust back to 5 months automatically from the current month. Help will be much appreciated. Thanks.
-
Uploading CSV file using pydomo Streams API gives error
While trying to upload a CSV file using the Streams API in PyDomo, I get the following error: Exception: Error uploading Data Part on Execution 1 on Stream 1233: {"status":400,"statusReason":"Bad Request","message":"Invalid CSV provided during upload. msg=There are too few columns. Expected 87. Row 1, column 2. Row:…
-
DataSet via Email Connector with the link that goes to zip file
Hi, I am trying to set up an email connector. Every morning I receive a link from the email address and it should go directly to DOMO dataflow. It used to be a simple csv attachment and it used to work but now that it is a URL link that downloads the zip file, DOMO doesn't recognize it. I chose "Download directly from link…
-
Domo.Navigate
Hi, this is related to this other post https://dojo.domo.com/t5/Domo-Developer/Domo-Javascript-Navigation/m-p/43888#M1305 This is the structure of my app: My index.html is my main page, it has a button that when clicked I want it to navigate to second.html Code for my button is: <input type="button" value="Search"…
-
Configure tab is missing in preview dataflow
Hi, I am trying to run SQL query on the dataset that has 17M rows. In dataflow that I created, I selected an input data but it only shows 500k rows. After some google foo, I figured that I have to run "Entire DataSet" in the Configure tab in the "Preview of X dataset". However, the Configure tab is missing. How do I filter…
-
filtering the date using sql
Hi, I have a large dataset that I am trying to filter by date in such way that I only have October month, should be straightforward but somehow it doesn't recognize the date at all. Here is my sql code: SELECT `earnings`, `date` FROM `amazon_a9` WHERE `date` BETWEEN "Oct 1, 2019" AND "Oct 31, 2019" GROUP BY `date` I have…
-
Group by date using magic ETL
Hi, I am using Magic ETL to group my data by date. There are only 2 columns in my table: date and revenue. I want to group the revenue sum by date. Is it possible to do so in DOMO? Thank you!
-
writing back to the database
ID Name Comment 1 Comment 2 Comment 3 123 Joe Smith Call borrower back Closes on Friday 456 Susy Johnson Borrower Cancelled 789 Bill Williams I want the user to be able to view these fields on a table card… and edit the Comment fields right there in the card, and then have those edits saved to the dataset so that when they…
-
How to log in as a test individual on RYUU in the Command line
I'll do my best to explain an issue that I'm encountering at my company. We have a custom made app that uses RYUU, the DOMO API and built with Vue.js. The app has been working fine for almost a year now but recently we've made some changes to the PDP rules. These changes affected one of the clients who uses our custom app…
-
How to logout of RYUU on the CLI
My company has a custom made app that uses Vue.JS. When I use the command line interface, on my mac, which I've been doing for almost a year now, I run Domo login, select my companies instance and it says Login ***** successful. (The **** being the instance of my company name.) Then it says welcome, my name. Is there a way…
-
Domo phoenix bar chart how to change labels and legends font size for mobile version
-
How do you extract or select a date from a column header?
For an ETL dataset that I want to update weekly, the date and time period (e.g., "Period : Latest 4 Wks - W/E 09/07/19...") is in the first cell of the Excel file. When I create the initial dataset (via Box), this field comes in as a column header. Since it is not a unique column name each week (because of the changing…
-
API Error for Retrieve User and List Users
I am receiving an error when attempting to make any User calls from the API. Specifically, the "Retrieve a user" and "List Users" give me the error message:{"error":"insufficient_scope","error_description":"Insufficient scope for this resource","scope":"user"} Here are the two end points I have tried:…
-
Domo Phoenix Aggregations
Hello, I'm new to Phoenix and reading the documentation I'm not able to find how can I aggreate a value. Let's say for example, I have an input form that generates an API Dataset which I can create charts with. An example of a simple bar chart looks like this: In this example, I'm using postBody to make a COUNT…
-
Can I use icons/pictures (apart from widgets) in Adobe illustrator as filters in my cards?
I am using Domo's extension in Adobe Illustrator. I want to add pictures/shapes (seperate from widgets), and then use them as interactive filters in the card. When I export the card to Domo, I cannot use the inserted pictures/icons as filters. I'm labelling the layers in the workspace to reflect my filters (e.g I renamed…
-
DP19 Advanced App Building
Hello, I'm starting to explore DP19's advanced app courses and trainings. In my testing app, I've made some changes to the original code shown by Jason Hodges, and I have some questions 1. For the attachment, how can I make it to open in a new window instead of downloading every time? I have this: As you can see, I already…
-
How to use "Single Value" widgets to show aggregations instead of just top row
I've put a "single value" widget in my Domo card (through Design App Studio). When I import it into Domo, and conect it to a dataset, it does not sum the column value, however only shows the value of top row. e.g If I set "Number of Users" column as the value, the widget only shows the value of top row (which happend to be…
-
Datatype
Hi, I found two different information about the data type we can use for the schema: 1) One is coming from https://developer.domo.com/docs/dataset-api-reference/dataset#Create%20a%20DataSet and says we have these types: STRING, DECIMAL, LONG, DOUBLE, DATE, and DATETIME 2) The other one is coming…
-
Background Image Custom App
Hello Dojo Community I created a custom app with HTML/CSS and uploaded to my Asset Library, but I have a problem The index.html is supposed to load a background image (path defined in the css file). It loads perfectly fine in the dev instance but it doesn't work when published to Domo Any ideas why? Thanks in advance.
-
API to Call Webservice
I am new to Domo. Is Domo has an API to call any Webservice? If yes, please provide me the details to create a report using API calling WebService.
-
Client Data Export - Domo API?
We currently import a Dataset of Daily Sales Transactions that combine data for 2 clients of ours. We are using Magic ETL to strip out and create a new dataset for each client. We are looking into options (Must be automated and not manual) for of allowing the client to access their dataset for their internal reporting. In…