Hello community :)
I have a dimension with all my employee (including externals),their start/end dates and others. Looks like this:
To create my forecast on my externals: i want to have a table aside with manual inputs for costs that i can update for each month. I do not want to compute costs by multiplying FTE according to start/end date. At resulats, i would love a metrics with my externals (job_id), costs (than i can enter manually) and months. Then i could add this metrics to my permanent employee cost metrics since i would have the same dimensions (job_id, employee, month.
how can i do it ?
Thanks a lot :)
Best answer by Alix NoyonView original
Or maybe asolution (but i do not achieve to build it), is to add a property in Job_ID when i enter my self an average monthly cost and i assign this cost constantly between the start month and end month (the same average value each month the external is working)
If my understanding of your issue is correct, I believe what you want to do is create an intermediate metric that indicates when an employee is "active" or "inactive". You will then be able to apply the cost in the months that the employee is "active".
Let me outline the steps with a quick example:
- Start Date
- End Date
Hopefully this example makes sense and is at least somewhat similar to what you are trying to achieve.
Please let me know if you have any questions :)
@Alix Noyon! Just checking in on whether Matt’s answer helped with this?
Hey! It was not really the aime but i have find something else! Thanks a lot :)