-
Customized alert
HI, I would like a customized alert for my card when the quanity is Negative. The problem here is currently, alert is just showing a summary number. My summary number wouldnt be a negative number but the sub parts would be negative. I saw a video link to create a customize alert but not sure why I cannot view this. The…
-
Command Line Workbench from the SQL Server Job Agent Scheduler
I am having a heck of a time getting a batch file of Workbench files to run in SQL Server Job Agent Scheduler. My batch file includes these 2 commands: cmd /C "C:\Program Files\Domo\Workbench\wb.exe" run-job --server mngdirect.domo.com --jobid 48 cmd /C "C:\Program Files\Domo\Workbench\wb.exe" run-job --server…
-
Custom Connector Datagrid Populating
Hello, I'm having some decent success creating our custom connector. I'm pulling user information from a sites api and have been able to map it right in Domo. However, we use additional fields in a separate call that I'm trying to populate per user. I'm running into an issue where the if / if else statement only selects…
-
Provided ssh key is invalid
I can able to connect my MySQL database using Sequel Pro using my SSH Key, When running in Domo its showing Provided ssh key is invalid error messgage. I have copied my SSH key using below command on terminal window pbcopy < ~/.ssh/id_rsa How to solve this issue?
-
Excel Plugin Download of Datasets is Hit or Miss
Is anyone else having issues downloading datasets into Excel workbooks reliably? I've tried several of my datasets, and some will download, while others just "try" to download for ages without success. In my limited testing, I've determined that datasets with around 540 rows or less tend to download fine, but anything…
-
Has anyone built a card or two to monitor Workbench Job stats?
Hey team - Has anyone built a card or two to monitor Workbench Job stats? Wondering where that data lives (start/end time, last/next run, message) to setup some reporting. Thanks for your time! amy
-
Changing X-axis in Period over Period charts
I started playing around with Period over Period charts and I'm having an issue regarding the labeling of the x-axis. Now typically you don't have multiple years of data grouped together but in this case it is now a possibility. But it leaves the x-axis with a date period that makes little sense to me. If I'm grouping…
-
Developer Portal - Now includes documentation for all Design Studio Widgets
We have recently updated the Developer Portal to include documentation for every widget available in the Design Studio. Visit this link to view that page. Documentation currently lists each widget by category, lists out all configuration options available, and summarizes the data usage required for the widget. In addition,…
-
How can i increase the width of lolipop chart?
there is no option to increase the size of width of lolipop chart so how can i increase it?
-
calculate or label the percentage for each series of grouped bar?
I have two series of bars, one is profits for each department ( TV, Computers, Furniture, etc.) and another series is for inventory value for each department ( TV, Computers, Furniture, etc.). I want to have a bar chart that can show the percentage for each department and series. Anyone can help me with this?
-
How to get total sum of data in a column format dd:hh:mm
Need to get total of a column with data are formatted as dd:hh:mm
-
Connecting to Postgres database on Amazon AWS RDS
Hello, We have a postgres database on an Amazon RDS server that we'd like to connect to. The routing table for the RDS must be updated to allow the IP address of any client trying to connect to it. But I don't see an obvious way to make this work with domo (since I don't know what IP address it will be connecting from).…
-
If I do not have enough authorization to a data source, can someone connect data in Domo for me?
If I do not have enough authorization to a data source, can someone connect data in Domo for me? Thank you. Olivia
-
Making 2 lines as symbols and rest as lines in a line chart.
I want to make my total and plan as symbols, while the rest of the products are shown by lines in a line chart. As of now, all the lines turn into symbols or lines. Is this possible?
-
No data when drilling down into a different dataset
I created a card with 2 drill path cards. The top two levels are from the same dataset, while the bottom level is from a different dataset. While they are compatible, the 2nd drill path doesn't show any data. But if I simply pass the same conditions to filter using that dataset, there are expected data returned. How can I…
-
Filtering Google Analytics API to "start of month" through "today"
All, We create monthly KPIs based on GA data that I am trying to recreate in Domo. I would like to filter the connector to run based on a relative date range including the start of the month to today. E.g. running the report today would pull in data from 9/1 to 9/18. Running on Oct. 1 would pull data from 10/1 to 10/1. Is…
-
wrong data format
Hi I am linking DOMO to my smartsheet tables. I have columns that are percentage (Number) but when pulling them into Domo they are appearing as Text columns. Can a change the data when setting up the data source? Thanks Jon
-
New Dynamically Based Range Scale Markers - outlier fill?
I'm reviewing the Sept Release Notes, and can't figure out how to do outlier fill with the new dynamically based range scale markers. In the Adding Scale Markers to Your Chart knowledge base document, the card example given in the intro shows fill color for the "normal" range of data as green, and the red for fill area of…
-
app sdk data api > window functions
Does the Data API that's part of the App SDK have the equivalent of window functions?
-
How can I format my data label numbers portrayed to have () for negative numbers instead of -
...as subject... Want my number labels in by card elements (bar, line, etc) to be able to represent a negative number as such (1,000) or ($1,000) or (10.5%) instead of -1,000 <> also works. Thanks!!
-
How can hide legend of MAP
Hi, I want to hide the legend of my map chart but not able to see any option of it
-
Yahooリスティングデータの取り込みについて
表題の件、ご相談になります。 YahooはAPIが一般公開されていないので、Googleアドワーズのようにスクリプト言語を用いてスプレッドシートに自動取り込みといったフローが組めないです。 サードパーティーの有料ツール経由で、DOMOのコネクターを用いて取り込むことは可能なようですが、身の回りにあるもので実現可能な方法はありますでしょうか? ご存知の方がいらっしゃいましたら、教えていただけますと幸いです。
-
Table-level data security
I am trying to find a way to wall off data sets from Editor and Priveleged users who can create cards. For instance, I don't want all non-participant users accessing our HR data if they have access to a single card that points to the data set and then have them build a card off that dataset. (I realize that PDP might work…
-
Getting a 500 error when querying /v1/datasets/id/data
Hello, When I attempt to query a specific dataset using /v1/datasets/id/data I get a 500 response with an Internal Server Error. I've been able to get the dataset list for a valid id, but once I try to hit the endpoint above, it errors out. Can I get some support? Thanks!
-
Pipedrive Integration Not Reporting on Custom Fields
I have a Pipedrive Integration set up but I am having an issue when I try to report on Custom Fields created in Pipedrive. The field name is coming up as numbers and does not show the proper name. Ex: Specialty. This is a custom field created in Pipedrive in which users can select "PCP", "Cardiology" etc. When I try to…
-
Defect? New Source Columns missing in DataFusion Result until after rebuild
Hi Folks, you might need to replicate and confirm the following before marking it as a defect. Take two source ds, sA & sB. sA has 3 columns, a,b,c. sB has 3 columns, x,y,z. In a DataFusion sA is joined to sB to create R, the result ds. After the R is created, it contains a,b,c,x,y,z. Next i want to extend sA, i've added a…
-
Hide or exclude value in table card
Is there a way to hide/exclude values in a table card's subtotal? I want to do this because a few of my metrics do not make sense summed up
-
data types BigQuery --> Domo
Hi all, I used the Google BigQuery connector to import in Domo a dataset directly from BQ. It worked, but I could not choose the data type for each column and the resulting Domo dataset has a numeric column when BQ had a string type. I know I could convert the data types after the import, but I think it would be better to…
-
Alerts Triggered but no email
Hi Domo Support, I've noticed a card's alert is being triggered and recorded in Domo, but the email notification is not sent. Its a table card displaying Freight Details where the notification will trigger when the least cost carrier is not selected. 1. Table Card with Alert - Shows its triggered 2. Has multiple Users…
-
Workbench Error : ODBC cannot open the Access Database
Hello, Attempting to upload the MS access database on the workbench will result in the following error message. ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] (The file name&path) The database cannot be opened in exclusive mode because it contains links in cached mode. Previously, the predecessor could upload it,…