Ask Beast Mode questions and get answers from Domo peers
Hi All, I need to write a case statement that would calculate 28 days from a selected date. How would I write that? The end result would be total sales within the 28 days going back in time from the date selected. Thanks, Paul
CASE WHEN Sort: Month Number = 1 THEN NULL ELSE ( (SUM(All Cases) - LAG(SUM(All Cases), 1) OVER (ORDER BY Sort: Month Number)) / LAG(SUM(All Cases), 1) OVER (ORDER BY Sort: Month Number) ) END I'm not able to figure out what is the syntax error over here. Can anyone please help?
Hello. Can you help us find a solution how to display the output we want to achieve? This is the current output that we have, but we wanted to see a view using bar graph. The problem is that, the values are 'string' and not 'numbers' because of the concat function we used in beastmode to identify whether the computed…
Hello, I'm currently working on a Dashboard. In this dashboard I have three different cards: one is a slicer that allows you to select certain deal numbers, the other is a product description based on the deal number, the last one is product description by date. Now what I have not been able to figure out when I select a…
Hi everyone, I have a pivot table which contains plan data. The key point is we need to allow one month post plan completion to allow for data collection and input. Country Plan Name Start Date End Date Status Delivered data available Austria Plan 1 1st Jan 2024 1st March 2024 COMPLETED YES Malta Plan 2 1st Jan 2024 1st…
Hi all, I have a table that has these columns: loan number other loan number first principle balance hi type description 2nd mortgage amount is the field we are trying to create The logic is such: when hi type description = '1st mortgage' and other loan number is > 1 then i want to look up the first principle balance of…
Hi guys, I hope you are able to help me with the following situation. Example: Customer ID1 — Customer ID2 — Status — .. ABC — DEF — ACTIVE ABC — GHI — ACTIVE LMN — OPQ — ACTIVE LMN — RST — INACTIVE Basically I have two IDs per customer, I now want to get a COUNT of "active per customer" but ONLY when Status = ACTIVE. My…
Hi Domo, I have two columns: a date column (date datatype) and an hour column (0-23 integer type). What formula could I use to combine the two columns into a timestamp, assuming the minutes, and seconds are zero? Thanks,
Hi. I have data with Plants and Tasks and whether the tasks are complete are not. I need a formula so I can have a percent completed for each plant based on the number of Yes tasks they have compared to total tasks. Then I need to group by plant and bring that percent into a table. Could someone help with this? The…
I am using pfilters to drilldown on multiple columns. But the set date range isn't carrying when the link is clicked. How can I open an anchor link so the new page has the date range the first page had? CONCAT('<a href="https://domain.domo.com/page/1234567898?pfilters=' etc
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