-
Beast mode CASE calculation for number ranges that have null values in column.
I have a column that has data type numeric and has numeric values and around 5 blank values. I am trying to categorize the number to ranges 1-5, 5-10 and so on. The column has blank values as well. Well, when I am trying to implement the CASE calculation in beast mode, it throws me a calculation error. How do I correct…
-
Caps and not caps in Beast Mode
Hi! I'm trying to pull data into a card where the data varies, but what I want always has the text 'thd' in it. I was fine until my stakeholder wanted us to change the data that is getting sent to a capitalized version, so now I have to account for both caps and not caps. Because all of the Event Labels contain a code, I…
-
Max Rank by Month and Year for Volume Metric
Hi, I was hoping to write a case statement that would allow me to highlight the month with the highest Volume. Additionally, I want to take data from that particular month and I want to graph it by Day. On the same graph I want to highlight the Volume for the current month as well. Ideally I would do this in a line chart.…
-
Ranking beastmode with fixed rankings
Has anyone been able to create a beastmode rank that does not recalculate when filtering? I know I can create a static rank in the dataflow, which I have done, but I'd like to figure out a way to mimic a fixed rank in beast mode for those times when I have to do a ranking on the fly and don't have time to run the dataflows…
-
Joining row data
Hi, I'm trying to combine several row data that have a similar dimension. For instance, i want to aggregate all of the lists_name's into one row next to 2024 Collection - Launch #4. so turn this… into this…
-
Create a pfilter to filter a Report Inventory on a different page
Hello, Our company has created a Report Inventory Card, Data Catalog Card, and Data Glossary Card. These cards are together on 1 dashboard (dashboard ID: 1212036684) and we have a filter on the dashboard to filter based on any dashboard ID which will then show all reports on the desired dashboard and all the definitions…
-
Create Bar Chart with Current Month Vs Previous Month?
Hello, I have a data set of invoices that I want to compare in a bar graph where one bar is March and the other bar is Feb. I think I can do this with a beast mode but I think my syntax is off. Case when Title LIKE '%OTT%' Then 'OTT' AND MONTH(Date) = CURRENT_DATE(MONTH(Date)) THEN 'Current Month' Case when Title LIKE…
-
Combining data in two separate columns
Can someone please help me learn how to combine data from two separate columns of a table? There are only two values in my pre-lease % summer 2024 column, and I need those two values to override/replace the values in the same row for the "pre-lease % 2024 column. I hope the attached screenshot helps.
-
Trying to create vertical bar chart that shows Count of Jobs based on Hours of each Job?
Hello, I am trying to create a distribution that shows the count of transactions ("jobs") grouped into buckets of hours. I thought using a window function to partition the hours buckets by Job (X-axis) and then doing a count(distinct) of jobs as the Y-axis would work, but it's not grouping correctly. When I set the Hours…
-
Histogram Buckets Beast Mode
I have created 5 buckets and I am not sure why only the last bucket is showing on a bar chart. I can see more buckets in the underlying data. Any insight on this? For reference I am using a case statement to create my buckets. Something like this. CASE WHEN (SUM(min(1)) over (partition by cat1,cat2 order by sum(value)…
-
Aggregating Data for a Beastmode - Counting Survival Analysis
Hi there -- I have a dataset that has an individual record per employee that states if they are active or terminated and that gives their current tenure or the tenure at the time that they left the company. I'm trying to do a survival beastmode using a bar chart where I show 100% at tenure = 0, and then at tenure = 1, I…
-
Keep beast mode field calculated on total value when filtered
I am creating a beast mode filters which shows me the percentage of the total units by person but when I filter out people the percentage changes to only calculate on the current people in the filter. Is there a way to keep the original numbers and show those on the card while filtering?
-
Average question
I am trying to find out the average Orders that my team does every week. Some days we work 5 days, some 6, some 7. So I want to find for week 6 of the year - What was my average Orders? Orders done on (2/5 + 2/6 +2/7 + 2/8 +2/9) / 5 How can i create a beast mode for this?
-
Beastmode Error - An issue has occurred during processing.
I am trying to create a simple beastmode to calculate the last week vs 6 week weekly average variance with the calculation below and I keep getting this error message. I've tried troubleshooting but I can't figure out why this isn't working. Can someone help me look into this? CASE WHEN SUM(CASE WHEN Year Scenario Rolling…
-
Running Total
Hello, I need help. Wondering why my running total is failing. I have the logic set up in the dataflow. The card returns the the correct value in months where there was production but for months with no activity, the value is skipped but returns the right value in the subsequent period. How do I resolve this? Product mon1…
-
SUM(distinct) Fixed By
I have a column that needs to be a constant value based on two more columns. So I am using this formula SUM(DISTINCT Balance) FIXED (BY Client, Item). This is working fine. However, When I am using the same formula in another beast mode I am getting the below error (1-SUM(Lost))/ sum ((SUM(DISTINCT Balance) FIXED (BY…
-
Rank Beast Mode with Issue
I´m using this formula to make a RANK rank () over (order by sum(NET_SALES_CY)desc) The table show the rank correct. But as soon as I try to filter my top 10 customers on table using the rank, I receive this error message An issue has occurred during processing. We are unable to complete the request at this time. what am I…
-
Beastmode to decide how much to spend per ad in a given category
We have a working beastmode that calculates what ‘n’ should be depending on spend, revenue, and page depth (page depth is in 3 categories – all pages, product, and shopping cart). Here is the formula: = 1 / ((spend / revenue) / (sum (all spend per category)/ sum (all revenue per category))) Note that the category of all…
-
My beast mode is not calculating correctly
SUM(SUM(BILLABLE_ORDERS) FIXED (add COUNTRY_NAME)) / SUM(SUM(ATTEMPTED_TXNS+VOUCHER_TXNS) FIXED (add COUNTRY_NAME)) It should be 0.82 Below is an extract of the data
-
Beast modes with multiple datasets
Hello! Is there a way to make beast mode computations with different metrics from different datasets? For example, I have the below cards that, although the numbers are the same (I am building a reconciliation section of a dashboard), the datasets used to create them are different. Now I'd like to compute the difference…
-
How to count numbers in an email address
I am trying to identify email address with more than 4 numbers occurring before @. I tried the following code CASE WHEN LENGTH( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(…
-
30 Day Interval
Hello! I am looking to create a beastmode that sums video views and revenue separately in the 30-days after the asset is published. While the beastmode is validating and looks to be calculating accurately, the QA is very off. In the screenshot example, I manually filtered the time frame for 30-days after the published date…
-
Can someone tell me where I am going wrong please?
CASE WHEN 'metric'= 'CURR MONTH' THEN CONCAT(MONTH(NOW()),'-',YEAR(NOW()) WHEN 'metric'='PREV MONTH' THEN CONCAT(MONTH(NOW())-1,'-',YEAR(NOW())) WHEN 'metric'= 'THIS MONTH PREV YEAR' THEN CONCAT(MONTH(NOW()),'-',YEAR(NOW())-1) ELSE '' END
-
Changing a column used in multiple beast modes to another column
I have around 10 beast modes that that are based on a certain column 'A' in their calculations but I need to change all of them to use a different column 'B' in the calculation. Is there a way to change this instead of manually editing all the column formulas?
-
Question on acceptance rate calc
Hello, I am trying to calculate total accpetance rate of the students. I have 2 calculated fields Accepted Students: case when (acceptance_flag = 1) then count(students) Total Students: count(students) I am having a table format and calculation for acceptance rate: (case when (acceptance_flag = 1) then count(students)…
-
Top 100 Values
In my data i have a 'client','quarter' and a Beast mode 'Score'. I have created a bar chart with quarter on x axis and Score on y axis. I have to create a card which shows scores for only top 100 clients quarter wise. How i can do that. I am not able to find a way at the moment. If we can do that in Beast modes it will be…
-
How would I filter for Order Numbers that contain UN codes? While keeping all other part numbers
Hi all, I am trying to figure out how to do this in Analyzer via Beastmode or filter tool. I am trying to only filter/display Orders that contain a product with a UN battery code while still displaying all other items in that Order Number. I'm having a tough time finding a function that could do this. Any ideas? Thanks in…
-
Identify if value exists in field to then classify data
Hey community. I've got a data set that is not optimal for what I'm trying to do. My optimal data set is sitting in a backlog and I'm looking to get some preliminary answers while i wait - so frankly, looking for a hack. I have a data set that has all of the participants associated with all of the events that we track. So…
-
Beastmode listagg/group concat
Hello, I usually refer to the list of magic etl functions documentation for functions that I can potentially use in beastmode since some working functions do not exist in the list within the beast mode editor. However, a function that can combine strings from multiple rows into a single string like GROUP_CONCAT and LISTAGG…
-
Calculate a ratio
Hi, I am looking for a calculation that will allow me to look at a requisition number and then look at number of people Forwarded to Hiring manager and number who were hired and calculate a ratio For example the calculation should be able to say 3:1 for the below example 3 forward to HM : 1 hire Sometimes we have more…