-
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?
-
Beast Mode - Color Coding
I am trying to do a beast mode with HTML code for if the Variance > Schedule, then make it red. The hiccup I am running into is that Variance and Scheduled are both already beast mode calculations, not natively in the ETL. So how can I do the HTML coloring beast mode case when statement when both items are beast mode…
-
Beast Mode Decimal number to Time Format
Is there a way to convert the current decimal number to (HH:MM:SS) format? We are using a beast mode that currently calculates minutes for us.. SUM(Talk time to decimal) / SUM(LIVE CONNECT count) = 1,167.83 / 85 = 13.74 mins.. Can i turn that into 00:13:74?
-
Membership Length
Hi new user here, I have a question about getting the membership length of our customers and I am doing this as a beast mode for a card: I need to find the start date of membership I need to find the end date of membership Finally the avg time they have been a member I used the following case statement to try and find the…
-
Calculated item in Domo
How to create calculated item in Domo same like excel pivot
-
Need Column Subtotal and Total to be average of % Amounts not Totals
I need the Subtotal and Totals of % Spent Columns to be averaged not Totaled fyi - transactionamt = JTD Cost (IFNULL(CASE WHEN SourceCode = 'Blank' THEN Filter Rows.TransactionAmt end,0))/ CASE WHEN (IFNULL(RevisedEstimatedCost,0)) >= (IFNULL(CASE WHEN SourceCode = 'Blank' THEN Filter Rows.TransactionAmt end,0)) THEN…
-
How to Handle Ending Balances
Looking for help understanding how to handle ending balances in Domo. I have a customer metric called Doors that records how many retail centers are carrying the product. I mocked up a dataset which is attached but there are two main columns of interest, the date column and the Door Count. Doors is a running total so the…
-
Can you use a beast mode in Segments?
Hello! I am trying to build out a Segment although for some reason it isn't populating when I use a beast mode as the Columns to filter. Can you only use data from the flow and not use beast modes?
-
How to create calculated items in pivot table dashboard
Hi All, I am new to Domo application. Please help me on the below query. In excel, in pivot table we can create new row with the help of Calculated item. Is it possible in Domo in Similar way or any formula. Attached Excel file for your reference. If anyone help me with screenshots, I will be more happy. Thank you so much.
-
DateDiff formula in Redshift
Hi Team, The formula below was built as a beastmode but would like to move it to dimensions, the backend. However, "DATEDIFF()" isn't recognized in Redshift, any workarounds? Thanks CASE when ("date","published_date") >0 and DATEDIFF("date","published_date") <=29 then '01 Month' when DATEDIFF("date","published_date") >29…
-
Window function beastmode error-ing
I had a beastmode that worked (attached below), but now it doesn't work. The beastmode is intended to calculate a 12 week average for a KPI we track in the business. On the card where I'm using the beastmode, the card does not load and I get this error: "An issue has occurred during processing. We are unable to complete…
-
Beast Mode is valid but does not print all options, how can I fix it?
Created the beastmode below and although its valid I'm only seeing options "Low Performers" and "Other". The beastmode is suppose to look at revenue and at month-12 revenue and meet certain qualifications to identify it as either Non Public Videos, Low Performers or Videos Exceeding Lifespan. Thank you in advance! i.e. if…
-
How to make FILTER ALLOW clause dynamic?
Hello all, I want to make it so that a user can decide on what columns that a particular chart could be filtered on. For example: SUM(SUM(Website Engagements)) FIXED (FILTER ALLOW (case when Allow Filtering - Website = 'Mobile Device Type' then Mobile Device Type else Mobile Device Type end)) This is a fixed function with…
-
Creating a Beastmode that meets Revenue Requirements
Hi! We're looking to build a beastmode that meets two requirements to then print a result. For example if a video generated more than $1K in total revenue and more than $100 during month-12, then "repost". See current beastmode below: Background: The dataset tracks the lifespan of revenue per video title, in a 12-month…
-
How to reference a Beastmode in another Beastmode?
For example we have beastmode-A that tracks monthly revenue for 12 months, and I want to reference this beastmode-A in beastmode-B which will say "Month 12 > 100 then XYZ". Any ideas are greatly appreciated! Thank you!
-
UTF-8 Arrows in HTML Table Beastmode not working
Hi guys, Im trying to create a html table with up/down arrow using beast mode. I referenced this post and tried the following code but I cant get the arrows to show up in the table, shown below so my question is: does domo html not support UTF-8 arrows anymore? is there any work around or did I do anything wrong? Thank you!
-
Fixed Function Problem
Hello, I have an issue that I'm working through in which I want to essentially group by two columns and find the average rank in that grouping. I then want to filter this rank to be less than 3 and count the total rows from this. All in a beastmode. The SQL behind this looks like the following: SELECT Count(*) from (SELECT…
-
Analyzer Data
Hello All, This is a technical question. What could be limiting the amount of data been fed into Analyzer/dashboard even though current data is in the data source? At every step in my ETL I have current data from 1/1/2021 to today, but after running the and saving the ETL when I use it in my analyzer to visualize it, the…
-
ETL Pane
Hi folks, is there a way to group steps in magic ETL into a folder. This becomes very useful when an ETL steps become very complicated and with many other pipelines. After selecting multiple ETL steps - we only have three options (DELETE, DUPLICATE and COPY TO CLIP BOARD)
-
How to wrap a DATEDIFF around this?
As always, I probably shouldn't be allowed near Beast Mode :) Can someone explain how to fix my code? I assume I'm not adding DATEDIFF in the right place, as I'm always breaking it. BatchTimestamp is the date the Phase was set to the respective value. I just need the number of days between the two. CASE WHEN `Phase` =…
-
Issue with Beastmode
Hi, I am trying to take the average for the year of a Column called CPL. (Formula for CPL is Carrier pay/Loads) I want a column where it is the average of $512,$235,$393, etc.. Any help would be greatly appreciated The beastmode I wrote is as followed. However, the error I am getting is Calculation Error : This calculation…
-
ELSE Part of Beast Mode Not Calcualting Correctly
ELSE portion of Beast Mode Not Calculating Correctly It should be showing 1,015.56 but instead it is showing Zero. You can see the TA Column has broken out the Else Portion of the CASE statement and populates just fine. CASE WHEN SUM(IFNULL(RevisedEstimatedCost,0)) >= SUM(IFNULL(CASE WHEN SourceCode = 'AP' THEN…
-
Beast Mode Formula is not working as expected
BEAST MODE - % SPENT (IFNULL(case when `SourceCode` = 'AP' then `TransactionAmt` end,0)) / (IFNULL(`ProjTotalCostEOJ 1`,0)) fyi - Transaction Amount = JTD and ProjTotalCostEOJ1 is a column brought in VIA ETL
-
BEAST MODE NOT WORKING AS EXPECTED
BEAST MODE – AMOUNT LEFT CASE WHEN (IFNULL(`RevisedEstimatedCost`,0)) >= (IFNULL(case when `SourceCode` = 'AP' then `TransactionAmt` end,0)) THEN (IFNULL(`RevisedEstimatedCost`,0)) - (IFNULL(case when `SourceCode` = 'AP' then `TransactionAmt` end,0)) ELSE (IFNULL(case when `SourceCode` = 'AP' then `TransactionAmt` end,0))…