Create a table with manual inputs

Question

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 :)

icon

Best answer by Alix Noyon 9 January 2023, 13:13

View original

Alix Noyon · Accepted Answer

Hey! It was not really the aime but i have find something else! Thanks a lot :)

Matt D · Answer

Hi Alix,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 applythe cost in the months that the employee is "active".Let me outline the steps with a quick example:In the below screenshot, I have created an Employee dimension list. The properties are:- ID- Start Date- End Date- CostUsing this list and the date properties within it, we can then create a metric that gives us the proportion of a given month that each employee is active for. We do this by using thePRORATA function.Finally, let's create a new metric in which we multiply the above by the Cost property.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 :)