-
Getting dataset error: WWorkbench DataSet Job is not allowed to dynamically change schemas. Help!
When trying to refresh a dataset that has not loaded in 24 days, I am getting an error stating: "Workbench DataSet Job (insertcompanynamehere.domo.com:6 (sqlSalesBI_uvwReportTwoYear) is not allowed to dynamically change schemas." How do I resolve this?
-
How do I create a drill path for a stacked bar chart with multiple measures/values?
Hello! I'm new to Domo and spent some time digging around the Dojo to try to find the answer to this question but didn't have any luck... I hope what I'm asking for makes sense; I'm happy to provide details if it doesn't. Thank you in advance for your help! High-level I created a line and stacked bar chart where the series…
-
Beast Mode within a Beast Mode update
I was wondering if there was a way to automatically have beast modes update when another beast mode is changed. For example I have a summary number beast mode that uses several other beast modes inside of it and when I go to change any of those beast modes I have to re create the summary number one. I could delete the…
-
Show beast mode value in drill down detail
When drilling down to the details of a card, should the beast mode calculation show? For example, I have card that calculates the difference between 2 dates. I want to drill down and sort by the number of days, but when I drill down, the beast mode calculation that calculates the dates is not showing, therefore I can't…
-
How do I set up a card to measure users by role type?
I need to monitor the number of users we currently have within our DOMO instance by their "Role Type" Thank you in advance
-
token command is not available in my Domo SDK
Hi, the token command is not available in my Domo SDK. Currently I'm having ryuu@3.0.1 and domo-sdk@2.0.1 versions. Please find the attached snapshot. Please anyone help me. Thanks
-
JSON Advanced with custom parsing date is not working
I have been trying to use the new JSON Advanced with custom parsing but the Date Query Parameters do not seem to be working. Every time I run the connector after saving the date setting that field is not saved, and the query occurs without it being used. Date format is saved but other fields are all deleted. As a result it…
-
How do you create a drill path that hyperlinks to an Opportunity inside Salesforce?
I have a Domo card that shows Top 5 deals, I'd like to be able to click on the opportunity and have it open that Opportunity inside of Salesforce. How can I do this?
-
Summary number color rule?
I understand you can be powerful with the summary number in a card, referencing HTML or calculated fields/etc. Is there a way to set a color rule to it? So if i want to make the summary number RED if below 15, or GREEN if above 50, then i could make the card-size tiny and fit more cards on a page and the end user could…
-
adding drill path view
When you're adding a drill path view, if I have 6 or 7 cards which am wanting to add the same drill path view for, is there a way to do this without having to recreate it for each card?
-
How to Shade Multiple Columns in Table Card w/ Changing Averages?
I am trying to create a Table Card in DOMO which displays each Salesperson on the team in rows with Average Leads/Mo., Average Demos/Mo., and Average Sales/Mo. going across in the columns. What I'm trying to do is get each column to shade green when they are above the team average, and red when they are below the team…
-
I am unable to login to my domo account.
When I try to reset it using the reset password link. It doesn't send an email link to my mail.
-
Join two dataset with count from another table
SELECT `A`.*,(Select COUNT(*) from `B` WHERE `peoplesoft_india_attrition`.`OU`=`B`.`OU` and `A`.`Job Code`=`B`.`Job Code` and `A`.`Date`=`B`.`LAST_DATE_WORKED` and `B`.`Separation Category`='Voluntary') As Voluntary_Count from `A` Hi All, I am trying to join two dataset keeping one intact and from another based on row data…
-
How to link Google Display Ads to Domo?
What is the best way to show Google Display Campaigns in Domo? Is there a way to show the images we are running as Ads in a campaign along with results? I'm basically looking to recreate the attached AdWords report in Domo.
-
How to rename a legend in YoY Chart
I tried to rename a legend in YoY chart, but I can't find any feature to change the name of legend. It shows 'This year' and '1 year ago'. But need to change this to '2018' and '2017' .
-
Workbench doesn't support Group By in a MySQL query
Hi - I have a Workbench job that won't run successfully with the needed group by - if i remove the group by it runs, but only returns one row, due to the nature of the query. Not a helpful error message... Anyone experience this or have any suggestions? thank you! please reach out to @bryanphillips with any solutions.…
-
How do you re-activate a de-activated data set?
I have a bunch of Microsoft CRM Dynamics Datasets that were de-activated because the CRM User was changed. I now have a new user that is working correctly and I can manually run the data sets, but they are still de-activated and the schedule is not running. Is there something else I need to do to get the schedules to run…
-
Progress Bar always shows 100%
Hi, I'm trying to build a Progress Bar and I'm not sure why this is happening but no matter what I do, the bar is always showing 100%. My current Goal value is 13721 and my Guage Value is currently 12488. Doing that math, that should be 91%. Not sure why. Any thoughts?
-
Domo Score
Is there any reason a Domo score should drop? Mine dropped about 15 points in one day and I am just curious as to why it would drop all of a sudden after it has been increasing steadily.
-
Specifics on connecting to Sharepoint and Project
Does anyone know the exact steps (url depth needed) to connect to sharepoint online? Also, will connecting to sharepoint grant access to Microsoft Project?
-
Login with Amazon Connector
I'm looking to create a connector that uses "Login with Amazon" for OAuth2 authentication. In order to get Amazon to accept the request to the Authorization URL you need to register a Return URL with Amazon. This is the URL that is passed as redirect_uri in the Authorization URL. The problem is that the connector makes a…
-
Can I link a custom app to another custom app and send params ?
I have 2 custom apps running on my Domo instance: Can I put a link on one which would redirect to the other and send the applied filters and other params along with the redirection ? Thank you
-
Send/Export settings
Wondering if we have the ability to change some settings behind the "Send / Export" option for users with access rights of "Participant"? (attachment contains some screen shots) In short, I do not want users to be able to email certain cards. I appreciate the fact that a "Participant" user cannot invite users, or…
-
Closing Rate by Deal Stage
Hey guys, We are wanting to analyze what our close ratios look like (%) from a certain stage to closing. For example, we have 5 stages in our sales cycle and we want to see "if we put a deal into the 1st stage of the sales cycle, what percentage of those deals do we close?" and another example "if we get them to the final…
-
Dynamic filtering based on date selections
Hey all, Is there anyway we can display the metrics based on the user selections? Like I have to display the difference between 2 Forecast Sales, based on the user selection of the timeframe(2 calendar dates). It should work dynamically based on User input range? Any way to achieve this?
-
Drill Path to Other Card
Hi Everyone, I am looking for the way to drill down to some other data which is not related to the main card. For example, There are is a card with data "revenue by account per year" as main card and its drill down as "revenue by salesperson by year". Here, when I click on the year 2018, it is filtering to the year 2018 in…
-
Data automatically goes to sum
While making cards my columns are automatically going to sum when I drag them over to the axes or series boxes. It is quite tedious to go back and put no aggregation on each one of them and each time I change the chart type it starts over again. Is there a way to just have it default to no aggregation?
-
Is there a way to implement the Newsvendor algorithm in DOMO?
A client has requested a report which shows a forecast of sales vs inventory for a given time period. What they're going after is Inventory Optimization. This is usually done using the Newsvendor Model. Does anyone know how this can be implemented in BeastMode? Thanks in advance.
-
Timezone issue for Google Management API
Hello. I am currently developing a dashboard and using your Google AdSense Connector. Unfortunately when the Connector communicates with the Google AdSense Management API it always returns an statistics in PTZ-Zimezone (Pacific Time Zone) Fortunately is seems that it could be fixed easly: The Connector should tell Google…
-
Calculating the cumulative sum of a value for a given time window
I am trying to calculate the cummulative monthly sum of a specific value but with the caveat that said value only exists for a particular time window. There will be an associated startDate and an associated endDate for each value. An example data table detailing an example data set is given here: A table detailing the…