-
Time Difference in Minutes
CASE WHEN Hospital Ready Time (UTC) IS NOT NULL AND Video Start Time (UTC) IS NOT NULL THEN ABS(UNIX_TIMESTAMP(Hospital Ready Time (UTC)) - UNIX_TIMESTAMP(Video Start Time (UTC))) / 60 ELSE NULL END I am trying to find the difference between 2 timestamps. I am using the above beast mode calculation but it is giving me…
-
BEAST MODE CALCULATION ISSUE
Using the Beast Mode below I am being forced to use the ABS function in order for the Beast mode to give me a calculation. If I remove the ABS Function I get the error "An issue has occurred during processing. We are unable to complete the request at this time". The issue I have is I need to remove the ABS (Absolute Value…
-
How do you get rid of the max, avg and min in a chart
-
data/v1 endpoint - Filter on columns and values with spaces in their names
Is it possible to filter results on the data/v1 endpoint with columns or values that have spaces in their names? I've tried every combination imaginable to get results for a column named Spend Category, but continuously get this 400 error. Filtering results with columns and values that don't have spaces works as expected.…
-
Data Processing using Partition
Why I am having data loss issue when using data partition in Domo ETL?
-
Governance DataSet - Scheduled Reports
It would be helpful to be able to access attributes around scheduled reports via the Domo Governance connector. It would be nice to be able to filter by a user/group to see what reports they are getting instead of going through each scheduled report individually in the Admin center.
-
Summary Number value type
hello Is there a way to get the actual decimal value for a card in the summary number - the actual value here is supposed to be 1,495.93 but its showing 1K. If i used a single value card, I know how to update it. But not sure how to change that for the summary numbers.
-
Support for multiple delimiters in CSV for use in European countries
A significant number of countries do not use a comma as a delimiter for CSV files. The inability to select an alternate delimiter such as a semicolon cause issues in these countries.
-
How do you set the default delimiter when exporting via CSV?
We have a larger number of users that are in European countries. The default delimiter in CSV files in Europe is a semicolon not a comma. We allow the users to export the data from a card as a CSV. How can I set the default delimiter to be a semicolon instead of a comma?
-
Show Subtotal Rows - suddenly not working for my pivot tables
Hello! Previously my pivot table cards have "show subtotal rows" turned on to show the subtotal sum of certain values. I logged in today and realized that all of these pivot tables stopped showing the subtotal row, even though I didn't make any changes. Is this something that I can fix quickly? Thanks!
-
Trying to use Unpivot
I have a dataset. 1 order has 10 stages. each stage has a schedule date, completed date and status. 1 order has 1 row and 30 columns. I am trying to unpivot to 1 order having 10 rows and 6 columns. I used 3 different unpivot tiles for it. I built out the ETL but not sure why its taking forever to run.
-
How to calculate Average
-
Duplicate filtering status to top right of card
Currently the filtering status appears at the bottom right of cards. When you have cards that are quite tall it would be good to have the filtering duplicated to the top right of the card as well so it is obvious to the user that the card has finished filtering.
-
Can't Edit View
I'm a DOMO Admin and there is a DOMO dataset view that I can't edit - I'm getting the message 'you don't have access to edit this view'. The person who created this dataset also gets this message - nobody can edit this view. I created a copy and can edit that view but I need to understand why this message is appearing and…
-
Joining and getting all dates between start and end date
Im doing a join on billing ID's. Each billing ID has a start date and an end date. Im trying to return all dates between start and end date for each billing ID. I tried adding this formula to join. dt BETWEEN Service Start Date and Service End Date It isn't working as expected. Im just getting one date for each billing ID
-
Is it possible to batch edit source data?
I have a large dataset that needs some cleaning. We have appended to this dataset daily over several years and some of the data values have drifted over time as users have renamed what are essentially labels for different entities. If this were SQL, I could write an update statement and quickly replace the values in label…
-
Color Coding or conditional formatting in DOMO?
I am trying to make a scorecard for budget…etc… Let's say our budget in Jan was $14,418,053 and are actuals were below that. How could I turn that budget red? and vice versa if actuals were above budget it would be green? Is this possible in DOMO yet or are there work arounds. Thanks, Garrett
-
Extracting Data from SharePoint Excel spreadsheets
Hello everyone, I'm in the process of setting up financial reporting in Domo. Our FP&A team processes financial data and then stores it in two specific Excel sheets within our SharePoint. I'm looking for the most effective method to extract this data into Domo, creating a dataset that can automatically update with new…
-
5 Job Openings for Domo Users: March 18-24
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. Swire Coca-Cola - Senior FP&A Analyst The Senior Financial Analyst provides an outstanding opportunity to gain broad experience across all functions in Swire…
-
Enhancement to User List Attributes and Custom Attributes for Dynamic PDP
Hi, In a PDP policy you can now filter the data based on a trusted attribute. Now that trusted attributes can be lists it would be great if domo could perform an IN on the column instead of just always matching exactly. For example. We pass through a list of site ids that a user is allowed to see in the data. Ideally in…
-
How to remove a personal comment/post
👋Hello Domo Community!👋 We have made some recent changes to the process of deleting personal comments and posts. Currently, anyone that is not an admin does not have the ability to delete anything; this includes posts and comments made by oneself. The forum has a plethora of knowledge and we want to mitigate removing…
-
March Madness BRACKET MANIA: Enter to win $500 in swag 🏀
Ready to score big this NCAA season? Domo is giving away some sweet prizes! @colemenwilson and @nathankilcrease created Bracket Mania — go check it out! This public dashboard uses historical NCAA data and more “novel” data sets to create a predictive model to help guide building your bracket. We love to see our Community…
-
Trusted Attribute PDP Filters That Allow "Contains" Logic
It is a manual and time consuming process to manage personalized data permissions (PDPs) today, especially if you have multiple data sets and a large organization. That doesn't have to be the case. The end-to-end process of adding data permissions could be almost 100% automated with one small change to the current setup of…
-
Subscribe to status.domo.com
Hello, Just wondering if there is a way to "subscribe" or somehow get an email when DOMO is having issues or anything is going on and it is reported in the status.domo.com page. Thank you
-
👑The Legendary Head Dude— John Le— Finally Ascends to Coach Status!
If you were wondering why the Earth shook yesterday, it's because the Head Dude himself finally hit coach status. John Le, better known on the forum as @DashboardDude, is a certified Domo celebrity. If you've been around the community long enough, there's no doubt that you've heard his name come up at least a few dozen…
-
Scatter Chart with Non-Numeric Y-Axis
This Scatter Chart's Y-Axis is a count of the number of Days of Excess Annual Leave (EAL) - and, just for context, the Bubble Size indicates how many Employees have that many days of EAL, and the colours (or 'colors' for Domo HQ 😁) categorise the severity of each cohort. As the attached image shows, the chart is quite…
-
Shows in Analyzer but not in dashboard
Hi, I've created a YoY comparison chart by month and it shows up fine in the Analyzer mode. But when I 'Save & Close' it doesn't show up on my dashboard or through the PPT plug in. This is the view in Analyzer: Then this is what I get in the dashboard: I'm certain it's Operator error! Thanks!
-
Split Edit and Share Grants
Requirement: The main requirement is that a customer would like Sharing to have as its own grant on objects rather than combined with Edit grants. It will enable them to have better governance of their instances. Current Behavior: The current Edit Cards grant is too broad and allows multiple activities for an end user. We…
-
how to combine mutiple rows into one separated by ','? Form builder muti selection data handling
I used form builder and there are couple fields are multisection dropdowns, in the response dataset, it separates the selections into different rows, but I want them to show as a,b,c together not a(next row), b(next row),c. Does anybody know how should I use the magic ETL to do that? I used my old way to transform the…
-
Custom Color Range
Would love to be able to create custom color ranges. Some cards have too many series to manually define a color for each. It would be great to be able to define a custom color range (i.e. pick a color on the left and a color on the right and it automatically fills-in the middle with gradients between them). This would also…