Ask Beast Mode questions and get answers from Domo peers
Hi I am running into a unique issue where I have created 3 calculated fields called PCT AD Cost Dollars (SUM(AdCostDollars)/ SUM(SUM(AdCostDollars)) Over(PARTITION BY MarketingEffortYear) PCT Marketing Demand Dollars (SUM(MarketingDemandDollars)/ SUM(SUM(MarketingDemandDollars)) Over(PARTITION BY MarketingEffortYear)…
Hi there Im trying to create two filter date selection to see sale difference between two period selection. Is there any way to do this?
Hello, I have a dataset here where there are 4 time zones, EST, CST, MST, PST and the fields are this CST Created Date, MST Created Date, PST Created Date, Created Date Last one is EST by default. Example format: 2019-03-11 10:22:17 So, I have extracted the hour using HOUR (`MST Created Date`) and for others as well. But I…
Hi, I have a table that I would like to format so that anything over 0 is red and less is green. I have created the beast mode below but I am not sure how to amend it so that the result is a percentage that also creates a total in the total row rather than a count CASE WHEN (sum(Visits last week) -sum(Visits 2 weeks ago))/…
Hi gang! Happy Friday! I have two attributes with values from 1 to 9, then the SUM of the PlannedCost for each record determines a third value from 1 to 4. I then SUM these three numbers to get a "Project Score" Do you see anything wrong with this code to accomplish what I described above? ROUND(IFNULL(`Business Value…
I've started adding a hyperlink back to the records in my source system in table Cards with this: concat('<a href="https://abcdefghijklm.com/project/', `ProjectID`,'/Overview " target="_blank">',ProjectName,'</a>') Are there any other card types that it works in, and if so, is there a list somewhere of which? Thanks!
How do i do a beast mode formula to get the response value of a record that was completed most recently? If this is my data i want to just take the bottom row. My groupings cant be changed in magic etl just need to take response value with highest or most recent time Name Location Time Response value Ben A 2:07PM 5 John A…
I have a beast mode that is comparing actual performance to a target (by categories) by taking the sum of actuals - sum of targets over an arbitrary date range, defined by user input into variables on the dashboard page. This works great as a quick filter control for an individual card, but when I make a filter card using…
I need to calculate failure rates using two different date columns but the Fixed by calculation doesn't work for this. All calculations go by the date field selected on the chart, but I need a Beast Mode that ignores the default date on the chart. For instance, if I want to show units sold by Sales Date but also show units…
I am trying to find a way by which when a user view the Dashboard, then based on his/her PDP, s/he must see his/her own score and must see his/her Direct Reports entire span/ org score. I have attached a dummy data creating the scenario and along with it I have added Org Chart and the Views that is expected. Any help in…
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