I have staff birthday as such
I want to have a parameter which has values 62,65,67 to represent the age when staff retire. for each value, i need to count how many staff still in service over time. for example, if parameter value is 62, then i can calculate the retirement year using birthday + 62*365 to get retirement year.
then plot line chart using retirement year as x-axis and y -axis to be count number of staff still in service (not retired) so as to show the staff reduction over time. The line chart need to change if user choose a different retire year (65 or 67)
|Staff||Birthday||if retire at 62||count in service||if retire at 65||if retire at 67|
The chart i want to plot is same as the Exel version : https://drive.google.com/file/d/1MNjl4IWKOpqLAOZWwd7zw3PkiFljBbXx/view?usp=sharing
I am not sure how to do this effectively. can anyone help? Thanks a million!
Thanks for your reply.
but after getting retirement year, how to count number of staff who is not retired from current 2019 to 2052 and plot the count in line chart over years? Thanks in advance
for example, the x-axis show year 2019, 2020, 2021... 2052, the y axis shows count of staff who are not retired, so for 2019, count is 7 (total staff), for 2039 count is 6 (cos 1 staff retire 7-1=6), for 2040, count is 5 (2 staff retired 7-2=5), etc.
the chart i want to plot is same as this Excel version : https://drive.google.com/file/d/1MNjl4IWKOpqLAOZWwd7zw3PkiFljBbXx/view?usp=sharing