Ask Beast Mode questions and get answers from Domo peers
Hi, How would I create a beastmode at the card level that would specifically take a year vs. year comparison for each column of data (IL expl dollars, il expl qty, exp tp cost, etc.) Currently selecting transpose on this card. I'd like an additional column that calculates 2019 vs. 2020 change %. Thanks! Paul
UPDATE: I have this code, but it isn't doint what I need/want CASE WHEN MONTH(`Date`) = 1 THEN SUM(CASE WHEN MONTH(`Date`) = 2 THEN `Revenue` ELSE 0 END)END What I'm trying to do is say, Ok when the Date is January, grab Feb Revenue and Sum that I also tried this but it produced nothing: (CASE WHEN…
Hi, I wonder what the problem is with my formula. The end date is March 2024 and the start date is December 2023, but I'm getting 24291 as a result, while I was expecting 3. Based on the documentation period_diff will return the number of months between two periods. Is there anything I'm missing here. Thanks
I'm trying to create a dynamic Comparison Value that adjusts the view based on Time Period Selection. I was able to create a Gauge Value that works, but am struggle with the Beast Mode that would allow the end user to view vs same time year ago value. I have the code below and have tried various adjustments, but keep…
Hi, I was hoping to write a case statement that would allow me to highlight the month with the highest Volume. Additionally, I want to take data from that particular month and I want to graph it by Day. On the same graph I want to highlight the Volume for the current month as well. Ideally I would do this in a line chart.…
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…
Hi! I'm trying to pull data into a card where the data varies, but what I want always has the text 'thd' in it. I was fine until my stakeholder wanted us to change the data that is getting sent to a capitalized version, so now I have to account for both caps and not caps. Because all of the Event Labels contain a code, I…
Has anyone been able to create a beastmode rank that does not recalculate when filtering? I know I can create a static rank in the dataflow, which I have done, but I'd like to figure out a way to mimic a fixed rank in beast mode for those times when I have to do a ranking on the fly and don't have time to run the dataflows…
Hi, I'm trying to combine several row data that have a similar dimension. For instance, i want to aggregate all of the lists_name's into one row next to 2024 Collection - Launch #4. so turn this… into this…
Hello, Our company has created a Report Inventory Card, Data Catalog Card, and Data Glossary Card. These cards are together on 1 dashboard (dashboard ID: 1212036684) and we have a filter on the dashboard to filter based on any dashboard ID which will then show all reports on the desired dashboard and all the definitions…
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