-
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…
-
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!