-
Filter by Section of Dataset (Bonus point question!)
Hi Everyone, this is a bit tricky. There is a need to have an aggregate table that shows counts, sums, and averages for different sections of the same data set. But subsets of these sections are defined by matching filters on the dashboard. I know that doesn't make much sense, so here is an example of a simple table.…
-
Case when SYNTAX
Hi all, I am trying to write a case statement for a column when we see a null to grab another column. I am not sure why I am not getting the output expected. Can someone take a look and maybe advise? Essentially 36534370 and 36534369 from the investor_loan_id column should be in the left column as well. **I've tried to…
-
Unable to save card with Beastmode active
I have a beast mode that validates and appears to work as intended. However, when I try to save it as an active filter, I get the "There was a problem saving your card…Contact Domo Support." If I move the remove the beast mode from the filter list I can save the card. The beast mode is: CASE WHEN (RANK() OVER (PARTITION BY…
-
Average Length of Stay in Beastmode
I am trying to get the average length of stay using our admission date till our discharge date. I tried using the datediff function and got an error when validating, "Calculation error: whoops! something went wrong." I have flipped the discharge date and the admission date and the same error comes up. I feel like I am…
-
Looking on a specific date
Hi all, I am working in Magic ETL. I have group two different datasets on their 'lock_dates' I have created a calculated column where the number of locks are counted in each data set. Then I created a column that told me if dataset 1 matched dataset 2. All of this is shown below The issue I am running into is seeing that…
-
Date Picker & Period Over Period Chart Enhancements
We have end users who want to set a date range and see the change compared to the corresponding previous period. Currently, in PoP cards, you can: Set a comparison period on the cards that overrides the dashboard date picker OR Use variables and Beast Modes to create current and previous period calculations and add the…
-
Beastmode Case Statement with NOT IN operator
-
locks = locks?
Hi all, (I recently posted something similar but updated my dataflow to a new output so wanted to share and clarify) I've got two columns, rate_locks_powerlender and rate_locks_powerseller, that I need make sure are equal to each other. The power lender is slower to update so we do not have data later than 9/11 so I am…
-
True/False Beast Mode Syntax
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 entries are the same in each data set. I can visually tell that they are the same but I am trying to write a beast mode to…
-
How to reference a Beast Mode in antother Beast Mode
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 invert these in Domo, and I have a simple beast mode which does that (1=10, 2=9, 3=8, etc.). I now need to reference that…
-
Calculating MoM, YoY, YTD in table
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 cable that I want to replicate in Domo. For the most part I can do this in a pivot table in Domo, however I am not sure how to…
-
Formatting Summary Number For A Calculation
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 still struggling to control the format to be a currency without decimals instead of the number its at now Right now, I've…
-
Sorting Beast mode
Hello! I'm trying to sort my beast mode where I'm normalizing my data to trend performance by the first month it's published and trending for a year since all my rows of data will have different dates in which they are published. The issue I'm running into is I can't sort the beast mode in order of Month 1, Month 2, etc.…
-
Add REGEX functions to Beast Mode
REGEX functions are currently supported in the MagicETL formula tiles, but not in beast mode. It would be helpful to have these added to Beast Mode.
-
Possible to use a value that ignores filters?
I'm looking for a way to use a value in a beast mode formula that ignores my current filters. I've been wrapping my head around this problem and can't think of another way to solve it. Here is an example with my issue: Let's say my company has 5000 employees. There is a survey database with multiple rows of data for each…
-
Last 13 Months Using Selected Date Slicers
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?
-
How would I get a percent change for each t value from baseline and chart it as a bar line graph
/* 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 Get %change between baseline and followup scores for each summary order ((avg_followup - avg_baseline) / avg_baseline) * 100…
-
Month Over Month % Change of Total Number
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 month it gets updated and changing things around. I was able to get the most recently updated month and the prior month totals…
-
Help with a complex calculation that isn't working in Beast Mode.
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 set / number of contacts). The appointment conversion ratio / average gets the performance multiplier. 1 being average, 2…
-
How to get an avg in the grand total of a column with a BM with sum?
Hi, Im trying to use this BM CASE WHEN MONTH(Cycle)='10' THEN (sum($ New Annual Salary(in USD))/ sum($ Annual Salary(in USD)))-1 ELSE sum($ New Annual Salary(custom)(in USD))/ sum($ Annual Salary(in USD))-1 end and its sucessful but in the Grand Total I requiered an average not a sum, and usually I can use the agregation…
-
Beast Mode Formula error
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 SEG PMPK CAGR Start Period AND SEG PMKA CAGR End Period THEN Instrument Qty END))/(SUM(CASE WHEN Parts Kits Fiscal Year=SEG…
-
This is coming out to be a date format beast mode. How can i change this to integer?
(((DATE - Lag(DATE,1) over (partition by ID,FAMILY order by INVOICE))))
-
Group By Condition in beast mode
It would be nice to have a "Group by" condition in beast mode
-
Sortable Link
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="_blank">',`Title`,'</a>') UseCONCAT('<a title="', `Title`,'" href="', `Card Link`, '" target="_blank">',`Title`,'</a>')…
-
How do I get the following aggregation setup in domo?
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 aggregations I want in the same sheet (i.e. the user should be able to add/remove the columns on their own and see those…
-
Greater than current date
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'. The logic for Digitisation needs to be 'if Contractor completion is greater than or equal to CurrentDate then…
-
Is there anything wrong with this calculation?
((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 points in the dataset
-
beast mode using rank function
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 problem persists, contact the Domo support team." RANK() OVER (PARTITION BY first_day_of_month ORDER BY COUNT(DISTINCT user_id)…
-
Want to add minutes of a particular day from different rows
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?