-
Rank Function Skipping Rank Numbers
I'm creating a simple leaderboard which ranks my closers by the number of sales for the selected period and then by total system cost. For some reason, the function I'm using is causing the leaderboard to skip ranks and I'm having trouble figuring out why. Any thoughts?
-
Mapping "month" to "week" data
I have a dataset with sales report by week and year (e.g., Week = 1, Year = 2022) and want to be able to append a month value so we can look and filter by MTD data. Is there a way to 'calculate' a date either through beast mode or in ETL to map the month associated with the week of the year?
-
Beast Mode Not Working when a Value is ZERO
I have a Beast Mode that is not Calculating when one of the Values is ZERO. In this example Projected Cost Should be 21,192 based on the Beast Mode Equation but instead is returning a ZERO Value. BEAST MODE BELOW /Projected Actual Cost is equal to the Greater of Revised Estimated Cost or Job To Date Cost/ CASE WHEN…
-
Cumulative Total Measures
I am looking for help understanding how to do cumulative time intelligence calculations ( MTD, QTD, YTD ) in Domo. I have a dataset with customer reviews (review ID, date, source, Stars, comment ) and am trying to achieve a cumulative running total of the average star rating. I'm used to PowerBI where time intelligence…
-
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…
-
How can I convert an Excel date code into a normal M/D/Y formatted date?
Hi All, I have some data that I link to DOMO via the Google Analytics connector. It's provided by a 3rd party and contains dates in Excel codes in their 4** format. Is there a recommended Beast Mode or other way to fix the date formatting? Due to IT policy, I can't access google sheets to change it manually. Plus, I would…
-
Subtracting a "COUNT" result from a given value
I'm assuming I have this completely wrong. 1344 - COUNT(`Room/Row Id`) is what i'm trying to do. 1344 represents the total spaces available in a cooler unit. the COUNT equation is how many spaces are currently filled. The underlying math here is 1344-764=580, however i'm getting a result of 12,676.
-
Beastmode Case Statement with NOT IN operator
-
Pivot table, unable to hide months with no value.
I would like to list all the month actuals first, then month's budget numbers, etc.. (ie. Jan actuals, Feb, Actuals, March Actuals. then Jan Budget, Feb Budget, etc.) Unfortunately I do not see a way to do this without creating a separate column for each of the months. This solution however does not allow me to hide…
-
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…
-
Group By
Anyone knows of a way to GROUP BY in Beast Mode Editor? we can do PARTITIONING but somehow, we can't do GROUP BY? For example: case when 'location'='ATL' then sum((amount)*10) else sum(amount) over (partition by 'Location') end the above works perfect BUT below doesn't. what am I doing wrong here? case when…
-
GROUP BY
Anyone knows of a way to GROUP BY in Beast Mode Editor? we can do PARTITIONING but somehow, we can't do GROUP BY? For example: case when 'location'='ATL' then sum((amount)*10) else sum(amount) over (partition by 'Location') end the above works perfect BUT below doesn't. what am I doing wrong here? case when…
-
Grouping 'Last Connection Time' by month
Looking to create a Beast mode that will break MAX(`Verizon_Last_Connection_Date`) into chunks by quarter. Example below. I am able to validate the calculation, however it does not seem to work when I add this formula to the series. It just displays '1 month' and 'over year'. CASE WHEN DATEDIFF(CURRENT_DATE(),…
-
How do I reflect team member on Team A before date and Team B after date.
I have a team member that has moved teams on a specific date. I need this person to be still reflected in Team A prior to 8/1/23 and also on Team B on and after 8/1/23. All other team members will remain in their current team. Trying to use beast mode but getting an error. Any help would be appreciated. case when Date >=…
-
How do I use data in one column to replace data in a different column in Beast Mode?
I need to create a new column that pulls data in from one column but changes only certain cells to another value based on a value in the same row from a different column. This is what I have tried: CASE WHEN 'column A' = "xyz" THEN 'column B' 'abc' ELSE 'column B' END CASE WHEN 'column A' = "xyz" THEN 'column B'='abc' ELSE…
-
Application upgrade tracking
I am tracking an application update on devices. I have a dataset that looks something like this. I would like to: 1. Count # of devices that upgraded to the latest app (Column App1). Ex. is 1002 and 1004 that has 2 versions, I only need the latest which is in column App1. 2. Count # of devices with app1 and app2 3. Count…
-
Distinct Count of Donations and Distinct Count of Donors with those Distinct Count of Donations
Essentially we would want the distinct count of donations to by the buckets and the distinct count of donors to by the Y axis. But we want to be able to do it dynamically so that we can adjust date ranges on the card level to whatever we want. So I don't know that I could do this in ETL without pushing it through each…
-
Beast Mode
Hello All, I want to build a card comparing cy with py grouped by location. My plan is to use bar chart side by side comparing cy to py. My beast mode calculations seem correct when I create a table with them. When not comparing to PY, I just built a filter to include the dates i need, and it works fine but when comparing…
-
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…
-
how do you calculate the age (in months) using the date of birthday?
how do you calculate the age (in months) using the date of birthday? Can I use this: ROUND(DATEDIFF(INFANT'S DETAILS:\nDate of Birth,CURRENT_DATE()) / 365,1)*12
-
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.…
-
Creating a variance column
Hi there, I am new to Domo and I have a question that I believe has an easy solution, however, I cannot figure it out. I have a table created to display Cost per load over the past three months. The formula for CPL is SUM(carrier pay)/ SUM(Loads). I want to have a column that displays the previous months CPL - Current…
-
Parameter Filer
Hello everyone, I wonder if someone has successfully figured out how to create a parameter filter in DOMO. I want to create a filter that allows dashboard readers to choose which two years they want to compare (e.g. 2021 vs. 2019 or 2022 vs. 2024). Thank you very much. Best, Anna
-
Beast mode to only show matching creative types in grouped bar chart?
We are using a grouped bar chart to compare client and typical engagement rates by creative type (see 1st screen grab). The report is filtered by a SalesQuote field where client results have one value and typical results='Banner Average'. These are unique rows in the data set (see 2nd screen grab). There are six 'Banner…
-
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…
-
Hyperlink to Sharepoint
Hi, I want to create a hyperlink to a sharepoint file from my domo card. The hyperlink is working correctly to the sharepoint destination. I would like the user to be able to choose a record and be taken to the matching record using the link, the only field I have to utilize is 'Name'. I found a discussion with this…
-
CY vs PY and Multiline Chart
Hi All, I am trying to build a multiline chart that would have 2 Y-axis line chart. Y1 Axis to show Cumulative Line of YTD Sales vs PY to Date Sales and Y2 Axis to show YTD Average Sales vs PY to Date average sales. I have tried all the available line charts and seems not to be the one as per the picture attached. Also,…