EazyBI : Import person rates by date

[Kris Dewachter]

Hi,

In EazyBI, I created a Google Sheet import, of rates per person. The rates have a date from which the rate is applicable.

The import itself seems to work, but if I have a person with multiple rates in the sheet, only the last record is visible in EazyBI.

Ex. For person X i have:

• Rate is 100 as of 1/1/2023
• Rate is 110 as of 1/1/2024
• Rate is 120 as of 1/1/2025

When I create a report based on "Logged By" and "Time", all the dates show the rate of 120. I'm not sure what I'm doing wrong. My import looks like this.

Any idea what i'm doing wrong here?

Best regards,

Kris