-
Any successful JSON connections?
Hi there, I'm attempting to use the basic JSON connector, and I run into what I believe is a column limit error. I want to use the connector to filter down to specific properties, but I'm not sure what the syntax is for this field or even JSON in general. Does anybody have any good starting points on how to learn or where…
-
"Disabled Alerts"
Please tell me about "Disabled Alerts" in the latest Release Notes. (https://knowledge.domo.com/Release_Notes/Feature_Release_Notes/Current_Release_Notes) I would like to know about the statement "When an alert gets into a broken state, it becomes disabled and shows up in red." Where is displayed in red?
-
Workbench DataSets
Is there a way to identify if a dataset in the Data Center is from Workbench or not? Currently we have to add WB in the title of the datasets we are running form workbench but it would be much easier if there was an icon or some way to know that this data comes from workbench and not uploadd or through a connector.
-
How to use query parameters with BigQuery?
I've been trying to create BigQuery datasets that use the "Query Parameters" field to limit my queries based on lastrundate or lastvalue of one of columns in the query. The hover text for the "Query Parameters" field states: Enter the query parameter value, it is the initial value for query parameter. The last run date is…
-
Beast Mode With Two Dependent Criteria
Hey, New to Domo but I love it so far. I am trying to create a data table that will let me find people that have fulfilled two criteria. Current Output: Dynamic Classification Variable || Distinct count of guests that had pizza || Distinct count of guests that have had a hot dog. Virginia || 1 || 1 North Carolina || 1 || 2…
-
Are Data Labels for Custom Charts working for anyone? My Hover Text is working...
Data Labels under Properties is pretty straight forward. For some reason they do not show up in the Custom Charts we have created. Is this not working for everyone?
-
MySQL Connectorでデータ量が多い場合に分割して取込している方いますか?
MySQL Connectorでデータ量(件数や1レコードあたりのサイズ)が多い場合に分割等何か工夫して取込している方いますでしょうか?どの様に行っているか参考にさせていただきたいです。 現在 select * from table_name where 条件; という形でデータを取り込んでいるのですが、対象件数が数百万件あります。 ある時急に取込が10数分だったものが数時間レベルで遅くなり確認したところ 1撃で取れる件数(データ量)が多すぎてDB側がボトルネックになってしまっていました。 1撃で取れる件数を少なくすると解決できたため select * from table_name where 条件 and 分割条件; ->…
-
how can I create a graph showing time? I need to show my numbers in minutes (or seconds)
Hello I am trying to build a card that shows the total promo time I have available in an hour of programming. So, for example, at 6pm, I have 2:30mins available of promo time. When I graph this the minutes come out as a decimal. How can I graph and show data in minutes?
-
Course Builder
How do you update an app from course builder? In the asset library it says what version an app is but when I republish an app it just creates a new asset. I want to be able to re-publish an app which will then update the original version without me having to create a new card and add it to the page it belongs on. This is a…
-
Failed to authenticate. Verify the credentials and try again. Error setting up SQL connection. FATAL
Hi, We have a Postgres database running on an EC2 server on AWS. We have whitelisted the IPs and set up an account to use SSL: our pg_hba.conf includes: hostssl all readonly_user 0.0.0.0/0 md5 clientcert=1 We are using a self-signed certificate, mostly followed the directions here:…
-
Breaking card certification
I'm not sure if this belongs here or not. We have a card that has been certified. We wanted to test what might break that certification. We made a change to the query in workbench, which would update the dataset and ultimately the card. However, the card is still showing certified, even though there was a fundamental…
-
How to calculate non zero average
Lets say I have department name and employee Count by Month . But not all department will have Employee count every month. some months might be zero count for a department. While calculating Average employee per department in Beast mode, how do I calculate the non zero Average - Means i want to drop the months where the…
-
Dropbox Connector and Business Account
Hello everyone! I'm having troubles with connecting an Excel dataset using Dropbox and Dropbox Advanced connector. Our company has recently upgraded our drobox account to Business account. Every user within the Business account has a personal folder and team folders accessible to everyone. As far as I understand, every…
-
Get values with dates 3 months after the date in a field
I am trying to create a filter that shows a date in the month 3 months after a specified date. For example, if I look at the card today I would like to see the values with 'end date' in January, 2019. If I look next Friday on November 2nd, the filter would show values with 'end date' in February, etc.. I tried making an…
-
How to connect Elastic search index using workbench or direct?
We have our data residing in elastic search indexes some residing in On-Perm and some on AWS cloud , how to connect upload the data using workbench or direct connector?
-
add Multiple Targets in one chart
How can you add multiple targets in one chart?
-
How do I build a custom template without the Powerpoint plug-in crashing?
I'm able to connect Powerpoint to Domo, however I'm having issues once I select the cards I want to import from the Wizard and click 'Create Slides' - I receive an error message and partial card data with low resolution. Please let me know if anyone has found this issue and how they've been able to resolve. Thank you!
-
Meaningful error information for Red shift errors
Where can we find the actual error which is causing the query to fail. The brief information provided in the transformation is not enough. Most of the times it simply says syntax error.
-
Project Value showing instead of Actual Value
I have a graph which is showing a last value projection based on linear regression. The final two bars are attached...for the data label setting of %_VALUE the graph used to show the actual value, with the projection as the full clearly not solid bar. Since the last Domo release this graph has been showing the projection…
-
Multiple Saved Filters on One Card
Our Creative director wants to see sales by many different metrics, in one card. I've created the card, but now she wants to be able to save filtered views -- without creating more reports (so she has one card with many saved pre-filters). Is there a way to do this? Or will she need to just add her filters each time she…
-
Business Days Beastmode
Has there been any progress on implementing a business days count utilizing a beastmode and or the reference of custom holiday tables? While I know this is doable using SQL, we have a lot of non-technical users that would benefit greatly from this kind of function.
-
Showing Designed Live Dashboard
We've set up a dashboard page with three different sub dashboards using the new design dashboard function but couldn't find a presentation mode where we can switch between the three dashboards and present them together. We've just a way to present all cards on the page independently. Is there a way that we have the whole…
-
Workbench - Watch File
I have a few files in Workbench set up 'Watch File' Does the Watch File function only work if Workbench is open on my PC? i.e. if I am on leave and one of my colleagues saves the file. Will Workbench still upload the file? Or does my workbench have to be open to do this?
-
PDP for Data Fusions
Is there an update on this functionality? I've seen multiple posts on this topic and would like to know if there is any progress on being able to apply PDP policies to DataFusions.
-
Loading a log file in JSON format
The workbench allows us to load JSON formatted log file. I dont see any examples indiating what the "data source" examples could be. It indicates a key what would the key be? Below is an example of what im looking to load and take in values for calculation , the values are all mocked up but this is what we would think to…
-
replies count twitter
Hello , Can i find count replies on Twitter dataset? i only found retweet and favorite count Can anyone help me?
-
Why is the beast mode that calculates a percentage wrong in total row but correct in regular rows
As seen in the attached file, the first column is numerator, second column is denominator, the third column is a beast mode: numerator/denominator. There's no aggregation on any data. The calculation is correct for each record but when it comes to total row it's wrong. If i change the beast mode to…
-
Add Collections on Favorites?
We have users who would like to reorganize their favorites into collections so that they can easily categorize with their own labels and grouping - is there the capability for non-admins to add collections on their Favorites page?
-
Using course builder on phones and tablets
Will the course builder courses be optimized for phones and tablets? I have some users who only use their phones to access Domo, so they miss out on being able to use this information.
-
Recommended application for online forms & data collection
I would love a recommendation! I'm looking for an "off-the-shelf" application, preferrably web-based, for creating data input forms. Here's the kicker - I have around 800 users, and each needs to be presented with custom fields because they each track different metrics. For example, perhaps my team tracks metrics A, B, and…