-
Beast Mode Filter
Hello All, I have these 2 Beast Mode calc and I am trying to understand why it is not filtering from. (2022-01-01) to (today). What am I missing here please? And with this below too why am I getting error. Any help please? I just want to filter dates from start of previous year to today of last year. 2022-01-01 to same day…
-
Issue with null data
I am using the below beast modes calculations for a chart. where I am trying to find the no of records received today and yesterday. Data appends itself in the dataset date wise. Eg: if yesterday 1 record received, today 2 records received. dataset will show 3 count for today. Beastmode: today: case WHEN SUM(CASE WHEN…
-
Exclude from List
Hi, Simple question. I am trying to exclude values that contain a certain word in the beginning of the string. How would I write that as a beastmode? I know I could write a lengthy case statement saying Case where Bill_To <> 'Location A' then 'Include, Where bill_to <> Location B then Include, Etc…
-
String to date
I am trying to convert a text column to a date but my beast mode is not working, I am trying to add a formula in my etl to convert it
-
How to Capture Previous Month Data After on the 1st of Following Month
I am looking for assistance to create the correct beast mode calculation based on the following: Your assistance is greatly appreciated!
-
Month Order on Bar Chart
Has anyone ever had issue with months not being in right order on X axis in bar chart? I created a custom formula just so I could Order in my card but for some reason March is showing after November on X axis. When I look at datamart all March records have a 3 so dont understand why March is out of order. Any thoughts…
-
How to create calculated items (Not calculated field) in pivot table dashboard
Hi All, In excel, in pivot table we can create new row with the help of Calculated item option. Is it possible in Domo in Similar way or any formula to create new row in pivot table dashboard?. Attached Excel file for your reference. If anyone help me with screenshots, I will be more happy. Thank you so much.
-
Can I use variable and beast mode to change number of rows in a bar chart?
I’m trying to create a bar chart that shows actual fee vs estimate fee by role and I need the # of roles to change depending on the variable I’ve chosen (Either ‘Show Top 20’ or ‘Show All’) so I want to create a beast mode that would give me something like: Case When Variable= ‘Show Top 20’ then give me 20 roles only When…
-
Beastmode filter to show when data exists in both datasets
Hi, I am trying to create a beast mode where if a campaign name matches in both Dataset A and Dataset B, then name the filter 'Match Campaign Name' and everything else 'Doesn't Match Campaign Name'.
-
Issue with the logic in beast mode calculation
Hi, We are facing an issue with the domo beast mode calculation logic. Below is the problem along with the logic - If the values of column A,B,C,D,E, Quantities, part no 1, part no 2 are same and the count of value for these columns (A-part no 1, A_part no 2, M_part no 1, M_part no 2, E_part no 1, E part no2) is greater…
-
Change email format for a join
I am trying to merge two sources in domo. I want the last part of email to be all lowercase. In one source some of the emails are name@TechCompany. I want everything after the @ to be techcompany and all lowercase. What formula can I use for this?
-
Sum of Specific Expense Type
I have 5 different Expense Category and want to bring the sum of a specific expense category. What should be the formula
-
Help
Hello, I need some help. I made a few calculations in beast mode (Avg Bill Rate, Avg payRate, markup)that I need to use for reporting. Here's how I want my report to look like. How do I create create this metric list ? Kindly help. Category Metric Jan Feb Mar …Dec Total Category-1 Avg bill rate Avg pay rate Markup…
-
Beast Mode as Chart Label
Hello! I am using the filled gauge chart and was wondering if you could use a beast mode for a label. I am wanting to show if the the target value has been met or not. So it will say either "On Track" and if it hasn't been met it says "Behind Target." I used a case statement to capture that in a beast mode, but don't know…
-
Booking date and shipment date formula
Hello I am trying to arrive at a beast mode calculation where the booking in current quarter if shipped in the current quarter then give me the shipment dollars. It has to be dynamic so that I don't have to change the formula every quarter.
-
Beast Mode Nested
I remember asking about the Nested Beast Modes a little while ago and gladly I read it was part of the new updates on 10/22 DOMO added. How do I make it available in DOMO now please as an admin? thanks
-
Beast Mode To Find Cumulative Progress Towards a Goal
Hello, I am currently using a filled gauge and I need to create a beast mode that takes the number of days in a month(needs to account for all 12 months) / days total of the month and multiply it by the goal of the month, which will always be 3. Any help appreciated, I have not been able to get my head around what this may…
-
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…
-
Execution order of AND/OR in case when statement
Hi everyone, I am really confused about what is the order of executing AND/OR in case when statement and whether brackets work. For example, what I want to achieve is: (A AND B ) OR (A AND C) which means that I will select rows that can satisfy either AB or AC conditions. (1) Question 1: Does brackets work if I have a case…
-
Beastmode to get first week of month
Hi, I am currently trying to get a field that displays the value for the first week of the month. Currently I have it written as (CASE WHEN WEEK(DATE_SUB(CURDATE(), INTERVAL 2 WEEK)) = WEEK(ORDERSTARTDATE_DATE) THEN (carrier pay) END) / (CASE WHEN WEEK(DATE_SUB(CURDATE(), INTERVAL 2 WEEK)) = WEEK(ORDERSTARTDATE_DATE) THEN…
-
Unable to use "AND" filtering
I have a column named "response_value" which is to be used as a global filter in the dashboard. I would like to filter distinct users who have all of the selected values under column "response_value". Currently, it works like an OR condition and counts users who were part of any of the response_value selected
-
Pivot Table and Horizontal Calculations
Hello, Wondering if we can get some advice on how to program horizontal calculations in a pivot table. Please see below the current view of the Pivot Table and how we need to put in horizontal calcs.
-
Working on a shipping report that needs Net on Hand by item that recalculates in Analyzer
In the analyzer table, the user will sort by different columns and I need the Net on hand to adjust based on the order chosen for each part in the set. For instance, if they are looking at it by customer name, or by order number, the net on hand for those items needs to dynamically change so that Net On Hand is reduced in…
-
Remove dates from a card with a beastmode?
Hi, is this possible?
-
Beast Mode Column Sort Not working Correctly
The Following Beast Mode is reversing 1 & 2 & 4 & 5 for some reason. Only Field in the correct position is Material. I have checked spelling and case of field names.
-
Extract Quarter Value from Date Field and Return First Date of that Quarter
Hello, I need to extract the quarter from a date so it returns that quarter it falls into (example: 01/01/2023 falls into Q1. Instead of Q1 I want it to return the first day of that quarter. Example: DATE 01/05/2023 QTR DATE 01/01/2023 To note I am making a beast mode to do this in a view. I have already tried to use DATE…
-
Count New Ids by time period
Hi Domo, I would like to calculate new IDs by time period. For example, if there are 100 new ids in the month of September that have not appeared before in any other month, I would like the function to return 100. A simple count distinct will not do, since it counts all distinct values by time period, including returning…
-
Formating
I have 2 variables of which one must show as currency and other as just numbers. I have tried to concatenate the dollar sign Infront of the main beast mode but I get an error on line 16. What am I missing here?
-
Domo Filters
I am trying to achieve filtering for Current year MTD sales per day. I have written this simple beast mode filter. However, it eliminates totally a lot of data for some locations. It keeps only 3 locations and I know there are data for those dates from all locations. But when I remove the filter all the locations come…
-
Is it possible to add the border color in the textbox on DOMO?