From the solution given in the previous discussions, I want to update the logic to show the average of 5 days a week, and only exclude days that are holidays which land on a weekday
is there a way to hide the filter funnel and the pdp shield? i have several cards where these icons block the bottom left cell in a data table. If there is not is there a way to justify the data in the data table to the left?
When working with data and building cards, is there any way to utilize beast modes to apply a weighted value across multiple variables? There is a weight variable within the dataset, and we are trying to apply those varying weights and display the updated values on a dashboard. Does the SQL syntax have the capability of…
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?
Okay, so still learning here. I am trying to calculate a waste percentage from used material to installed material. Here's the data I'm working with… Hopefully this makes sense. Column "Product Code Number" Column "Quantity" I want to use the following formula ((Product code number quantity(only for codes…
I basically want, if an employee's attendance is marked PR PH PO PN HL HLWP HCL HEL consecutive 7 days then it should be highlighted as 1, if it is marked on the 8th day again then it should show 2 if it is marked again on the 9th day then it should give 3 and so on. I have data like Date Emp ID Attendance Status…
Hi Community, excited to see what you think up! BLUF: How can I analyze what nurse saw a patient prior to a surgery or a non-surgery? See my simplified dataset below. My hope is to be able to see which nurses saw which patients/customers that led to a surgery (or not). My current thought is a CASE WHEN to create a label…
I have a data set that includes duplicate rows for products. I'm using a fixed function to de-dupe an aggregate sum of product prices because I only want one product row to contribute to the total. The fixed function (total_product_price) looks like this: SUM(DISTINCT Price) FIXED (BY Product ID) However, now I need to…
I am trying to do an a calculation and having some trouble. The formula in my Average Daily Usage column is (Oil Usage / Run TIme Hours) * 24 I guess the formula is technically working when look at columns, but I want this formula to calculate for the subtotal columns when i select a range of dates. So the column in blue…
I am trying to calculate Net working days where working days is from Sun to Sat and the date in the dataset may or may not have date till EOM. e.g.: June'24 has 30 days with 5 Sundays, the beast mode should be able to calculate (30 - 5 = 25) when June'24 is selected from the filter and subsequently calculate Net Working…
It looks like you're new here. Sign in or register to get started.