Ask Beast Mode questions and get answers from Domo peers
Is there a way that I can ensure the curdate function always uses EST time zome to return the correct date? For instance, at 8:50 pm, the cur date function is displaying 2/4 when I want it to display 2/3.
Hi the following code I am using as a filter on my card and have it set to "on list" its called skus to be purged "CASE WHEN On Order = 0 AND (Future Demand = '' OR Future Demand IS NULL) AND (Future Books = '' OR Future Books IS NULL) AND (Reserved + WMAVAIL <= 10 AND WMAVAIL > 0) AND WAREHOUSE_CODE = 11 THEN 'On List'…
I’m trying to create a row which shows the “Prior Year” value against a field for comparison, simply a 12 month offset of the data as shown below with the "Value" field. This would later enable me to create YoY differences. I will also note that I'm looking for a solution that should be able to transcend filters i.e. you…
Hi, could smb help me on the issue below please: the below CASE model for 'Royalty add on' is splitting my ORGANIZER 'Live Nation Italia' into 3 columns creating splits also for Autorization and Shipping exp. The idea is to have a sum of all these values and see only 1 column for Live Nation Italia. I know for sure that…
Hi Everyone, I created a card that uses a date_time_start dimension along with a ticket count on a metric table. This card shows the number of tickets that have a scheduled dispatch showing date and time. What we want to do is turn past tickets to red except for today's and we used the Last 7 days by hour but the date…
I want to subtract Amount from Test1 by using a beast mode. For example; week ending date 1/5/2025 I want to have a column for the difference of $514,953 - $154,400. In my test1 column I am using the SUM(Distinct) best mode. Will this cause me not to be able to subtract? I am not able to get a column that shows a…
Hi I've only been using Domo for about 9 days so still very new to this but I am trying to use the SUBSTRING function to return the values in my ID column to ignore everything before and including and underscore as this value varies in character size (example EN_, ENR_, ENO_) How do I get the ID column to return the values…
Hello DOMO Community, I have a dataset that keeps a running total of users by day. I need a beast mode that pulls the last value from the running total column for the filtered period based on date. EX if the filtered period on a card is 5/25/24-11/16/24 I need the beast mode to return the running total value from 11/16/24.…
Hi all, I am looking for a way to show total sales performance for various items relative to individual users performance for their own sales performance. Please see attached image for a better illustration of what I am trying to accomplish. In this example, I want to pass the logged in user name into a case statement.…
As you know Domo has a selection Date Range, Period to Date, and if I click on Week to Date, my 3 cards will update the date dimension to current Week to Date, Month to Date, and Quarter to Date. I'm trying to create a filter or a button to do same functions Period to Date: WTD, MTD, QTD, YTD without clicking on Date…
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 Jupyter Workspaces, R & Python Tiles, AutoML and get best practices 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