-
Hadoop Connector
Hello Has anybody used the Hadoop Connector in DOMO? If yes, can you please share the steps required to setup and configure this connector? Many thanks. Regards Praveen
-
Connecting Showpad to Domo
Has anyone ever attempted to connect Showpad data (user, share, content analytics) to Domo's Data Center? I dont see any pre-built data connectors, but if someone has attempted this in the past via an API, I'd love some guidance. Thanks.
-
How do I change the template for email (schedule reports)
Hi, How can I change the layout of the schedule reports email? Thanks, Evan
-
Developing Domo Apps.
As a Domo user can i create Apps (not talking about connectors, just apps in general that might be a chart etc) that i can use? If yes, Can someone point me in that direction.
-
Datasets stuck refreshing
1. So I have a SQL Postgres database that I am uploading to domo via Workbench via 6 ODBS different datasets. (lets call them 1, 2, 3, 4, 5, 6) Each dataset is updated every 30mins from the Workbench - these work like clockwork without a problem. 2. Each dataset is then modified in ETL with some calculations and form in…
-
MYSQL Connector character limit
I'm trying to pull data from a mysql database which has text strings over 5000 characters long, but the maximum length I can get into domo is 1024 characters, is there any way to import the full string?
-
How to uncollapse column when group has multiple values
I am trying to uncollapse a column based on a certain action; however the action can have multiple values. Sensor ID Batch ID Bizstep Location Customer Contact IT-112779 53801991 1 Miami Matches acct ID Matches acct ID IT-112779 53802071 2 Miami Matches acct ID Matches acct ID IT-112779 53866818 2 New York Matches acct ID…
-
Want to group multiple 'CREATE INDEX' into one Transform
Want to group multiple 'CREATE INDEX' into one Transform Transform1 CREATE INDEX idx_1 ON aaaaa(aaa) Transform2 CREATE INDEX idx_2 ON bbbbb(bbb) ↓ Transform1 CREATE INDEX idx_1 ON aaaaa(aaa); CREATE INDEX idx_2 ON bbbbb(bbb); Is this ERR, there is a solution?
-
Workbench CHAR a timestamp
When i use.. TO_CHAR((now() at time zone 'America/Chicago'),'YYYY-MM-DD HH12:MI') Workbench uploads it as a date (Even though i have CHAR it). How can i force Workbench to upload as a char? I have also tried TO_CHAR((now() at time zone 'America/Chicago'),'YYYY-MM-DD HH12:MI')::VARCHAR and there was no difference. I have…
-
Can i change a column Name on workbench upload?
Example: I currently have a column named "REFF" and the dataset is used by 2 cards, when i try to update the column name to "REF" in workbench, it errors with "no matching element found". Once you make the initial dataset, are you set-in-stone with the column names and number of columns? I have it set to "replace dataset",…
-
Gauge card bufferzone between pass/fail
For a filled gauge card, let's say i want to put a goal of 50 on a gauge. Is there a way to have a small buffer zone of color that isnt pass/fail? For example, "goal = 50, but 48 to 50 is yellow not red" Similar to a radial gauge where you set limits to numbers high/low but it is a percentage based. I am looking for a…
-
Question
Is it possible to use the value of a Last Value Projection in a BeastMode calculation to put as a Summary Number on a card? For example, if you used a linear regression to make the Last Value Projection on the bar chart, could you then take the Actual / Projected to get a percent as to how close they are? And then possibly…
-
Color setting on Scatter Plot
Hi, fellow Domosapiens, I have a scatter plot of many points Is it possible to group them by colours according to countries? (e.g. Australia points are blue, Hong Kong are red, etc) I have tried the colour setting on the country column and it doesn't seem to work
-
Domo Publication Groups
Heyyy folks, So one question here. I created a domo publication group with some cards from the template. But when I try to add filter on the datasets (so that our clients won't have access to other publishers datasets), the pages just became unviewable and the acess group become (1 access group, 0 configured) from (1…
-
Is there any example for the Adobe Analytics Advanced Query Report Type
I need to explore option in data connector for Adobe Analytics -->Report Type ---> Advanced Query? Is there any sample examples or query to explore the Advanced Query option for Adobe Analytics. Please adivse.
-
Beast Mode Week Revenue Calculation
Hi folks, This should be a fairly straight forward question. So I need to do a calculation that finds the revenue from 12 weeks ago. I know that I can use weekofyear(). However, since it's only 6 weeks into 2018. This method wouldn't work untill later in the year. Is there a beast mode function that allows me to actually…
-
Is there a way to disable Domo logo and branding in scheduling reports?
Hi, I was wondering if there's a way to disable Domo logo and branding in scheduled reports. We have third party clients whom we would like to send scheduled reports on daily/weekly/monthly basis directly out of Domo. However, due to the sensitive nature of our business, we would have to disable in sort of branding except…
-
Is there a way to stack smaller cards on the page?
I have created multiple cards just have a single gauge on them. As a "quick reference" to the end user, i want to stack these small cards on the page so that they are vertical and utilize the space more. Right now the white space under each card doesnt allow me to drag another card over to it... see photo for reference. I…
-
Can I create a card in Domo from a report in Salesforce?
Hello I would like to create a card in domo through this report we have in Salesforce is that possible?
-
PG_TABLE_DEF doesn't work
I recently came across some websites that have guided me to a solution to perform a transpose function in RedShift. We currenltly have dataflows in MySQL that perform transpose functions with the use of stored procedures, however we would like to be able to convert those to RedShift. In any event, part of the solution…
-
Case statement with multiple field conditions
Hello, I'm trying to write a beast mode fiter that looks for a condition in one field and also searches multiple fields to return a "yes" value. Seems simple enough, but... I want it to: Look in CPT code field and find all records with CPT code of 20610, then look in 5 diagnosis code fields to exclude the procedures that…
-
What's changed with an alert?
Hi, I currently have a card setup with an alert that will go off if the summary number increases by 1. A couple of questions around this: 1. Will this alert trigger if it increases by more than 1? 2. Is there a way to show exactly what has changed on the card when the alert goes off? For more context, this is a table with…
-
Beast Mode Week Revenue Calculation
Hi folks, This should be a fairly straight forward question. So I need to do a calculation that finds the revenue from 12 weeks ago. I know that I can use weekofyear(). However, since it's only 6 weeks into 2018. This method wouldn't work untill later in the year. Is there a beast mode function that allows me to actually…
-
Can DOMO feed data to Salesforce
I am looking to use DOMO as a way to log calls and activity into Salesforce. Is it possible to pull accounts and contacts into DOMO, then let a user update fields, and have it update back into Salesforce?
-
Formatting Header Row in Chart Card
I've seen a few cards detailing how to do conditional formatting but how do you limit your formatting to only the header row. I see no reason to highlight an entire page when I want to use color coding to make it easier for me to direct how the card should be used. I'd like to highlight one column header to indicate that…
-
Capturing Survey Answers in DOMO using Poll Card or other method.
Is there a way to use an online form or maybe a Poll card linked to a Note card to capture survey questions without having to use an external application and then import via a connector? - they do still want to be able to report on the data Would be a simple 3-6 question survey to be used for exit interview. I see there is…
-
Chart types not compatible with IOS app
Could someone point me in the direction of a list of unsupported chart types in the IOS app? It is frustrating to build out cards only to discover they do not work in the app. Thank you.
-
Netsuite - Internal ID
Is there any way to bring in the Internal ID when using the Netsuite connector? Nearly every NetSuite record has an Internal ID, but I know this currently isn't available when bringing in the individual tables. I'm having issues trying to join tables together to recreate Netsuite saved searches that join tables based on…
-
How to change the format of the replacement variable ?
Can anyone say how we can change the format of the replacement variable? (eg) Format in Mysql : 2018-02-09 02:58:45 When i ran the job the format which sits in the replacement variable value column is 2/9/2018 2:58:45 AM. Becuase of this the query is returning a wrong result set can anyone help me with this ?
-
How to Lock Down Month End Results
Hi All- I'm looking for an easy way to lock down month end data/results. I have looked at both SQL and recursive ETL options. These are too complex for a novice user. My challenge is that a crystal report pulls month end data on 'loan status'. (We are trying to get away from these hard copy reports and use DOMO). When I…