-
Remove null values to make sorting works accordingly
Hello, I have a "transaction month" column that can't be sorted accordingly because I have some months with NULL values. When I used sorting ascending/descending my months looks like this: Question, is there a formula that can be used in beastmode or function in domo to correct my sequence by month when I have a NULL…
-
Percentage calculation using beastmode
Hello Everyone, Please help. I am getting syntax error when I'm trying to rewrite this formula in beastmode. Below screenshot of my formula how it looks like in our database that I want to re-create using beastmode: I want to get a Loss Ratio percentage between 0 to 100. and results should have a percentage sign with 2…
-
Programs Ending in the Next 60 Days
Hello Everyone, I'm trying to create a card that will show what programs we're running will end in the next 60 days. I think a beast mode would help accomplish my goal but I'm unsure of what to do. Each program has multiple billing dates associated with it so I need it to be based off of just the latest billing date.
-
Need to get TOP 10 only
Hi, I build this card using a bar graph and aim to get the TOP 10 PERILS only. What formula in beastmode can I add just to get results for only the top 10? Columns used: "Peril" and "Peril Counts" Thank you!
-
Ratio Formula
Hi! I need help to use the beast mode function. I have the following columns: Name, Ref #, Paid Amount, Savings Amount and Bill Amount. I want to get the Ratio of Each Name using this formula: Paid Amount + Savings Amount / Bill Amount Thank you!
-
Previous Validated Formula now Domo is not accepting
Please help: I have a beastmode calculation setup before that creates a Date using month number but now Domo is not accepting it. Here is the formula: DATE(CASEWHEN LENGTH(`Month Number`)=1 THEN CONCAT(`Year`,'-0',`Month Number`,'-01')ELSE CONCAT(`Year`,'-',`Month Number`,'-01') END) This is the error message that I am…
-
Grouped Percentages
Hi All, I have a created a table where I can see customer, their KPI, KPI attainment and KPI attainment %. I want to group the clients by KPI attainment % for example, a list of customers that fall into brackets such as 0-24%, 25-50%, 51-74%, 75-99% etc etc. I'm using the following beastmode but it keeps returning a syntax…
-
Wrong grand total
I have two columns 1) Actual Variance and 2) Absolute Variance. Actual Absolute 2 2 -2 2 4 4 -3 3 Total 1 11I am getting the correct count 1 for the actual variance but for the absolute variance I am getting the same value as actual with the positive sign.I am using abs function to wrap the actual calculation for the…
-
Beast Mode Calculation ID to Beast Mode ID
Hello, I'm running into an issue implementing Sandbox repositories on objects that have been in production for a long time. Specifically, I'm creating sandbox versions of cards that are using Beast Mode calculations that were originally created on other cards, and therefore they are not migrating to the sandbox datasets…
-
Creating a Beastmode/ Dimension
I have a set of data that includes columns like " Facebook Engagements, Facebook Impressions, Twitter Engagements, Twitter Post Impressions, TikTok engagements, TikTok Impressions" how do I create a dimension or beastmode where you will be able to filter by platform, e.g.: Facebook, Twitter, TikTok.