Forum Discussion
Using data from a specific time period
Hey tevisyauw
I haven't integrated the historic rates into my cardinality or logic.
I have start date and end date of projects, and I know what people's rates in 1 month as per the screenshot in the og post.
Here's what my ERD looks like:
If your time entries table not record the wage at that time, i think your old data will be always updated following the updated wage. this happened to me few years ago, and my last resort to make manual history wage so I can manually provide history of the wage report that my client want to look at.
I don't know about others, but for me You must start using historic rate table first. if not your PBI chart / table will be always updated and changed.
Thanks, makes sense.
How would I incorpate using the correct rates at the correct time.
E.g. If someone's rate was £40 in 1/1/22 and a project started on 2/1/22, how would I link the two so the project knows to use the rate of £40?
emm, it will be case by case base on your client company.
ex 1 : Andy rate was 40 in 01 Jan 2022 - 31 March 2022
and project last from 02 Jan 2022 - 25 March 2022Then it will be only have 1 rate
ex 2 : Andy rate was 40 in 01 Jan 2022 - 31 March 2022 and the rate change to 42 in 01 Apr 2022 - 30 Jun 2022.
The project last from 02 Jan 2022 - 15 May 2022.
in my case i will average the rate between 02 Jan 2022 - 31 March 2022 (£40), and 01 Apr - 15 May 2022 (£42)
but IF the wage of the employee was project based then they will only use the first (£40) from 02 Jan 2022 - 15 May 2022