Ask Beast Mode questions and get answers from Domo peers
Okay, so still learning here. I am trying to calculate a waste percentage from used material to installed material. Here's the data I'm working with… Hopefully this makes sense. Column "Product Code Number" Column "Quantity" I want to use the following formula ((Product code number quantity(only for codes…
I basically want, if an employee's attendance is marked PR PH PO PN HL HLWP HCL HEL consecutive 7 days then it should be highlighted as 1, if it is marked on the 8th day again then it should show 2 if it is marked again on the 9th day then it should give 3 and so on. I have data like Date Emp ID Attendance Status…
Hi Community, excited to see what you think up! BLUF: How can I analyze what nurse saw a patient prior to a surgery or a non-surgery? See my simplified dataset below. My hope is to be able to see which nurses saw which patients/customers that led to a surgery (or not). My current thought is a CASE WHEN to create a label…
I have a data set that includes duplicate rows for products. I'm using a fixed function to de-dupe an aggregate sum of product prices because I only want one product row to contribute to the total. The fixed function (total_product_price) looks like this: SUM(DISTINCT Price) FIXED (BY Product ID) However, now I need to…
I am trying to do an a calculation and having some trouble. The formula in my Average Daily Usage column is (Oil Usage / Run TIme Hours) * 24 I guess the formula is technically working when look at columns, but I want this formula to calculate for the subtotal columns when i select a range of dates. So the column in blue…
I am trying to calculate Net working days where working days is from Sun to Sat and the date in the dataset may or may not have date till EOM. e.g.: June'24 has 30 days with 5 Sundays, the beast mode should be able to calculate (30 - 5 = 25) when June'24 is selected from the filter and subsequently calculate Net Working…
New to this :-) My data consists of two things, created date and closed date. I received 45 tickets for week commencing 05/26 and closed 68 tickets for the same week. The tickets received were created same week however the closed tickets are combination of tickets created same week and in the past (backlogs). When I create…
I am trying to set an icon in a table column that links to an outside site/page. The Beast Mode works as expected, but the table is not reflecting the style/height setting. The current version of the code is here: concat('<div><a href="https://xxxxxxxx.app.netsuite.com/app/common/entity/custjob.nl?id=',Customer Internal…
If I have the first three columns of the data(model, variant names and total clicks) is it possible to generate a calculated field which shows the highest click value in a given Model? For example, Model A has 3 variants and the highest amount of clicks among the 3 variants is 33, so the 'Max clicks' column should be…
I need a formula where I can add the "Spot" and "Fixed" columns but only filtering values that are like "GET". How could I do?
It looks like you're new here. Sign in or register to get started.
Have a Domo product enhancement idea? Submit or upvote on ideas in the Ideas Exchange.
Ask questions about Connectors, Workbench, Cloud Amplifier and get best practices from Domo peers
Ask questions about Magic ETL, SQL DataFlows, DataFusion, Dataset Views and get best practices from Domo peers
Ask questions about Beast Mode, Cards, Charting, Dashboards, Stories, Variables and get best practices from Domo peers
Ask questions about App Framework, Workflows, Domo Bricks, Domo Developer, API and get best practices from Domo peers
Ask questions about DomoAI and get answers from Domo peers.
Ask questions about Domo Everywhere, Scheduled Reports, Mobile and get best practices from Domo peers
Ask questions about Governance Administration, Approvals, Teams, Alerts, and Buzz and get best practices from Domo peers
Watch how our Customers are using Domo to solve their complex problems.
Domo support and product teams are here to live-answer questions about the most recent product releases. Please post questions in this Forum board for all users to benefit (rather than submitting a support ticket).
Questions or discussions related to Domo University, trainings and certifications