-
Remove duplicate unknown comma separated values within a single 'cell'
Hello good people of Domo Very frustrated trying to remove duplicates WITHIN a comma seperated list. I have the following webform: If I 'Group By' (Magic ETL) by 'Who' & 'Manufacturer' (combining 'Model' & 'Colour' with commas) I get the below. This has repeats in R5:C3 (2x 'TT'), R6:C3 (2x V70) and 'Black' is repeated in…
-
Goal Met Percent
Hello all! I am trying to create a beast mode that shows a % for those that have met the goal. The goal does change month to month. There is a separate beast mode set up for those that have not met the goal/goal has been met. Thank you
-
Tab Functionality in Beastmode Editors Broken
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…
-
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…
-
Duplicate value handling in ETL
I have a column where there are around 34 values that are duplicated for one line that is supposed to be for two people. See picture for example. Ideally it'd be great to have one formula that can distinguish where the break would be so I don't have to manually create 34 lines of code, and have to continually add lines…
-
Date Columns is Returning Mixture of Date and Text Formats in the CSV Attachment in Scheduled Report
ISSUE: The date Columns is Returning Mixture of Date and Text Formats in the CSV Attachment in DOMO scheduled Reports. I need them in text format and the correct should be the (e.g. 11-14-2023 10:00:00). Some are appearing correctly but some are giving me in date format in the same column (see screenshot). Is this a known…
-
create a card to display a number ranking
can anyone point me in the right direction on how to create a card with a number ranking that will auto update? we give the sales people a score based on their activities. the one card will put them in order based off their activity score total. how do I create a separate card to just populate their Activity Score Rank?…
-
How can use Domos filter to remove response rates less than 15%?
Hello, I have a data set containing all response ever recorded for several different surveys. I would like to build a dashboard that allows the user to select a question and see the response rates for that question (accomplished this by creating a variable and using case statements). The backend > grouped rows by survey to…
-
Beast mode
How I can limit my percentage calculate to be capped at 100% only for those calculations where its exceeds 100%, if not then it should show the below 100% values?
-
Can you convert Date to Text in DOMO?
Trying to find online but could not. Main purpose is that when the csv attachment in schedule reports get sent, I want the report to have no "T" stamp. Current: 2023-11-27T00:00:00 Change to: 2023-11-27 00:00:00 If you guys have other alternatives, please let me know. Thank you.
-
Using Fixed Function with Filter None but don't want to use the By argument.
Hi, I have a SITE column. This column itself I have taken as a interactive filter. I want the total unique count of sites irrespective of what I chose in the filter. Don't want to use By because I want the overall count of sites. This is giving processing error when I am filtering out some sites. I am using something like…
-
Bucket Ordering
Hi, I am working with pricing buckets of home loans. I have created two case statements. One that puts each loan id into a piricing bucket based on the loan amount. the second is to order those buckets in what would be numerical order. I am getting a graph that, when the bucket order is being applied, doesnt want to bucket…
-
NUMBER_FORMAT function
Please consider the implementation of a NUMBER_FORMAT function in Beast Mode in the same vein that we have DATE_FORMAT and TIME_FORMAT. This would take a number, and based on parameters, format the number (add thousand separator commas, percent sign, currency sign). Numerous discussions have been had in the forums about…
-
How to Calculate Averages Across Two Different Columns
I'm trying to get the average duration of our phone calls and chats. For rows that have a Unique Call ID, we want to use Call Duration, for rows that have a Unique Chat ID, we want to use Chat Duration. There may be multiple records with the same Chat ID or Call ID, so I've been using FIXED BY to ensure we're using unique…
-
Aggregating Numeric Column in a Line Graph over time based on a Different String Column
Hello, this is a continuation of I was wondering how I can show in a line graph for the MAX,MIN, and AVG of a column that is fixed on a different column. More specifically, I want to find the MAX, MIN, and AVG of a 'Completion Percentage' column based on a 'Group_1' column; meaning that I want to show the maximum of the…
-
Window Function on Fixed Column Finding Aggregations of Previous Beast Mode
Hello, I was hoping to find a way to take the MAX, MIN, and AVG of a calculation based on a column in a beast mode calculation. For example, I am creating the "Average Performer" as something like the below query but I am getting an error thrown. AVG(AVG((SUM(COMPLETED) / SUM(EXPECTED))) FIXED (BY GROUP_1)) I was basing my…
-
How do I set up multiple case statement for required field?
I'm trying to create a case statement to replace an empty field with the word 'incomplete' when the field in the previous 'required' column has a 'yes' response. When it has a 'no' response, it should be left blank. Here is a snip of the dataset. This is what I've got so far, but I realize the 'if null' statement doesn't…
-
Is there a way to craft a variable to group by Month/Quarter/etc. and still display YoY data?
I'm currently trying to accomplish this, but it's not allowing me to select comparison data since the Beast Mode output isn't a date field.
-
Broken line chart and want to connect the dots
Hi - I have this beast mode that I am using in a bar line chart. However since there aren't values for each time interval the line is showing as dots. How do I get the line to connect? Here is the beast mode and I can't seem to get things connected without breaking syntax: CASE WHEN 'id'='LIABILITY' THEN SUM('value') END
-
Exclude current month from Card
Hello again, I am trying to create a beast mode that would update automatically, but exclude the current month. I know there is a filter for this but we want it to update automatically for our users
-
Is there a way to make a Summary display of a Beast Mode a color?
I have a beast mode calculation showing the percentage change that I am displaying as the Summary Number. Is there a way to color code the percentage where if it is positive, make the value green or if it is negative, then make it red?
-
Y/N Function
I have a month goal, how do i write a Beast mode that showcase if a month or date goal is met? Below is the code I am using to showcase the goals of each month
-
Month and Actual Goal
Hello all looking to make a case statement, I could be using the wrong one. I want to have a Beast mode that states when a specific month then it states what the goal is, picture below. Thank you in advance
-
Summary Color Display
I am displaying a Beast Mode calculation as the Summary number. The Beast Mode is the percentage change. Is there a way to color code the percentage where if it is positive, make the value green or if it is negative, then make it red?
-
Beast Mode: Syntax issues on filtering out a Sum Total
Hi - I am trying to remove certain IDs from a column then sum their values but can't get the syntax correct. Here is what I've gotten to but doesn't work. I can't add a filter on the card since the removed values need to be in another part on the chart. CASE SUM('values') - SUM(WHEN id='LIABILITY' THEN 'values') END
-
Beast mode to filter out certain ID field then sum the remaining IDs 'value'
Hi - I am trying to remove certain IDs from a column then sum their values but can't get the syntax correct. Here is what I've gotten to but doesn't work. Problem with adding a filter is the removed values need to be in another line on the chart. Case When sum('value') - (when ID='Liability' Then sum('value')) End or Case…
-
Adding Images to Table Card Using Beast Mode
Can someone help me with the formula to add a different image for each row in a table? I've been using the attached article. I've been able to get an image added, but the same image is in each row. I can't figure out how to get different images to populate in each row, like the sales rep image example in this article.
-
Include Data for a specific date range
Hello - newbie here - I need to know how to only include data that falls within my defined start and end dates columns. There are multiple flight dates, so I need to be able to bucket the daily delivery data within those defined dates. It just pulls in all of the data for each flight and I cannot seem to get it to work. I…
-
Beast Mode: How to aggregate a value for 1yr and remainder of the yr from a date?
Hi - I am trying to figure out how to aggregate values from a run date thru the end of the year as well as aggregating from that same date as_of_date for 1 year out. Essentially if the date is 5/31/23 it'll aggregate a value from that date through the end of the year (12/31/YY). Separately, from that same as of date…
-
Text box is not populated by Beast Mode
So, I have a beast mode that generates a text block with some basic information about a helpdesk ticket dataset. Its purpose is just to let the user know how recent the data they're seeing is. In short, it tells (1) when the ETL was last run, and (2) the most recent ticket ID and date. Simple enough, I'd think. If I add…