-
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…
-
Trying to calculate turnover % using window functions in beast mode - total row issue
Hello all, I am trying to calculate a monthly turnover % where the numerator is the count of terminations in the prior 12 months and the denominator is the average headcount over the last 12 months. If I create two separate beast modes for both parts of it, the output including the total row works correctly. However, when…
-
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.
-
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
-
Add beast modes already created to a dataset
Is there a way to add beast modes already created into a dataset? When I want to create a new card using the same dataset I've used before, I'm not able to find a way to add a beast mode that's already created from a previous card. I have to go to that previous card, copy the beast mode and create a new beast mode to the…
-
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?
-
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
-
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.
-
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…
-
Syntax error with beast mode
Trying to convert a column to seconds but I am getting a syntax error and cant figure out where the issue is.. TIME_TO_SEC(`AVG Answer`) + ( DATE_FORMAT(`AVG Answer`, '%f')/1000000)
-
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…