-
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
Hi Domo. As of a couple weeks ago, when the tab key is pressed to autocomplete the column name in a beastmode, the cursor is automatically moved to the Save button instead of to the end of the column name that was autocompleted. How can I change it back to the way it was before? Is this something I can do myself or is it…
-
Filter Column Data By Value
To preface, I am a beginner at using DOMO so this may be something easy that I overlooked. I've blended two datasets and am attempting to have a column show aggregate data for specific locations based on a particular value. Example dataset one shows KPIs for a bunch of different metrics based on location, all that is…
-
How to use Hyperlinks in Tables
Below I have been given some code by my dev team to add to a table that is to act like a popup window when the user clicks on a certain record on that table. Is there a way to do this in domo? <button onclick="window.parent.postMessage({ type: '___', value: '12' }, '*')">____: 12</button>…
-
How do I calculate these in Beast Mode?
I created the nested beast mode below and got this error message 'An issue has occurred during processing. We are unable to complete the request at this time.' , raised a support ticket and was told that beta feature(nested beast mode) has been closed/ no longer available. How else can I do these calculations: AVG(…
-
Domo Beast Mode - Formula validated but nothing reporting out
Morning! We are trying to create a restocking report so that our store employees can restock the floor as items sell. Below are 2 versions of the copy of our formula and the report in analyzer. 1st version below - utilizes the filters option and I placed the beast mode into filters and apply a >1 to reflect Qty Sold >0…
-
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?
-
Unable to save the card with this beast mode.
In my data, I have multiple months, A subcategory, a commitment column, goal, actual, and a format column. I want to replicate a table where all subcategories, commitment, actual, and goal are listed. My goals and Actuals are just numbers, their formats are discussed in a separate column, so if the format column says it is…
-
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…
-
Are Rank functions case-insensitive?
I'm trying to get a rank for data ordered by modified date and partitioned by id. id is alphanumeric and case-sensitive in the source system. However, when I apply the rank (or row_number) function I get 2 different ids grouped because of the letter case. Collation mode is set to Binary in the ETL Settings.
-
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.