-
First Word Grouping
I've been having trouble getting Domo to group by the first word. Is this possible or would a Beast Mode Segment be necessary? Example: System | Application | Client | Problem I am open to using Magic ETL or a Beast Mode segment if someone has an idea! Thanks!
-
Most recent event, multiple columns
Hi all. Appreciate all the help in the past. I am trying to get to show on a card the last/most current status of a shipment. I have the columns below. The port columns A,B,C are connected to one source and D,E,F,G are pulling from another source, but are joined into one sheet in Domo. What I am trying to do is find the…
-
search and replace
Is there an equivalent to search and replace in ETL? i have a data set that I need to change the word 'Not' to something else - the problem is i only want to change that word and only that word. Any suggestions?
-
How to use a beastmode to divide X from the same time period between 2 years.
Hello, I have an 'hours' worked column broken out by work date in my dataset. I'd like to be able to sum the hours worked so far this year, and divide them by the sum of hours in the same time period last year. For example, summing the hours from Jan 1st, 2023 - Current Day and dividing it by the sum of the hours from Jan…
-
Nested Case Statement
I'm trying to count travel records that are completed and then put them into tiers. · 0-34 Tier 1 35-70 Tier 2 71-110 Tier 3 111+ Tier 4 I keep getting an error using the beast mode below CASE WHEN SUM(CASE WHEN `Status__c` = 'Booked' THEN 'Completed' ELSE `Status__c`END) > 35 THEN 'TIER 2' WHEN SUM(CASE WHEN `Status__c` =…
-
How to create a date field beastmode in Analyzer using 2 different date fields.
I am trying to use different parts of 2 different date fields to make a new date field called Calendar_shipDT. Schedule_shipDt is some time in the future, and Potential_shipDT is any potential ship date, past or present. I just need the WEEKDAY (1-7) from the Potential_shipDT. Say that day of the week is Wednesday…
-
Hi, I wish to find top 5 sales representative in large dataset.
A sample dataset attached with one sales rep with different metrics.
-
Identify a duplicate
Is there a way to create a column that can help identify a duplicate from another column? Below is a list of loan ids that we have and some of them have coborrowers but some dont. I dont need to remove the duplicates but I would like to create a new column that can identify quickly which one is a coborrower. Is there a…
-
Add a Year to a Date and return the new Year
Hi, I am trying to return the year after a specific date, I tried the below but it is not returning what I anticipated WHEN MONTH(`hireDate`)>=2 AND MONTH(`hireDate`)<=4 THEN CONCAT(YEAR(ADDDATE(`hireDate`,INTERVAL 1 Year)),' - Q1') For example, if the hireDate was 02/01/2023, the return should be '2024 - Q1'
-
How to do a running sum of count from current month backwards with consecutive months
I am trying to make a beast mode calc where I calculate if there's a count in the current month, it's a 1, and if there isn't, it's a 0. However many months it goes back consecutively it will add to the total count. I.E. if there's a count (or sale) in Feb, Jan, Dec then that will be a count of 3. Currently I am trying to…
-
Get Top 5 category values for each date from category
I have a column "category" which has more than 10 categories for each date. I would want to see only the Top 5 category for each date. Can I get a beast mode or a work around for the same. I have attached an image for reference.
-
Fixed filter allow : multiple allow
Hello, maybe it’s me, but I don’t seem able to specify multiple dimension in the filter allow or filter deny using the fixed function ? When I try it, only the first column is used, not the other. ex : sum(sum(count) fixed (by ‘name’ filter allow ´date’, ´region’)) ’date’ will work but not ´region’
-
Help with Beast mode for getting the distinct count by order number for This year and last year
Hi All, Hope you are doing well!.. I am trying to get the count of distinct combination of ordno and partno by ordate ..Please find the input table below: The output table that I am trying to get to is Can you please help me with the beast mode for this..Also attached the excel file... Thanks, Arun
-
How to display column value in Smart Text without selecting filter value?
I have setup a dataflow which adds last updated date/s columns to a dataset because preceding dataflows run daily even though the true data update frequency is monthly or less. I would like to show the value in this column in a smart text filter but the value will only appear where the smart text is inserted when the…
-
Calculate % of Repeat Customersvia Beast Mode
Trying to help co-worker with a beast mode... and first not sure if this is possible at the card level (maybe better handled with a dataset view). Here's the business question: How many of our eCommerce customers are repeat customers? Displayed at a % of total eCommerce customer count. Example: 25 of 100 customers are…
-
Can someone help with a simple join?
This is a super simple problem, not sure what is going on but I am hoping a fresh set of eyes might help. All I am trying to do is take the 'property_address' column from the powerlender table and use that information onto the foreclosure table - foreclosure is otherwise all ready to go. Both tables have a loan_id (one is…
-
How to use Rank System in Beast Mode
Hi, Any one please asset me. How to use Rank System in Beast Mode.
-
I'm trying to figure out a beast mode for a card for points?
For total points, we have to drop a zero. 500 points = $50.00, 50 points = $5.00, 2,550 points = $255.00. Anyone have any ideas?
-
Formatting Fiscal Year and Quarter columns
I am trying to format a column that labels 'FY23' and 'Q1' based on a Period date. What would be the formula to create this? I know Quarter() and Year() functions work but how would I use those functions to format it in the way I need to see it? Thanks
-
I'm looking to write a Beast Mode to extract hashtag strings from social media posts
Hello, I want to write a beast mode to use as a card filter to filter by hashtag strings in posts. Can you write a beast mode to extract all the strings following the # symbol? "Mmmm #yummy #donut at #CZ" I want to filter the card by every post that contains either yummy, donut, or cz. Thanks!
-
ETL Calculation
Hello, I have SO dataset and want to create a calculated field that would show the sum of the items within an order. To give an example, I have an order that has 5 rows of information (5 different items), I want to create another field that would sum up the cost of the items and create another field that would show the…
-
How to calculate best?
Hi all, I am pretty new to DOMO and would like to know if there is a hack/tip how I can best calculate data? Currently I do have an excel-file with many many formulas and was wondering if I can "rebuild" them in Analyzer or better ETL? Concrete example: There is one column filled with values between 1 and 10. I now want to…
-
Newbie23
Hello, I am new to DOMO and I am learning it as I work on this project. I am trying to combine two datasets to calculate monthly supplier performance: qty rejected divided by qty received. I have dataset A, qty rejected, with tons of data. I did some calculations and was able to chart the defects of each supplier by month,…
-
Multiple Case statements
Hi there, I am trying to make a table that has the following columns. Customer Name / AW 2022 Pre-Orders / AW 2022 Replen Orders / AW 2023 Pre-Orders So what i need is a beast mode formula that can get me data based off the 'Invoiced Month' of 10, 11, 12. The 'Invoiced Year' of 2022 and 2023. And finally the 'Sales Order…
-
How to aggregate a case statement that uses a fixed function
Hello, I was hoping somebody could help me understand how to sum the following case statement. case when `Date` = max(max(`Date`)) fixed () then `On Hand by Day - DO NOT SUM` else 0 end I need the calculation to be dynamic and reference the date selected on the card. All attempts to aggregate the case statement fail and…
-
Sum Orders, Line Count, Sales by day of the week (Friday, Saturday, and Sunday)
Hello, my dataset has 7 columns: Invoice date, location, orders, ... invoice total (see screenshot); I want to sum orders, line count, and sales by day; meaning January 21 2023 Friday's orders =DC 12 ATL's orders + DC 11 MOB's order = 65+0. Friday's sales = DC 12's Invoiced total + DC 11's invoiced total = $10,932.39 + 0.…
-
Highlight alternating sections of rows on a table (to differentiate based on a single column)
I have a table with a lot of data to show the page history of different users (sorted chronologically by User Pseudo ID). Is there a way to highlight every other section of rows associated with each User Pseudo ID? So the user can easily see each user's page history? So in the screenshot below... the first row would be…
-
Using beast mode to determine att rate
I'm trying what seems like it should be a simple calculation, but I'm getting either an illogical result or an error. Scenario: If opportunity has services sold(ie >0), then calculate the % by dividing sold svcs by total deal amnt. In the table below, it would be 1250/2510, not 1250/5045 CASE WHEN SERVICES >0 THEN…
-
calculating dates
I'm trying to build a beast mode field that does the following... When the date_created is great than 131 and the last payment date is between 55 and 86 days, then we are in month 3
-
Dynamic Rank Beast Mode
Does this functionality exist yet? When I try to do a rank() in a beast mode it skips from 1 to 16 every time no matter how I adjust my order by or partition, the only way rank() seems to work correctly is in the ETL itself, however I want to be able to filter the dataset and have the data rank accordingly by the filters.…