-
Can color rules be used on the symbols in Grouped Bar + Symbol cards?
My question is essentially the subject of this thread. I am creating a card and need some sort of call out to bring to the attention of the person viewing the card that the value of the symbol (the ratio of actual to budget) is less than 1. This would show that what the bars represent is under budget. I have tried to use a…
-
How can I connect to a shared outlook mailbox?
I've tried using the Microsoft Exchange connector but I was only able to connect to my personal mailbox, not the shared mailbox that I also have access to.
-
Using Multiple Summary numbers, Concat() HTML for color rules, how to get all numbers on same line?
See attached screenshot. Trying to use multiple summary numbers and get the numbers to line up alongside each other (KWH KAU DBA ect), rather than stacking. Beastmode to generate numbers: CONCAT( --KWH (CASE WHEN ((COUNT(CASE WHEN `Analyzer_Domo_Property__c` = 'Timbers Kiawah' THEN `Campaign.Name` END)) / MAX(CASE WHEN…
-
Salesforce - Stage Duration
HI everyone, I have used the salesforce connector for a while now and I am trying to find a easier way to measure Stage Duration in days for each opportunity and its current stage in our pipeline. I know that by bringing opportunity history and events, I could get the minimun date for each stage changes, but it gets tricky…
-
How to create custom role
When creating a new user in Domo, we are prompted to link a role to the user. Currently there are 5 predefined roles listed on the UI. Which are Admin, Previlieged, Editor, Participant & Social. We would like to add more roles. Please do let me know how we can create them. Thanks in advance. Prashanth
-
SAML Use Case confirmation
Please be informed that we are now in the process of implementing user provisioning integration between Oracle IDCS (Cloud IdP) and Domo. Regarding this, could you please provide us the below required details. * SSO use case confirmation: Please confirm Domo supports any of the use cases listed below. * IdP Initiated SSO *…
-
Workbench vs Data center
Workbench allows to connect to on premise data sources while Data Center also allows the same. What are the differences between Workbench and Data Center.
-
Report Scheduler - Excel/PPT exports?
I'm excited about the new Report Scheduler feature, but am curious - will the options to schedule Excel or PPT (etc.) exports be available with this? The Scheduler is a great idea, but at an initial look it seems to be more of a "reminder" for someone to look at a card, rather than a delivery of the data via a document…
-
Color Series in Lat/Long Map
It doesn't appear that the color rules in the release are available in Lat/Long Maps. This has been a difficult limitation to navigate when specific points might be defined by a rating as "Yellow" but the color on the map is blue and cannot be changed. Please advise. Thanks!
-
Is it possible to plot both counts and specific points on a map card?
I'm wondering if it is possible to plot both ranges and points on a map card. For example, I would like the colors/shading to represent the number of clients in each country, but I would then like to plot specific points where the company's offices are located. Is this something that can be done with the map cards in domo?
-
Change Bar Widths of Horizontal Bar Chart
Is there a way to increase the width of the bars of a horizontal bar chart? Even at 100+% width settings they're still really thin, causing the text labels to overlap, and I need all the labels so I can't simply hid the overlapped ones. There's so much wasted white space it's ridiculous to have the bars be this thin and…
-
Magic ETL appears to run all the way to indexing, but fails with an un-specified “Server Error"
My ETL appears to run all the way to indexing, but keeps failing with an un-specified “Failed while executing....The server experienced an error". When I view the details of the "Run", each of the steps has "no additional details" It is an extraordinarily simple: two inputs, group one, join both, output. I have used both…
-
Close Rate Calculation
Hi, I need to create a formula field that is quite simple. I need the close rates for my opporunities in Domo (have a salesforce connector) where "Number of Won Opps"/"Number of Transacions". These are number fields that sum up all the opps in each account that were won divided by all won + lost opps. Could someone help me…
-
MySQL UNION not removing duplicates
I have a historical dataset (HIST) and one that's updated daily (DAILY). The DAILY contains the past 3 days worth of data. So the statement: SELECT * FROM DAILY UNION SELECT * FROM HIST ...should produce a combined dataset, with no duplicate rows. But, I'm getting duplicate rows in my output as if I had used a UNION ALL…
-
Find table in queries
We have a bunch of queries over different PostgreSQL databases using the SSH connector. We've done a model change and I need to go over all the queries that reference a specific table called user_log. Is there a way to find all datasets that refer to this table? TIA, João
-
Dataset API - Getting full dataset list
I'm currently using requests in python to pull in a list of all datasets, however I'm only receving 50 as the max limit and there are >200 total sets. Additionally, about 95% of returned results are created by "DomoBIB" which isn't even part of the dataset that was created by me. dataset_endpoint =…
-
Excluding Weekends from X-Axis
How do you not include weekends from the X-axis? I've already modified the date field so it never has a saturday or sunday for the field I'm using on the x-axis yet the dates still show up leaving 2 day gaps of no data.
-
Creating Percentages for table groupings
I am trying to create a percentage for my dataset that will give me the percent of observations in multiple levels of groupings. So if my data has 2 levels of grouping, then the table would look like this: group1 group2 count percent_Grouping1(A or B) percent_Grouping2(AA,AB,BA,BB) a a 10 33.33% 45.45% a a 4 13.33% 18.18%…
-
How to dynamically adjust the maximum value in the Radial guage?
Hello All, I am creating a card which shows Sales Goal Vs Actuals YTD across different regions. The sales goal is different for the three regions. My client wants this information to be shown in Radial guage with a quick filter for different regions. My question is how to make the Goal Value adjust dynamically in the chart…
-
Drilldown from Gauge Card to YTD Month Grouped Bar
I am working with my company's financial data in Domo to build an executive dashboard which will show, amongst other things, information about actual revenue vs budgeted revenue year to date. I have built a card in which the sum of the rows for actual revenue is the gague value, and the budgeted revenue is the actual…
-
Can I export the list of datasets with the information on the datasets page?
I am new to my company and looking to get familiar with what datasets exist in domo and where they came from. I would like to export the information on the datasets page. Is this possible?
-
Creating a USA County Map with a Longitude and Latitude overlay
Hi, I work for an automotive brand and I am wanting to plot our dealerships in the USA over the top of a USA Sales by County Heat Map. The two map types exist within DOMO, USA Counties and Longitude and Latitude Map. I need to combine the two, I know it needs to be done through an .svg file but unsure on how to get it done…
-
If we turn on SSO, how is the "You've been Domo'd" notification impacted for new users?
We would like to turn on SSO in our environment. Currently when setting up user accounts, a "You've been Domo'd" email is automatically generated and sent to them. This email contains their user name and indicates that they will set up their password when connecting for the first time. But with SSO, they will not be…
-
Is there a way to add a card on a publication group page to your Favorites page?
i created Publication Groups to filter data sets by User Groups. the users can access the publication group page but can not add any of the data cards to their Favorites. Any ideas/suggestions would be appreciated.
-
Filter to get Top 10 Results in Bar Chart/Table
I'm trying to get a Bar Chart and a Table that shows the most requested Services (10 Services with the highest number of rows in the data). Is there an easy way to go about doing this? In my data, each row is a request for a service and there are hundreds of different possible services, and I am looking to get a Bar Chrat…
-
Is there a way to limit which columns can be drilled into on a card?
I am building a card, and only want users to be able to drill into the data based on one specific column. Is this possible?
-
I haven’t been able to see store manager previous month money chase like I do with my employees.
-
Is there a way to tag a person in a Buzz thread without it becoming a Private thread?
Right now when I @ someone the thread immediately becomes a private thread. I'd like to keep the thread public so everyone can share in the discussion, but @ someone if I want to direct information to them.
-
Required Average Line in Line + Stacked bar graph
Hi , Ima using Line+ stacked bar graph . iam using % as line and Total numbers in bar. need to add the average line for this graph. i tried scale marker, but it is not giving option to select value type , only value is there. i dont have any value to be add. i need the average of total need to be come as a average line .…
-
Connecting/Calculating Google Sheets with Analytics
Hello, i'd like to calculate data from Google Sheets and Google Analytics. Here i would like to use the pageviews from a certainly page and sales from a Google Spreadsheet. This data i'd like to calculate. How can i do this? Best regards, Max.