-
Filter out happy people
So, that's a strange title… Here's the deal: We have survey data about support tickets. It's pretty basic— just Good, Neutral, and Bad as responses. A person can be interviewed more than once. So, I've been creating a visual of "Sentiment by user". It's a stacked bar graph with the following: X axis: The user's name Y…
-
Selecting prefix for conflicting field names
When joining datasets, Domo alerts you to any conflicts in the naming. Specifically, any common field names have to be renamed. It defaults to using the name of the originating dataset as a prefix. We use longish, descriptive dataset names, and the narrow, static width of the editing line makes renaming very tedious. Is…
-
Are PPT exports and Domo plugin visuals static?
I've been working with PPT exports of charts as well as the Domo plugin for PowerPoint. I got the idea that these are dynamic— they update when something in Domo updates— but my experimentation does not confirm this. So, is there a reasonable way to do that? The exports and the Domo plugin methods do not work. I'm looking…
-
Graph export to PPT does not show legend
We have a visual composed of a Donut chart with a 3-line legend below. The legend consists of a color, a category, and a percentage. It looks great full size and and as a card. When I export it, though, the legend is replaced with the text "3 more…": Is there any way to keep that from happening? This is a very odd thing.…
-
ServiceNow connector - Name for custom table in setup
I'm trying to use the ServiceNow Connector (the non-Upsert version) to bring data in from various tables. The human-friendly name is My Requests, and the entity name is sc_request_list.do, assuming I've understood what I'm looking at. I'm kind of new to SNOW, so I could certainly be wrong. Here's the name on-page: And the…
-
Can the ServiceNow connector pull in multiple SN tables?
Hello. I'm working on getting ServiceNow data into Domo. There is a connector, of course, and I have gone far enough into the setup process to confirm that my credentials are working. I see the options to fetch standard and custom tables, but apparently can only mirror one table. Am I understanding correctly? Is it only…
-
Getting Calculated Line to appear on dashboard bar graph card
I have a horizontal bar graph showing percentages. On the graph I have selected to show the average as a calculated line: When I view the graph full-size, not as part of a dashboard, the line is visible, and it has a label underneath it showing the average value; in this case, it's the red line: The black line is a goal…
-
Errors when using domolibrary with client ID and secret
Background and setup: I created a client using developer.domo.com and gave it the "data" scope. I have a client ID and secret now. I have tested it using the PyDomo library and it has worked. However, my goal is to programmatically get and store dataflows as an off-Domo backup. Domolibrary was recommended in another…
-
Backup of ETL
I have a number of ETLs that may need to be extensively updated or removed. I would like to create a backup. I understand that there is a versioning capability built into Domo, but it would be very useful to have an offline backup as well. Besides manual work, is there a way to do this?
-
Is PyDomo appropriate for my data update work?
Hello. I've been reviewing different methods of updating data in Domo. I'm currently using Workbench, but am considering creating a completely hands-off setup using PyDomo. So, here's my scenario: We have a number of datasets that originate from ServiceNow. I put those through some local processing using Python scripts,…
-
Creating drilldown with implicit filter
Please don't read too much into the question title… This is a probably a pretty basic thing that I'm just overlooking. I have a very simple table dealing with helpdesk tickets. The columns are Group, Status, and Count. Group is simply the name of the group that handles the ticket, Status is things like Open, Closed, etc.…
-
Text box is not populated by Beast Mode
So, I have a beast mode that generates a text block with some basic information about a helpdesk ticket dataset. Its purpose is just to let the user know how recent the data they're seeing is. In short, it tells (1) when the ETL was last run, and (2) the most recent ticket ID and date. Simple enough, I'd think. If I add…
-
Transferring work from on Domo environment to another
Until recently our organization has had a single Domo environment (that is, a single subdomain like xyz.domo.com). This was used for both internal and customer-facing reporting. Now we have a second one, zyx.domo.com. The environment xyz will now be used for customer-facing reporting, and zyx.domo.com will be for internal…
-
Adding filtered count to dynamic text box
I have a dynamic text box that says, in effect, "As of 4/7/2023, there are 75 unhandled service requests." I do this by having as the category a beast mode called "Today", which is simply CURRENT_DATE(), and as value I have "Age", a numeric field showing how long ago, in days, the request was created. I would like to add a…
-
Can dashboard separator width be reduced?
Is there a way to reduce the width of the separators on a dashboard? I'm referring to the grey parts as shown here: They seem excessively wide and take up useful screen area. I'd much rather have a slightly more readable chart than wide separators, letting other attributes help delineate chart boundaries. How can these be…
-
Highlighting "current" on slicer
I have a slicer on my page that's a list of a series of roughly 2-week time periods. Some are past, one is current, some are future, like this: 2022-p24 (past) 2022-p25 (past) 2022-p26 (past) 2023-p01 (current) 2023-p02 (future) 2023-p03 (future) Note that the parts in parentheses are not actually in the slicer-- those are…
-
Getting the last field of a character-separated string
I have a field that has an odd structure. It looks like this: asdfas\\qwerqwer\\..\\vcbnvcn To be clear, the .. means that there's an arbitrary number of double-slash separated strings, not a literal double dot. Also, each field can be of arbitrary length. I need the last field. In the example, I need to return vcbnvcn.…
-
Sorting order of sub-bars in nested bar graph
Hello all. I'm working on a nested bar graph. On the x-axis are calendar months (represented as 2021-4, 2021-5, etc). The y-axis has a count of tasks accomplished. As the data table shows, a task can be Low, Medium, High, or Uncategorized priority, and the greyish-purple background bar for each is the sum of all tasks in…
-
Highlighting slicers/filters based on another metric
Please tell me if I've missed this as an already-submitted suggestion. I didn't see it, but I'll withdraw this and upvote another if it already exists. For the filter cards, I would like to have the option to have logic-controlled highlighting of values. For example, suppose a business pays employees on the 1st and 15th of…
