Forum Discussion

Tomhayw's avatar
Tomhayw
Helper I
3 years ago

Using data from a specific time period

Hi there,    I'm currently running some analysis on how much costs are acrued on a project (people costs only).   This is calculated by hourly rate x number of hours worked on that project.   I...
Need Help
tevisyauw's avatar
tevisyauw
Helper I
3 years ago

hi Tomhayw  did your original data have the hourly rate validity period table? start period and end period. I think you must having that first on your database so it gonna be easy to design the report

for me personally, I usually put the start date valid (when change the person wage first time as start validity period , and then put end period validity when I'm going to update the wage as the end of period. 

  • Tomhayw's avatar
    Tomhayw
    Helper I
    3 years ago

    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:

     

    • tevisyauw's avatar
      tevisyauw
      Helper I
      3 years ago

      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.  

      • Tomhayw's avatar
        Tomhayw
        Helper I
        3 years ago

        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?