-
Creating a date range in Beast Mode
Hi Community So I have 6 months data, which i need to present in weekly using bar graph. When i do so its giving me as Week 1, Week 2 ..etc , but we need with a date range like from 1 Jan to 7 Jan Can anyone please help me to create a beast mode to fix this issue
-
Multi-Value Card - Revenue and YOY % Change
Hello Community, I need help creating a multi-value card in Domo to show total revenue and year-over-year percentage change based on filter selection. The requirements are: Yearly Comparison: If for example FY25 is selected, show FY25 revenue and compare it with FY24. Similarly, for other fiscal years. Monthly Comparison:…
-
Filter to show blank cells?
Hey! I am looking to filter data to show columns that have empty cells. For example showing all results where 'Planning Condition Status' is blank. I had a look at doing a Beast mode formula but wasn't sure how to put 'Blank' in the formula? Is there an easier way for me to do this? Thankyou in advance.
-
Tagging Customers on Services
Hi Community, excited to see what you think up! BLUF: How can I analyze what nurse saw a patient prior to a surgery or a non-surgery? See my simplified dataset below. My hope is to be able to see which nurses saw which patients/customers that led to a surgery (or not). My current thought is a CASE WHEN to create a label…
-
Fixed Function At Two Levels (Or nested Fixed Function)
I have a data set that includes duplicate rows for products. I'm using a fixed function to de-dupe an aggregate sum of product prices because I only want one product row to contribute to the total. The fixed function (total_product_price) looks like this: SUM(DISTINCT Price) FIXED (BY Product ID) However, now I need to…
-
Help with column formula
I am trying to do an a calculation and having some trouble. The formula in my Average Daily Usage column is (Oil Usage / Run TIme Hours) * 24 I guess the formula is technically working when look at columns, but I want this formula to calculate for the subtotal columns when i select a range of dates. So the column in blue…
-
Compare to Budget - Actuals in one Dataset and Budget Values in second Dataset
Hi community, BLUF: How can I compare budget to actual? We have data in one system that holds our actual sales amounts. We have data in a separate system that holds the budgeted sales amounts. I want to show the actuals and the budgeted in the same card. This seems easy enough in theory, but I've been struggling to…
-
bar graphs incorrect visuals
Hi, I am experiencing an issue with Grouped bar graphs. The x-axis is duplicated with the items, despite the data is seen correctly on Data Table (inside analyzer) and also when put on a HTML Table. Using beast mode calc for values. The category column is straight from the dataset.
-
Calculating max of a category using FIXED
If I have the first three columns of the data(model, variant names and total clicks) is it possible to generate a calculated field which shows the highest click value in a given Model? For example, Model A has 3 variants and the highest amount of clicks among the 3 variants is 33, so the 'Max clicks' column should be…
-
Formula to just take number from column
I have a column with different assets Tank 1 Engine 1 Engine 2 Tank 2 Tank 3 Engine 4 My question is I just want to take out the number from each and put in new column so can sort by just the number in each asset. Can someone help with this?
-
Need help with CASE statement in beast mode.
I'm getting this error on a pivot table card. The grand totals are correct but I need to see them by data source (Row) Here's the beast mode I'm using: CASE WHEN `Product` != 'SEM' THEN SUM(IFNULL(`Impressions`, 0) / 1000 * IFNULL(`Monday.CPM`, 0)) ELSE SUM(IFNULL(`Cost`, 0) + IFNULL(`Cost` * `SEM Fee`, 0)) END I've also…
-
multiple Groups shown in just one column
Hello DOMO - Good Day! I am using the Data governance dataset that has the users and groups. what we wanted to show is the pages/dashboard and then all the groups that can view it. currently, I can show the different pages and the different groups in different columns. just wanted to know if we can show all the different…
-
Variable names in String
Hi, The current variable selector accepts the values either in Default (Numeric) - Gives a comma separator automatically. Percentage Currency - Adds $ as prefix. Do we have any work around to avoid comma? Do we have any work around to use other currency symbols as prefix with currency format?
-
Calling all Windowed Beast Mode and FIXED Function experts!
I think I'm close on this but am struggling to get my expected result. Here is my end goal—a chart showing data by date, with a line for the "Best Ever" value. Things making it tricky: I need the date range to be dynamic, i.e. user can select different dates I need the "best ever" value to be pulled from across the entire…
-
Calculation of previous dated values
I am trying to calculate trailing period (previous period) calc. I have year(variable selector), month(dropdown selector chart using column from table) If i select Year = 2024 and Month = Feb, I should get the data for 2024-JAN. Tried this formula but failing to get the correct figure. RecordDate(date format col) is…
-
Multi value comparison
Hi, I am configuring a multi value comparison card. I have Sales column which is being configured in Gauge Value. In Comparison Value, I want to input the value of Sales Column itself but of previous year. I want this comparison to be dynamic because on my dashboard I have dropdown filter (Year, Month, Quarter). So if I…
-
Dynamic data comparison
Hi, I want to perform QTD, YTD without using Domo inbuilt features dynamically. Like, I will have a dropdown for Year using dropdown chart using the Year column from dataset. And variable selector for QTD, YTD. User may select any of the variable selector and any one year from the dropdown. Example: Variable Selector : QTD…
-
Median Value in Total Column
Hey all I'm creating a heatmap visual that compares our engineers' ticket cycle time against projects and uses the median value. When I add a total column to the graphic, the column sums the values above instead of calculating the median across all projects. Can the visual be adjusted to calculate an overall "Median"? ref:…
-
Display state selected
Hi, I have a map card which has the values populated for all states. I would like to display the selected state name in a text box. However, I noticed, when no state is selected, the text box displays the state name which is in the first row of the data which is misleading. It should either be blank or print some message.…
-
Reset filters on action or event
Hi, Can we implement a Reset all filters(global & custom) whenever user selects OptionB from OptionA in the variable selector? Variable selector values: Option A, Option B. Global Filters: Geo, Region, Type, Mode. Thanks in advance :)
-
FIXED Function Documentation: FIXED Add Label?
In the kb article for FIXED functions, an example for FIXED ADD is shown where the City dimension is added in the calculation. This is straightforward, but what I can't figure out is: how on earth is the user displaying the name of the city on the chart? Obviously the function will return the value: MAX(SUM(`Total Sales`)…
-
Calculate Sale Frequency
Attached below Sample data. The database table has location and sale date fields. I need to calculate Sale frequency report, which mentions if a particular location has a Weekly sale, bi-weekly or monthly sale wrt to the Sale date. Appreciate your help on how to calculate this in Domo? Thank you
-
Control Chart Type via Beast Mode
With the recent enhancement around beast modes that allows a beast mode within a beast mode it has become easier than ever to utilize variables to control x-axis, y-axis, sorting, filtering, etc. through beast modes. With that limitation out of the way I believe the next logical enhancement would be to add a Chart Type…
-
SUM('Revenue') BUT IGNORE ALL FILTERS PLEASE!!!
Hi all About to through my Mac through the window if I can't sort this. How do I write a Beast Mode that sums data whilst ignoring ALL filters? Many thanks
-
Beast mode for the substring_index
I'm trying to extract the substring from an URL. URL: www.ab.com/level1/level2 I'm looking taking the level2 out of URL. What is the beast mode formula I can use here? I want to get: level2
-
Calculating Percent of Total, and Getting Correct Totals
I have this table where I'm using count(distinct()) to get counts of various attributes, but when I add a "Percent of total" column to each one, the percentages add up to more than 100%. In addition, my totals at the bottom of the counts are incorrect. I've attached a screenshot of the issue along with an example of the…
-
Beastmode field not aggregating in bar chart
I have a dataset containing the following data: The Sessions field is a beastmode calculating the rank of the customers phone number. (Running total of how many transactions they have) rank() over (partition by Location.ID, PhoneNo order by TransactionDate) I am wanting to create a horizontal bar chart with the number of…
-
Beast mode calculation: Last compared to past average?
Hi - I'm trying to figure out the calculation to identify an action needed. I know how to do in Excel, but still learning the SQL / Beast Mode equivalent. I have a count of total items. If the count of total items from last week is 20% less than the average count of total items from the past 6 weeks, I want it to be marked…
-
Division By Zero - Be Aware - Failed IFERROR, IFNULL, and GROUPBY
When you're performing calculations over 100s of millions or records sometimes you come across division by zeros in which you're hoping the software you're using would manage accordingly, I ran into a scenario in an ETL scenario where it lead to having more than a 10% revenue shortfall in my numbers. Generally in Domo if…
-
Does Beast Mode support using "Contains" to Identify Value Count
Hey there… I have a field called PresentationName where we (unfortunately) use a text string as part of the PresentationName to identify a Type of presentation. Clearly we need to pull that out into its own metadata and will in the future. But for now, I need to find a way to create a calculated field that lets me get a…