M_A Member

SEC_TO_TIME(SUM((End Time - Start Time)) - 3600) I am using the above calculation to get the employees who has exceeded their break by 1 hour. it is working fine in normal condition but when i put this into pivot and checking the subtotal / total, it is just subtracting 1 hour from the total which is wrong. it should just…

I am using the below calculation to find the employee who is having 3 or more than 3 PR. once I have this data then I want to total the count COUNT(CASE WHEN Attendance Check = 'Present 3 or More Days' THEN 1 ELSE 0 END) on the above calculation, i tried with the SUM function as well but it is still same. It is passing the…

I was trying this beastmode formula, and it is giving NULL value for the latest date but when i am putting this formula as filter and selecting this option "Not in" the data shows like "No Data in Filtered Range" CASE WHEN Date = MAX(Date) OVER () THEN 'NULL' ELSE Date END

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 Team, I am using the below code to get the first name of the user on the dashboard card by using DDX Brick App JavaScript. I want to automatically update the Dashboard Name automatically so trying to figure it out the way to achieve this. const firstName = domo.env.userName.split('+')[0]; const welcome =…

Hi Team, I am using the below code to get the first name of the user on the dashboard card by using DDX Brick App JavaScript. I want to automatically update the Dashboard Name automatically so trying to figure it out the way to achieve this. const firstName = domo.env.userName.split('+')[0]; const welcome =…

I have three months attendance data including current month, and I want to check the last two months leave percentage of an employee. I got it by using the Pivot but here how can I highlight those employees who has taken more than 20% leaves in both the months.