-
Can I use a Beast Mode for Null/Blank Values?
I have two issues I am trying to solve. Company123 has a budget of 706.34, but there was no $ for this week. The cell is blank, so my formula is not calculating. The Budget GP-GP should equal -706.34, but it is blank. Can I do a Beast Mode, or even something in the ETL would be okay? Second issue is the 27,504.75 minus…
-
Multiple results encountered for the same location in Pivot Table indicated by ****
Attached is a sample of my data. I am trying to create a pivot table with the following: Rows: location, week, date, shift Columns: count(unique identifier), count(unique identifier) * shift length In my ETL, I created a formula to handle empty values. It determines whether a shift was 8 hours or 10 hours, based on a…
-
Using rank within a window function to filter results
I am trying to analyze the initial purchase behavior of 2 subsets of users, mobile app users and non mobile app users. I have client purchase history in a table where each row is a sale and contains whether the user is an app user or not and I've created a beast mode that uses variables "min sale date" and "max sale date"…
-
slicer not working on the beast mode calculation
I have a beast mode calculation with a CASE statement , where it considers another beast mode calculation to indicate high, low and medium risks. However , when used it as a slicer, it only displays 'no risk'and does not indicate high, low and medium in the slicer options. I am using it to filter my HTML table based on a…
-
Comparing a Running Sum to Same Time Last Year with nulls
Hi, I am having a hard time comparing a running sum to the same time last year if there is a no value. The beastmode I am using to get the running sum for each year is as followed. SUM(Count(ReportNumber)) OVER (PARTITION BY Year ORDER BY AccidentDate) However, not all accidents occur on the same day of the year, so my…
-
beast mode
hi everyone, Im in need of your assistance on completing a beast mode please. I have data that lists out site names on each row with service types but I only want sites that list the 3 types - EPIK or Greenix and Survey and Cutover and Test Like the image below: and this is what I have so far but not giving me the correct…
-
How to show events that happened after a selected one?
Hello, How can I show all events individuals have attended after they attended a specific one selected by the dashboard user? Ex. Out of the 200 who attended Conference A in January '24, 100 people attended Conference B in February, 80 Conference C in March, and 110 Conference D in April. I want to show the B, C, D…
-
Show Headcount based on Date Range Selected
Hello Everyone, I have been breaking my head over last 2 weeks looking for a probable solution to a scenario that I have. I tried ChatGPT as well but nothing worked. So, I have a Headcount App where I show Headcount based on various dimensions like - Geo, Region, Country, Gender, Leader, Job Role, etc, etc. Currently the…
-
Overlapping Date Beast Mode
Hi everyone! For context, I am making a card that flags overlapping contract dates. I want to make sure that the first order finishes its duration first before having another order. I only want to partition the overlap flag by customer and by the same business unit. Please see the Excel visualization sample I made below.…
-
Calculation depending on current month
I have an app which shows a Progress Bar that calculates % of Revenue divided by Budget. As of now the only way this works is if a selects a month or quarter from filters on the dashboard (year is defaulted for them via a page filter). I would like to update this so that the dashboard defaults to the current month, so the…