Basically What the title says, I'm trying to figure out what I need to add to my beast mode to be able to switch between the unit type on the axis. I want to display Churn (%) as a percentage (without multiplying by 100) and show Churn (#) as a number. Attached is the beast mode that I have so far
Count Total Weight % of Weight 12x2pk 2,525,985 23.65% 12x4pk 169,092 1.58% 14ct 630 0.01% 16ct 8,505 0.08% 20ct 175,140 1.64% 22ct 239,400 2.24% 25ct 143,325 1.34% 28ct 395,640 3.70% 30ct 310,275 2.90% 32ct 1,196,370 11.20% 35ct 2,997,225 28.06% 39ct 787,185 7.37% 45ct 1,665,090 15.59% 52ct 68,355 0.64% If I have the…
14.76K is the total number of students (Both full-time and part-time). What would be the formula if I only want to count the Full-time values in the Full-time/Part-time column? And then if I want to change the count to percentage, do I need another formula for it? Thank you.
I have the following Beast Mode working for a comparison table (Period over Period is the name of the variable: CASE WHEN Period Over Period = 'Week over Week' THEN (CASE WHEN WEEK(Date) = WEEK(CURDATE() - INTERVAL 1 WEEK) AND YEAR(Date) = YEAR(CURDATE() - INTERVAL 1 WEEK) AND DAYOFWEEK(Date) <= DAYOFWEEK(CURDATE()) THEN…
Hi Domo, I am looking for a way to extract the string values in between stroke and question mark in a URL Example URL: https://dam-bc.com/content/67-making-AI-trustable.pdf?_gl=1*ckt29z I want to extract this part of URL: "67-making-AI-trustable.pdf" Ideally if I can do that with a beast mode formula would be great. But if…
Hi All, I want to create a column for YTD, YOY comparison by month and M-1. Example output is below: I have datetime in a format at yyyy-mm-dd Can someone show a use case for this?
Hi Everyone, I have a data set that shows where our tickets are being created and revenue. And I created 2 beast modes that separate where our tickets are being generated - CASE WHEN Source= 'G360' THEN 0 ELSE 1 END and CASE WHEN Source= 'G360' AND (Board_Name='Field Services - MAC' or Board_Name='Field Services - Repair')…
Hi all, I have a field that lists carriers in an odd fashion such as below: 000001_BOSMAN_T_GND 000001_UPS2_A_F-EX 000001_UPS2_A_LTL I'd like to get rid of the unnecessary characters at the beginning and the end so it looks like this: BOSMAN UPS2 Is there a Beastmode function or calculation that can help me do that? Would…
Is there anyway to do an incremental calculation in a subtotal row instead of the standard sum aggregation? Incremental Conversions = Exposed Conversions-(Exposed Sends/Control Sends)*Control Conversions
Is it possible to highlight the entire row for a category in a pivot table in DOMO? In the above table I want the category 'c' and 'f' rows to be highlighted as they are the categories with the highest value in each type
It looks like you're new here. Sign in or register to get started.