-
PDP and Social Users
We are testing a social user and have assigned that user to a PDP group. When an alert goes out to the user, and they click on the card in the email, they are seeing all data, not just the data in their assigned PDP group. Do PDP assignments not apply to social users?
-
How do I export a list of cards?
As an admin, I can see a list of cards. How do I export that list so I can share the knowledge of what's already been produced?
-
OData Connector or a workaround?
Other BI tools (Tableau, Power BI, etc) offer connections to OData sources (see hyperlinks for related documentation for each tool). I was wondering if Domo has any plans to support that in the future OR if anyone here knows of a different way to get to the data? I'm not sure my specific use case is important for this…
-
Using Google Sheets to pull in AdWords data but exceeding Google's 2 million row limit
We have a client that wants to utilize the Google AdWords workaround via Google Sheets. Currently there is a limit placed on a Google Sheet of 2 million rows that can be pulled into Domo. Our client has about 1.7 million rows of data coming in per day, which makes the daily append of pulling the last 7 days impossible to…
-
Where can we find DOMO usage datasets
I need to find information regarding all the Dataset and its related dataflows along with the name and link for all the DOMO cards using those dataset or dataflows. Also where can I find DOMO usage dataset ?
-
ChannelAdvisor Connector
I haven't seen anyone post on this connector but I wanted to know if anyone has had any luck making it work. I have used the same Developer Key and Password that we use to draw orders into our ERP with but they don't seem to be working on the connector. I am not getting any errors when I save the credentials but the…
-
y-axis won't scale when using 100% vertical stacked bar chart
I am unable to change the scale on my % vertical bar chart. I want to see from 50%-100% on the chart but it won't allow this in the chart properites after I enter in a minimum value. How do I fix this?
-
Custom App - Make Default View on Page the Thumbnail Image
Hello, I was wondering if there was a way to get a custom app to only show the thumbnail instead of the card when deploying it to a page. Then, once the user clicks on the thumbnail image, it will take them into the card (similar to what the Card Builder apps do). Some of our current apps can get quite large and it would…
-
"Run all transforms" button
Can we have a button to run all transforms in sequential order to preview the dataset? It would save us a lot of time when validating the SQL and our data. Thanks so much!
-
Automate Excel Data Refresh
I am new to DOMO so excuse me for my ignorance. Is it possible to schedule and automatic Excel data refresh? Lets say I have a network shared drive folder. Where in I put excel files. Now, can I automate the process to upload the excel to DOMO and refresh the cards to use the new excel everyday?
-
Dataset jobs not running on set schedule
I've been running into issues where Workbench is scheduled to run a job every morning at 6 AM, but when I open Workbench at 9 or 10 AM the job hasn't run and the status under the job name just shows "Next run scheduled for 6:00 AM". Has anyone run into this?
-
When printing table charts
When we export a table card, we need to see all rows, which export to PPT doesn't allow. If you print, i think you get all rows. It would be nice if the "Print" option could be enhanced to include a company logo, but more importantly, when the options window comes up, if you could choose to add in the filters, so the…
-
Conditional formatting (Color)
I have a card that shows a single value, Sales Productivity (Sales expense/std margin). Then in the summary value i show the PY Sales Productivity. How can i format the single value so that if it is greater than PY it is Red, otherwise, Green?
-
Remove HTML Upon Export to Excel?
Is there any way to get the returned value of HTML code to export to Excel instead of the code string itself? For instance I have some codes that look like this: CASE WHEN IFNULL(`CX.TRACK.01`,'1/1/2099') = '1/1/2099' THEN CONCAT('<div style="background-color:#fcbcb7; width: 100%; height:100%; margin:-20px;…
-
Downloaded NPS dashboard but not able to edit the Cards ?
Hello Team, We have downloaded domo default Report for NPS we have plugged our own data but unable to edit the visuals, we want to add filters like date etc. To get the time based NPS. Regards Nitesh
-
Column limit in Table card?
Is the Table card locked to 3 columns max in the dashboard view? I've tried configuring the column widths manually and I can't get the card to show more than 3 columns no matter how small the column widths are. Armen
-
Onedrive for Business Connector - Can't find correct redirect url
I'm trying to set up the OneDrive for Business connector, but I'm stuck at trying to find the correct redirect url. Every time I try to connectt I get following error message: "The reply url specified in the request does not match the reply urls configured for the application: '8555a72d-60dc-4352-97a1-d44465b9d480'."…
-
How to separate a date and time field into two separate fields of date and time
What kind of formula/method do I need to use to create a "Date" column and a "Time" column from a "date Time" column? For example: I Date andTime I I 1/2/2016 3:00PM I Into I Date I Time I I 1/2/2016 I 3:00 PM I
-
Using Domo Workbench, how to I set it to upload my my rows as headers?
Currently, I am trying to upload Excel through Workbench. My data is set up as column A as the header and column B-Z as dates. How do I have Workbench upload Column A as the header. Domo has the capabilities to swap rows/columns through their manual uploads. Any suggestions?
-
Remove text without removing decimals
Using an ETL, is it possible to remove text without removing decimals? For example, I have a dataset that includes values like this: 1.0 8.54578 N/A 7.49687587125516 ..... Using "Text Formatting" to "Only show numbers" results in the following output: 10 854578 749687587125516 How can I extract the numbers from a column…
-
Notebook Cards in Publication Groups
I have created a Notebook card that I put assumptions and other notes on. It is on a subpage and when I add the subpage to a publication group, the cards appear but the notebook is not visible? Are others seeing that? Is it a known issue/concern? Been searching and dont see anything so I wanted to throw it out to the group!
-
How to access page level data from Google Analytics data?
We have Google Analytics data feed . I want to be able to filter on a specific page url to build cards. How can this be done?
-
Progress bar - more than 100%
I have a progress gauge bar that displays sales to plan as a percentage on the month. When we exceed the monthy target, the progress bar does not go past 100%. Say for example, we finish the month at 102% of the plan. Is there a way to display this in the progress bar as I like the graphic. If there isn't a way to display…
-
Average run time of a redshift data flow on large dataset
Hello, I wanted to get a general idea of your redshift run time. Any input is appreciated. I have a data set with about million rows and 123 columns. However, it took 3.5 hours to simply have a subset of 1 column and almost 10 hours to run my data flow with some left joints. This dataset need to be refreshed everyday, so…
-
find % of row value vs. column total
I have a column of various quantities and I want to find the % value of the specific row value when compared to the column total of quantity. Is this possible in Beast Mode or Dataflow?
-
How do you enable UPSERT capability on Workbench 4?
How do you enable UPSERT capability on Workbench 4? I was told that the workbench has this ability but some tweaks need to be made to some files associated with the workbench for it to work. In my mind, upsert would be very useful for data that changes often but avoids the pain of replacing an entire dataset. Especially…
-
Java SDK -- Full authentication is required to access this resource
Hello I am trying to use the Java SDK to access a stream, when I run the app I get the following error Exception in thread "main" com.domo.sdk.request.RequestException: Error making request url:https://api.domo.com/v1/streams/662?fields=all reponseBody:{"status":401,"statusReason":"Internal Server…
-
How to stop dataflows that get stuck at Indexing step
Hi everyone, Every now and then I run into a dataflow that runs fine but gets stuck at the Indexing stage for an hour or two. These dataflows normally take only 5-15 minutes to run, and the next time they run they don't get stuck in the indexing stage. It seems to be a weird hiccup that happens at random. Is there any way…
-
Min(Date) function in Magic ETL to create a "Date of First Sale"?
Our client wants us to create a dataflow in Magic that includes a "date of first sale" column. In Redshift, we're able to perform a min("1st sale") calculation, but we're not able to find a way to perform this function within Magic ETL. The client has expressed that being able to use Magic is critical to them, so we really…
-
Domo Everywhere + SSO
We were using publication groups and publication group SSO in order to dynamically filter a card based on the user ID for external users. The use case here is that we are embedding a dashboard into our platform and each user should only be able to see their own data. The issue with pub groups is that the entire page is…