I will try to explain it as best as I canโฆ
I have an app where Iโm getting the information of people who will not be at work (for example from today until next week)
Iโm trying to know automatically the % of absenteeism by knowing the total number of people (For example: 24) and knowing that this person wonโt be for at least 1 week.
How should I compare the value of the date of โtodayโ with the number of dayโs where this person wonโt be working.
Solved! Go to Solution.
Reports can be run at scheduled intervals.
Sorry for not understanding but I have read this post and I have looked for other post to solve this and i couldnโt find it, I already looked for information or examples apps on Appsheet for this and couldnโt find anything usefull, so I dont know what should I do, but this is the only response i gotโฆ
Donโt know if Iโm doing anything wrong in this Appsheet creator community
Your post did not make any sense, which is why I linked a guide on how to make a post. Please elaborate. Screenshots are always helpful.
You seem to want to calculate a percentage. Your description of the calculation makes no sense. Is this something youโre already calculating somewhere else and can provide the more exact formula?
Thanks for the recomendation Iโm learning how to post here and I will improve.
Letโs Try Again!!!
I have a Table called โPayrollโ. here I enter the employee information when they wonยดt come to work.
The data I have to submit is:
*Employee ID - Type Number
*Name - Type Text (Which I bring to this table using a select formula conected to a data base of employees)
*Date, Time and Week numberโฆ
*Type - Type Text (To know the type of absenteeism)
*Date Start - Type Date (To know the start date when the employee is not going at work)
*Date Finish - Type Date (Due toโฆ)
*Signatureโฆ
There I need to focus is in the Start date and finish date.
This is because in other table Iโm trying to calculate the % of pople working every single dayโฆ
Letโs make an example:
I have 24 employees (Daily)
1 guy will be on vacation from 27/12/2020 until 10/01/2021
If I want to know today the % of people who isnยดt at work I haveโฆ
Total employees = 24
Total absent employees = โฆ This what honestly I donโt know how to solve, how can I get automatically this numer (Which should be = 1)
Total absent employees for today:
COUNT(
FILTER(
Payroll ,
AND(
[Date Start] <= TODAY() ,
[Date Finish] >= TODAY()
)
)
)
That worked perfectly, Thank you very much.
Iโm so sorry for the first inconvenient or problem that I had explaining what I needed.
An other questionโฆ
Is there any action that run automatically every day ? the purpose of it is to have that % with out need to fill any form
Where do you intend to view the result in your app?
In the app itself, I have a graphic to display that percent every day.
At this moment thanks to your information, I already calculated the %, but the user has to add a new form and save it.
After it, the app graph that information, what Iโm trying to do is get the daily information automatically (if itโs possible)
Reports can be run at scheduled intervals.
I think part of your struggle might be determining the correct UNITS with which to calculate the % absenteeism.
You need to use Person Days where each day counts as 1 for each person.
So a single day with 24 employees is a total possible of 24 Person Days. If the work week is 5 days, then the Total possible Person Days for the week is 120 (24 per day times 5 days).
Absent Person Days is simply the sum of days absent across all employees. If 3 people are absent in one day thatโs 3 Absent Person Days. For a week, if 1 person is absent 3 days, another is absent 2 days and a third is absent 1 day, thatโs 6 Absent Person Days.
The formula to calculate the % Absenteeism is then simple division adjusted for the period of time you are calculating for:
Total # Absent Person Days / Total # Possible Person Days
I hope this helps!!
Yes, it helped a lot, and actually thatโs what now Iโm doing, but I needed to know how to get the days that the employee is absent but I got it thanks to @Marc_Dillon
Thank you very mucho for your comment
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |