-
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?
-
Average Calculation less than Trend Points during time period
Why is my Average Calculation of 2.84 less than all of the Trend Points.
-
% of Total Using Distinct Count
I need to show a % Total of Accounts in the below card. I used the following to get the below % of Total accounts. However, there are multiple rows per account name. The # of Accounts column is calculating a Distinct Count, but the % of Total appears to be calculating of the # of rows, not a distinct count of the Account…
-
How do I reproduce this type of graph in all view
I would like to have all the "turned off" variable lines in a graph turn grey when not turned off and get them to have their selected colour when turn on. See the attached images for a better explanation that makes actual sense. The attached images are all of the same card. The "turned off" variables were turn off in the…
-
Actual month name in smart text - date range
Hello everyone, I am building a card using smart text in the card title to include the time range for which this card is depicting data. However, when I include the date range feature in smart text, the card title preview shows literally "previous month". Is there a way in which I could get it to show the actual month name…
-
Date Reference Exclusion/Inclusion
I'm attempting to write a beast mode that checks a static date with a dynamic minimum date. If the static date is greater than the dynamic minimum date it would be classified as 'No' and vise versa. The beast mode formula: CASE WHEN Onboarding Date <= (MIN(MIN(Report_Date)) OVER()) THEN 'Yes' ELSE 'No' END When I use the…
-
Earn a badge and 20 easy points by updating locations in your profile!
We've recently added new location fields to your profile (Country and Geolocation) so we can make sure to let you know when Domo events are happening near you. Earn an exclusive Location badge (and 20 quick points 😎) by updating the Country and Geolocation fields in your profile here. ** After you've updated those fields,…
-
Anyone else have issues saving changes to alerts?
Trying to change the title of the alert and keep getting this error that it is unable to save. Tried Chrome and Edge. Cleared cache. Don't have time to wait weeks for support to get back to me, just want to find out if it is widespread.
-
JSON No Code Connector - Multiple Date Parameters
I have a situation where I need to pass in 4 date parameters into an API. FromMonth, FromYear, ToMonth and ToYear. However the JSON No Code connector allows for only one date parameter, be it single value or a range. That covers 2 of the 4 parameters I need. It would be useful if the JSON No Code Connector supported…
-
resursion
i have a large dataset that is too large on the SQL source to bring in monthly so I have to bring in daily. So, I need to find a way to keep a few months of data in Domo. What would be the best way to do this? Should I use recursion? Is partitioning another option? I'm not too sure how these work. Would someone be able to…
-
beast mode calculation
Hi Everyone, Thank you for assisting me the last time and hoping the community can assist me once again. I have a table that shows the rows of sites along with columns of how many tickets are associated to the sites and the ticket numbers. The data I need are only for sites that have 3 or more tickets. I've tried filtering…
-
A filter based on weekday or wknd
I have a column with tasks and there are certain tasks I want to see if the current day is a weekday and if the current day is a weekend day id like to see other tasks. Could someone help me with this?
-
Page Filters - Use a text value in "Contains" on filter and save as filter
Hi there, I think this is a feature request.. but just asking a question in case I missed it.. When using a filter on card on a text field, you can use a contains "blah" as a condition. Great.. But then when you go to a Page filter, you can only select literal values (I know you can search and click "all" to get a similar…
-
Workflow function
I am trying to create a workflow function and I am having issues. I am not a developer, so I need help. I finally was able to get beyond the errors but now I am getting errors when I save/deploy. Please help! Here is the code: const codeengine = require('codeengine'); function lookforunlocked () { const api=…
-
User-Defined Functions (for Beast mode and Formulas)
It would be great if DOMO could add user-defined functions as a feature. Is there any discussion of this becoming an added feature? It doesn't seem like it would be very complicated to implement, and won't make the software any less user-friendly for users who are not developing their own functions.
-
Reduce blank space in dashboards
Dashboards currently have extra space between cards on all sides, and text boxes have a minimum height, which leads to a large amount of blank space both vertically and horizontally. This is especially problematic when creating a dashboard that needs to be exported to PDF or PowerPoint. Ideally, we need the ability to…
-
Min(Date) Question
I'm having issues getting my beast mode to show the earliest displayed date. In the attached screenshot I would like the "Test - Min(Report_Date) column to all be the same date (2023-01-01) I've tried the "Min()" function and it appears to only check for the earliest date in each row, not displayed date on the card. Any…