-
Validate Syntax
Good day, Just want to confirm if my syntax is correct? CONCAT(FLOOR(([record_age] / 86400000)), ' days, ', FLOOR((([record_age] % 86400000) / 3600000)), ' hours, ', FLOOR((([record_age] % 3600000) / 60000)), ' minutes, and ', FLOOR((([record_age] % 60000) / 1000)), ' seconds') I was intending to convert a milliseconds…
-
Transforming an array of custom fields
I have a dataset currently flowing in from MongoDB which is essentially populated based on custom fields that are optionally set within the source. Each element in the array has the name and value of the custom field (ie. customField<0-N>_fieldName and customField<0-N>_fieldValue). The issue is that it's not always the…
-
Beast Mode Calculation partly displaying on the card.
Hello, I need some help. I have made some calculations in beast mode to convert minutes to seconds & the beast mode runs ok. However when I pull in the metrics & respective stages into the card, only the first stage returns the expected values. The formula for all the stages is the same but only changing the stage level.…
-
Using pfilters with more than one value
Hi, we have this dashboard with several card filters and we want to click in one "button" that would open the same dashboard with all the filters applied. We know that this is able to do it easily by creating a BeastMode with pfilters as shown here and in the @MarkSnodgrass video. However, we are not able to find a way to…
-
Transpose columns into multiple rows
I have this data set: Member ID 23-Jan 23-Feb 23-Mar 23-Apr 22-Jan 22-Feb 22-Mar 22-Apr 123 33 41 23 23 32 32 34 34 456 4 15 15 15 6 6 2 2 789 2 4 8 8 8 4 8 12 111 24 24 26 26 27 22 27 27 222 3 12 12 13 14 14 12 12 333 2 1 1 444 2 2 2 5 6 8 10 11 The date columns represent the amount of logins to their account by month. I…
-
CourseBuilder - editing trainings created by Domo
Hello, It looks like as recently as 2022, there was a way for me to download courses from learndomo.domo.com and reupload them into CourseBuilder so that I can tailor the trainings to my organizations needs. I don't see an option to "Train Your Team," as is included in some previous forum responses from 2018. Is this still…
-
Add DomoStats Alerts to Observability Metrics in the Governance Toolkit
Having the DomoStats Alerts report available in Observability Metrics would be helpful. Without this dataset, we can't completely understand how our data is used in Domo Everywhere subscriber instances. Other Observability Metrics reports let me see how data is used in cards, dataflows, dataset views, etc., so we can…
-
Dashboard shows data for some, but not others
Certain users who have been shared on a new dashboard are seeing "no data in filtered range" for a bunch of cards on the dash. For other people, the data shows as normal. There is a default filter view I've set the dashboard to, but I made sure that filter view is shared with everyone. Any idea why certain users can't see…
-
New Relic NQRL Connector not working
I am trying to setup the connector and I have tried all possible combinations of API key and API URL but none seem to work. I have followed the instructions in the documentation () and not even like that. I saw that they move to NerdGraph so I tried their URL as well but no results. Any advice on this one?
-
Improve Auth method for SharePoint Connector Plugin via Workbench
We had a problem with the SharePoint plugin for Workbench because it only supports Basic Authentication. In the past, we were connecting to SharePoint just fine but the customer upgraded their authentication method from Basic to Modern and now the jobs we had stopped working. It would be nice for Domo to add the…
-
How do I change the calculation on my chart
I'm pretty new to building dashboards, and have mainly done front-end organising and stuff. I'd like to change the calculation of my chart, currently it is showing % of total respondents, but I want it to change that calculation to be % of players who answered a specific code in the previous question. e.g. instead of the…
-
Scheduled Report Owner
Currently Scheduled Reports are only able to be "owned" by a single user. If changes are required and that user is on leave, the reports are unable to be edited. Requesting that Groups are able to be added as owners of Scheduled Reports, this would solve the issue by enabling teams to manage the scheduled reports for a…
-
Output Dataset
I am getting an error with my output dataset. Also, I need the output dataset to be the ETL data flow. What do I need to do to fix it. Thanks,
-
"Department" Attribute. How can I remove ones that no longer exist in our organization.
While editing a user via the UI, the department attribute seems to build a dropdown list of possible selections. It also allows one to create a new department name. How can this list be edited AND/OR restricted to only allow Admins to edit?
-
How to Sort by ASCII (caps first)
I have a user complaining that their pivot table column sort changed recently. It used to sort capital letters first. For example, it used to sort DOMO before David, but now it sorts David before DOMO. Now it ignores upper/lower case when sorting. I prefer ignoring case when sorting, in general, but is there a way to sort…
-
Common Practice Joining
Hi, I am running into an issue where I am trying to join two datasets. Joining on a Unique ID is not an option as whoever set up this dataset decided not to include one. My next thought process was to join on date and name. Here is the issue I am running into. Dataset one has the full name for example Fredrick. Dataset 2…
-
workbench job - syntax auto fill
Hello In our workbench jobs, we often alias columns and tables with A., B., C., etc. When I type "A." and it autofills to the ADD function, and C. to CASCADE, etc. Does anyone know how to/if you can turn this off?
-
API failing to share newly created dataset
I have a dataset I am pulling from Domo and splitting into multiple datasets based on a specific field. I am trying to share them with a group as they get created but I am coming across a 404 status error (Path not found). my path is currently https://api.domo.com/v1/datasets/{dataset_id}/sharing. It had worked in the past…
-
Heatmap - Configuring Display
Two questions… is it possible to have the X-Axis labels at the top, rather than the bottom? Is it possible to set a fixed width to the columns as is doable in a standard table? Have been searching, and evaluating Properties, and have not found solution to either of these two.
-
Setting company timezone back to UTC or Undefined'?
Doesn't seem to be a "general Domo use" or "dumb simple questions" subforum here, so I hope this is the most appropriate spot for this. A co-admin changed the company timezone under More > Admin > Company to something other than the default. This has thrown off the timestamps in our visualizers. There does not seem to be a…
-
How do I get future data being populated to current year?
I have a requirement to show Next fiscal Year data into Current chosen fiscal year. So if user choses , FY 23, it should show data for Fy24 in 1 column. Please see below: If FY is selected, then monthly data is shown for current fiscal year. and similarly NextFy data (Fy+1) is also displayed like below. Please suggest.…
-
Can I take out columns such as "__created__," "__modified__," etc., from my collections?
I am creating a ddx brick in DOMO. My ddx brick has collections support in that when a user makes changes to the brick, the changes are written to collections. However, in addition to user changes, columns like "__created__," "__modified__," etc., are also written to collections. Here is a visual demonstrating what I am…
-
Unexpected error with pydomo "ds_update"
Hi. I use pydomo to daily import external data using the "ds_update" function. Today, on January 23, 2024, when I executed the script that I have been using so far, an unexpected error occurred, preventing the data from being imported. I operate three similar scripts, and all of them encountered the same error today. I'm…
-
Spreading out labels so it's easier to read
Hello, I am trying to spread out more the following labels that come from a Lollipop chart so it's easier to read, but am having trouble finding the setting in analyzer. Thanks for the help!
-
Creating a Beast Mode to calculate field sums for remainder of year
Hi - I am trying to write a beast mode calculation that sums a field from an as of date until the end of the year. The variable is indexed across the year and want to count how many are left depending on what date is entered. For instance if 1/22/24 was the date it would count all the values indexed for the variable until…
-
Beast Mode for same date check
I have a list of companies and their create date. I want to create a beast mode that checks if a list of companies has the same create date. Any help here? Would this need to be done in Magic ETL?
-
Creating a new column using Formula in Magic ETL
Hello, I have a dataframe with a column named 'Screening Date' in that column are dates and null values. I want to create a new column called 'Completed' that looks through 'Screening date' and if there is a date in a particular row I want to Write "Yes" in my new column. If the 'Screening date' column is null I want to…
-
5 Job Openings for Domo Users: January 22-28
Hello Domo community! If you're looking for a job that uses Domo, look no further. We found five job postings that mention a need for well-versed Domo users. A+E Networks - VP, Marketing Analytics In this pivotal role, you will harness the power of data-driven insights to shape and execute high-impact marketing strategies,…
-
Average Loan Size
How do I calculate the average loan size using a histogram
-
How to change color of bar charts (top 5)
Hello. Can someone help me if there's a way to use a different color to indicate the top 5 items in the bar chart dynamically?