-
Accounts with Profit Sharing Formula and Filter
Hello, We've got some customers that have profit sharing rules in place. As my data comes over it doesn't take this into account so it shows full profit attributed to us. I'd like to have a filter to toggle profit sharing on or off to show either full profit or the profit taking into account the sharing. If, for example, I…
-
Window Function KB article
Domo does not appear to have a KB article for window functions despite having one for (newer) Fixed Functions. It would be nice to have both. Additionally it would be ideal if the Functions list in Beast Mode editor included all the available functions including window functions or statistical functions (MEDIAN() ) once…
-
Adding Sort to Custom Values
Hi, I have a card that identifies days since last activity date: Days Since Last Activity Date: DATEDIFF(CURDATE(),Enrollment Initiative: Last Activity Date) And I made a bar chart with a custom range using this beast mode: CASE WHEN Days Since Last Activity<7 then '<7' WHEN Days Since Last Activity<30 THEN '7-30' WHEN…
-
Change Number format in dynamic concat statement
I have create a concat statement to dynamically highlight a certain metric. Essentially it changes as the time period and other categories change. The number is showing in the format in the above picture and I am hoping I could abbreviate in Billion or at least show the number in account format. I would really appreciate…
-
Help with creating just one single column containing different time frames
Hi, I want to create a column that states the time period. I essentially have a dataset that consists of data that is divided across quarter, month and year. For example I have data that displays revenue for the current month, revenue for the current year and revenue for the current day. I want to create column that uses…
-
Compare values in a series against overall average
Hi Domo community, I'm looking to create a card that shows which segments are bringing our Net Promoter Score (NPS) up or down. My idea for a visualization is below. The centre line is the monthly overall NPS and then the 4 bars (International, United States, Canada, and regional) are the series that show the different…
-
Beast Mode Approach to Eliminate Field Character
I have a data set of email addresses and i've used a beast mode calc to create a new field for the domains. RIGHT(Sent Email,((LENGTH(Sent Email))-(INSTR(Sent Email,'@')))) The issue I'm having is that some of the email values also include the bracketed name of the user so some of the results are coming back looking like…
-
RANK() in pivot table issues
Hi, I have a pivot table and I am trying to only show a top 10 based on a field and then bucket the rest into an "Others" group. My data contains monthly sales per country. My table is setup as follows. Rows: Country beastmode below Columns: Date Values: sum(sales) My beast mode for Country is case when RANK() OVER(ORDER…
-
Beast mode CASE calculation for number ranges that have null values in column.
I have a column that has data type numeric and has numeric values and around 5 blank values. I am trying to categorize the number to ranges 1-5, 5-10 and so on. The column has blank values as well. Well, when I am trying to implement the CASE calculation in beast mode, it throws me a calculation error. How do I correct…
-
BeastMode Manager Not Transferring Beast Modes
im tyring to transfer beatsmodes i made from a card to a new dataset and it say they've succesfully copied over but when i go to check they aren't there. Super frustrated. Im musing the beast mode manager.
-
I need to make a bar chart that combines multiple columns based on date
Simply put, I want to display how many users completed each program in Q4 2023, and I want to later be able to select a different date (so later, for example, I can see how many people completed programs in Q1 2024). I want my users to see the most popular progams during a given time period. I think a bar graph will…
-
YoY change beastmode at card level in table chart
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
-
30, 60, 90 Day Variance Calculation
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…
-
PERIOD_DIFF
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
-
Unable to Create Same Time vs Yr Ago
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…
-
Max Rank by Month and Year for Volume Metric
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.…
-
Caps and not caps in Beast Mode
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…
-
Static Rank beast mode
When creating multiple ranking tiles in ETL, the performance is significantly slowed and the dataflow takes hours to run, in comparison with less than 1 hour without ranking tiles. Therefore, I would like to be able to use beast modes to create static rankings. Currently, if you use the rank function in a beast mode, the…
-
Ranking beastmode with fixed rankings
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…
-
Create a pfilter to filter a Report Inventory on a different page
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…
-
Tab Autocomplete Messed Up
For years when pressing tab on the keyboard when in a DOMO code editor it has functioned like an auto complete or a tab space entry, however recently this functionality has broken. Tab no longer autocompletes nor does it allow to add quick spacing for code readability. Instead, it moves to the next element in the beastmode…
-
Create Bar Chart with Current Month Vs Previous Month?
Hello, I have a data set of invoices that I want to compare in a bar graph where one bar is March and the other bar is Feb. I think I can do this with a beast mode but I think my syntax is off. Case when Title LIKE '%OTT%' Then 'OTT' AND MONTH(Date) = CURRENT_DATE(MONTH(Date)) THEN 'Current Month' Case when Title LIKE…
-
Combining data in two separate columns
Can someone please help me learn how to combine data from two separate columns of a table? There are only two values in my pre-lease % summer 2024 column, and I need those two values to override/replace the values in the same row for the "pre-lease % 2024 column. I hope the attached screenshot helps.
-
Histogram Buckets Beast Mode
I have created 5 buckets and I am not sure why only the last bucket is showing on a bar chart. I can see more buckets in the underlying data. Any insight on this? For reference I am using a case statement to create my buckets. Something like this. CASE WHEN (SUM(min(1)) over (partition by cat1,cat2 order by sum(value)…
-
Aggregating Data for a Beastmode - Counting Survival Analysis
Hi there -- I have a dataset that has an individual record per employee that states if they are active or terminated and that gives their current tenure or the tenure at the time that they left the company. I'm trying to do a survival beastmode using a bar chart where I show 100% at tenure = 0, and then at tenure = 1, I…
-
Keep beast mode field calculated on total value when filtered
I am creating a beast mode filters which shows me the percentage of the total units by person but when I filter out people the percentage changes to only calculate on the current people in the filter. Is there a way to keep the original numbers and show those on the card while filtering?
-
Average Session Duration Y/Y
I am importing GA4 data and trying to display Y/Y in a multivalue on a dashboard. I used SEC_TO_TIME(Avg. Session Duration) to change the data to time format, but it's still not showing appropriately. Any ideas?
-
How to show a unique count for a different period than the selected date range?
Hi All, I have a card where I am showing a year to date breakdown of assets, in order to show this I have 'This Year' selected for my date range. However ideally I want to show a count of unique accounts as at the end of the prior year, a count of unique accounts as at the end of the current month and the difference…
-
Beastmode to decide how much to spend per ad in a given category
We have a working beastmode that calculates what ‘n’ should be depending on spend, revenue, and page depth (page depth is in 3 categories – all pages, product, and shopping cart). Here is the formula: = 1 / ((spend / revenue) / (sum (all spend per category)/ sum (all revenue per category))) Note that the category of all…
-
30 Day Interval
Hello! I am looking to create a beastmode that sums video views and revenue separately in the 30-days after the asset is published. While the beastmode is validating and looks to be calculating accurately, the QA is very off. In the screenshot example, I manually filtered the time frame for 30-days after the published date…