-
User Defined Functions in Redshift Data Flows
There was a relatively complicated calculation that I consider using user defined function is the best/easiest approach. Does any one know how to use UDF in Redshift data flow? It seems this feature is not allowed in DOMO’s redshift. Thanks, Ziqi
-
JSON with custom parsing pagination
I have a question regarding the JSON with custom parsing connector. I have a dataset using the pagination settings to find the next page based (I think) on the ID of the last row returned. If I set this dataset up for a regular refresh, will it look at the last ID in the dataset, or would it just restart from the…
-
How to get rid of scroll bar?
Is there a way to fit all of the data from a table on a card without having to use a scroll bar? Thanks!
-
how to create a graph with 2 x-axis
Hi Domo peeps - I just want to ask, is there a way where we can show in a grouped graph 2 x-axis? I would like to show 2 names in the X axis, namely the Owner and PE names and in the Y axis the Sat Score and PE Sat score respectivley. I can show the Sat score and PE Sat Score using the grouped bar graph but it only shows…
-
Hi everyone, is it possible to temporary hide a card shared with others (i don't want to delete it)?
Hi All, I am an administrator and I have created a card that has been shared with a lot of people. I need to temporary hide it as I want to make some adjustment. Is it possible to temporary hide the card? Thanks Alessia
-
Quickbooks Connector Error
Hi, I am getting an error while trying to connect using Quickbooks saying- 'Account Provided is invalid' I have scheduled weekly updates to the Quickbooks report and this week none of the reports were updated displaying the above error message. I am getting the same error even when i try to pull a new report from QB too.…
-
Deep Linking with Filters
I have created a link to a page using the below format- CONCAT('<a href="https://customer.domo.com/page/##########' ,'?pfilters=[{%22column%22:%22Owner.Name%22,%22dataSourceId%22:%DataSet ID%22,%22dataType%22:%22string%22,%22operand%22:%22OperandType%22,%22values%22:[%22' ,`Owner.Name`…
-
how to use rank function that ignore null or blank data
I've tried using rank function in magic ETL, but it also counted the once without data. Please see output. Can someone help me on this.
-
DataSet API: Only DataSets created with the API may be used by the API
Background I posted a question earlier that had way too many parts, so I'm breaking out individual questions. Hopefully, these are easier to answer now and easier for other people to discover later. I can figure much of this out by testing myself, but am hoping others already know and can answer without much effort.…
-
JSONObject error with JSON Connectors
I am wanting to pull data from the Cisco Meraki API (http://postman.meraki.com/ and http://meraki.io/ for more details) and the long and short of it is that most of their JSON comes back wrapped in square brackets []. (Anything that is a List of something). With all the JSON connectors in DOMO I get an error -- A…
-
1 card separated into multiple word files for individual customers
I am looking for a way to use the Beta-Word app to generate word files for all my customers by pulling from 1 specific card but only have that customers data pull from the card. Any recommendations on how to do this. Otherwise I would have to create an individual card for each customer in order to get the data to flow into…
-
Is the maximum columns in a table card set to 100 columns?
I have a large dataset that has 164 columns and I can only select 100 columns, is there a way in a table card to break out smaller datasets into a sub-table similar to a tabsheet in excel.
-
Re: Map Issues - Card Builder
Hi, I have created the first map using state which populates states with the number of orders(using US Map), second by adding a view, added FIPS column(using counties map), I can see all the counties but If go further putting the postal code in the category value. It just doesn't work using US counties map.
-
how do you change the underlying dataset or query on an existing domo card?
How do you look up change the underlying dataset and/or the underlying query on an existing domo card?
-
Custom P&L - Design problems
I am attempting to load data from an azure blob which has billions of rows. The dataset, after load, reports just over 4million rows loaded. Is there a row limit?
-
Is there a way to wrap card titles?
I'm utilizing the design dashboard feature and am noticing that the card titles are getting cut off. Is there a way to wrap the text for the card titles so that the entire title still appears on the dashboard?
-
Google Analytics numbers do not match with those in Domo
Ideas about why the Google Analytics numbers do not match with my those in a Domo card? I set a specific period of time and look at the number of session in my dashboard at Google Analytics. Then when I set the same period of time in a card in Domo, the numbers do not match. For example, the total number of sessions in…
-
Can I use Calculated Variable (Beast Mode Variable) in Stacker?
Hello All, I want to use beast mode created variable in Stacker. . Is there any option of doing that. I have tried but couldnt find anything about it. Any help is much appreciated. This feature should be added.. It would definitely make Stacker App more useful..... Thanks in advance
-
How to automatically export data to CSV on a daily basis?
Is there a way to automatically export data from Domo to CSV files on a dail basis? If yes, is there a way to send the CSV files obtained to FTP servers? Thanks
-
Append data when columns missing from input data
Hello. I have a master dataset in domo which was originally extracted from a legacy system, and has 'timestamp' and 'id' columns which were specific to the legacy data set. New data is identical but with the exception of the fact that it doesn't include those columns. It seems if I try to append the data to the master data…
-
Connecting suiteCRM data with Google Analytics
Hey everyone, I am relatively new to Domo but have been playing around quite a bit with the dashboards, data center and analyzer. I am trying to create a dashboard to show me the ROI of our leads. For that I need to pull the price of each lead from google analytics and the premium off of our suiteCRM. Both are connected…
-
Kafka's Domo connector
I'm trying to find Kafka's Domo connector somewhere, so far no luck. Please notice, I'm not asking about Domo's Kafka connector, which is exists in Domo appstore. I'm asking about Kafka connector that pushes data from Kafka topic into Domo Dataset. Has anyone tried to create one and can share it with me?
-
Any way to normalize a column of data?
Hi everyone, I'm working on a dataset that has an attribute structured with a list of sub-attributes and values, which are separated by colon or coma respectively like this: Does anyone know which tools in Domo can I use to flatten this? I hope this could be like the following instead:
-
Apply same color rules to multiple cards
I have multiple cards on a dashboard built on the same dataset. Occasionally I want to change the colour rules across all cards on the dashboard, but not all cards built on the DataSet. It would be great to have an easy way of doing this.
-
Single Value Card - Showing current and percent change
Hello: Is there a way to building something like this in DOMO? I was thinking of using a single value card but since it is "single" I wasn't sure if this would be achievable. Any suggestions/alternatives would be great! Thanks in advance, Gustavo.
-
Formatting Values in Calendar Card
I'm using a beastmode conactenating two text fields as the value in the calendar. See attached screenshot. I want to place the second value, after the " / " on the next line rather than under the first. Is that possible? It seems writing any html or a break statement isn't working.
-
Domo Has A Connector, But I Want To Built A Custom Connector Instead...
Domo has built a connector to Procore, but the datasets aren't matching what I am seeing (and needing) in Procore's API documentation. Using Postman I'm able to obtain a token without issue, however, I repeatedly get a 404 error when attempting to connect to Procore using Domo's tool. Is there a restriction against me…
-
Regex Command in Magic ETL for cutting the end of a group of URL strings
I've seen a few similar topics but I was unable to know for sure... I am new to Domo and was attempting to cut the latter part of several URL's. For example... .../safety-organization .../safety-organization?cid=adv... .../safety-organization?utm_=... So in this case the latter parts of the URL's are email marketing…
-
Operation Cannot Accept 2 Operands?
Is anyone else getting this new error that popped up overnight for ETL flows that used to work? When I select a filter in ETL that compares a date against the current date, I get this error no matter what I do. Can someone let me know what the issue is and how to resolve or if this is a glitch? Thank you.
-
card run time parameter
Does DOMO support runtime parameters for Cards. IE when a user opens a card they are prompted for the 'number of days to report on'. Then the value they entered is used in a beastmode calculation and the report is displayed.