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 have already done this calculation, but, as people's hourly rates change, it will update this calculation and so a project in the past may now show higher costs (as the hourly rate has increased).

 

I'm currently capturing historic hourly rates and have an output something like this:

 

I want to incorporate this historic data to ensure that my projects don't get updated costs in the future.

 

Do you have any ideas on how to go about this?

 

Thanks,

Tom

 

 

Need Help

5 Replies

  • 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.