Ask Beast Mode questions and get answers from Domo peers
As you can see top right, Domo has a selection Date Range, Period to Date, and if I click on Week to Date, my 3 cards will update date dimension to current Week to Date, Month to Date, 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…
Hi, I am trying to create a column that shows the year that a financial instrument was created and then I need to add 3 to it. It is going on the bottom of the x-axis so it will show up like '2022-2025' , '2023-2026', '2024-2027', etc. The problem when I go to write the beast mode below is that it thinks it is a math…
I am looking to graph sales data of the weekly average of items sold per month, not sure of the best way to accomplish this. The current dataset that I am working with is essential a transaction detail dataset coming out of NetSuite Analytics Connect, my query references several different tables but I have joined them all…
Hi, need help to show only the current month and next month from my schedule data, but the current month should starts with the 1st day of the month. For example, my pivot table should show only May and June. I have the below beast mode that I put in filter and filter by 'SHOW' to get only May and June but the problem is…
Hi, I need to create a Dashboard that calculates oil usage for Engines. Below is the excel table with calculation I need to recreate in Domo. Basically need to take the tank level and oil added to day tank and engine from day before and subtract today's tank level to get daily usage. Also sometimes there wont always be a…
Can anyone help me what syntax error is there in this beast mode calculation? CASE WHEN LAG(Weighted Average, 1) OVER (ORDER BY Sort: Month Number) IS NOT NULL THEN (Weighted Average - LAG(Weighted Average, 1) OVER (ORDER BY Sort: Month Number)) / NULLIF(LAG(Weighted Average, 1) OVER (ORDER BY Sort: Month Number), 0) ELSE…
Hello, Requesting help on how to resolve this and appreciate your assistance. My data in the table has Year, Quarter and all the measures. But user is requesting the report to be in the below format. Measures/Metrics on he left side while Timeframe on the top as columns. I am unable to do this in Pivot table view in the…
Hi: Can anyone help with Beast Mode code: For each organizations_name, I want to get the sum of requests_amount_recommended if requests_state is granted or closed. organizations_name requests_state requests_amount_recommended org A pending_review 10,000.00 org A closed 10,000.00 org A closed 75,000.00 org A closed…
I need a beast mode so i can sort a column. I need to take the number out of this Engine column so then can sort in order. I have values like this Engine 1 Engine 2 Plant Engine 1 Engine 3 Plant Engine 2 Engine 4 Engine 5 I figure if i can just do a formula to take out the number then i can sort them together based on…
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