
Community Forums
Discover best practices and find answers to your questions with advice from fellow Domo users.
Beast Mode
Discussion List
- Hi All, I am currently working with two joined datasets. Each dataset has a date for each row that gets added. I have outer joined those datasets and am now trying to make sure that the number of date…
- I've seen this in Ideas Exchange, and it sounds like it's coming, but it's not here yet? What's my alternative for now? In my database, I have an attribute that contains values from 1 to 10. I need to…
- Hi Domo users, I have been trying to figure out how to represent some values in a revenue table and hoping you can help. Here is what I have so far: As you can see above, I have something like this ca…
- Hello All, I'm struggling here as I feel like I'm so close. I'm trying to show a summary number that is a calculation (Cost/Leads) and while I've been able to figure out the font size and color, I am …
- Is there a way to pull the last 13 months for a visualization using a selected date in the dashboard? For example, if I filter for 12/2022 it gives me 12/2021 through 12/2022 in bars?
- /* Get RCI avg of all scores that aren't baseline CASE WHEN `summary_order_rule` > 1 THEN AVG(`RCI`) Get RCI avg of all scroes that are baseline CASE WHEN `summary_order_rule` = 1 THEN AVG(`RCI`) END …
- I have revenue figures recorded at random intervals of days throughout months. It has not been updated since June, so I cannot use the automatic date filters in Domo without manually going in every mo…
- I am trying to calculate a comparison of an individual's performance compared to the established average. This is for setting appointments. The appointment conversion ratio is found by (appointments s…
- Could you please help me identify an error in my formula: POWER((SUM(CASE WHEN Parts Kits Fiscal Year=SEG PMKA CAGR End Period THEN Parts Kits Qty END) / SUM(CASE WHEN Instrument Fiscal Year BETWEEN S…
- (((DATE - Lag(DATE,1) over (partition by ID,FAMILY order by INVOICE))))
- It would be nice to have a "Group by" condition in beast mode
- We know how to add a link field to a table, using: Here is a way to get it to be sortable… Insert a throw-away attribute to the left of the link. instead of CONCAT('<a href="', `Card Link`, '" target=…
- I have a dataset as follows: and I want the aggregations as shown below (number sum is just the sum aggregation of column 'number' the first table is the actual data and the next three tables are the …
- Hi, I'm working on a beast mode that groups sites into four buckets (Digitisation, Acquisition, Portfolio, Buy Out'. The last 3 are working fine and I just need to setup the formula for 'Digitisation'…
- ((case when Date = '2023-03-01' then sum (test1) end ) - (case when Date='2022-03-01' then sum(test2)end)) / (case when Date='2022-03-01' then sum(test2)end) Trying to calculate the %chg between two p…
- I have created a beast mode using rank() and using it to filter a chart. It is able to process the desired chart. But while saving the card domo says "There was a problem saving your card. If the prob…
- I want the sum of downtime in minutes for a particular day. Eg: 14th May had a total downtime of 33 minutes. I want to have a single row for 14th May with downtime 33 minutes. How can this be done?
- I am trying to create a line chart and graph it by Quarters but the only thing is that instead of summing the values or taking their average, i want to only take values for the last month of the quart…
- We are trying to find a viable way to be able to enter a variable (zip code) and locate all records that are within a given radius distance of the zip code. This requires trig functions as well as var…
- Hello, I am trying to do simple addition, multiplication, and division equations using static variables or numbers in Domo. What is the best and easiest way to go about doing this? Using variables giv…
- Im trying to move some of our reporting we do onto Domo. One of the things we do is build scenarios and need to compare them to what's happening currently. In excel we have this so the top table shows…
- Hello everyone, I am trying to come up with a table that shows the unique emails of subscribers, and to which partners they're subscribed to. I'm trying to concatenate the partner field so that those …
- Hi Team, I have a column which is has string values. This column has data related to months and years. Example : Jan-23. The problem is when i am using this column in the chart, its not detected as a …
- I have a dataset with item names. These item names have a preassigned "price" to them that is not in the source data (although I know what they should be). What has happened is that some people (not a…
- I want to make a pie chart out of the following rows where a row value is based off the count (not just 1). The rows are grouped by time. The table looks like the one below. The problem is the chart d…
- Relevant columns in dataset user_id: unique identifier badge_level: a number from 1 - 4 user_badge_id: another unique identifier. Each badge earned generates a unique id I am trying to create a new co…
Welcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In