-
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…
-
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…
-
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!
-
Syntax issue for the beastmode concat ( text column)
I am currently having a column with different data types ( there are null, text, percentage -ve numbers, numeric values ) indicated as text column. The dataset displays %, -ve values. However , when cards are created, they only display the numbers but not the %. I tried creating beast mode for certain rows, however i get…
-
Create Bar Chart with Current Month Vs Previous Month?
I have a data set of invoices that I want to compare in a bar graph where one bar is October and the other bar is November. I suppose 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…
-
Dynamic CAGR formula?
I know how to do a basic CAGR formula between two static years: power((sum(CASE WHEN Fiscal Year = 2024 THEN Amount else 0 end) / sum(case when Fiscal Year = 2020 then Amount end)), 1 / 4) -1 Is there a way to construct a CAGR calculation that responds to user filtering or changing the timeframe? I am trying to think of a…