EazyBI : Import person rates by date

Question

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

Elita Kalāne - eazyBI Support · Answer

Hi @Kris Dewachter

The fact that the import runs without errors but does not import anything makes me assume that the logged by user names you have in your spreadsheet, do not find a match in the Logged by dimension, user level within eazyBI.

When you import person rates, eazyBI tries to match the usernames in your google sheet with the usernames that already exist in your eazyBI account. If the names don't match exactly, eazyBI skips those rows.

Your spreadsheet file might have "john.smith" but eazyBI has "jsmith" or John Smith

Here is what I recommend doing

* Go to your eazyBI account and look at the "Logged by" dimension to see exactly how usernames appear there
* Compare those names with the names in your Excel file
* Make sure they match exactly (including capitalization, spaces, etc.)

If you take a look at the screenshots I shared from eazyBI and my test excel file, you will notice that the Logged By names match exactly in eazyBI and in the file I imported.

Best wishes,

Elita from support@eazybi.com

Kris Dewachter · Answer

Hi @Elita Kalāne - eazyBI Support ,

Thanks for the screenshots. I got them now.

I recreated the report, but I don't seem to be able to get results. The import seems to run without errors. But when i delete the data from the import afterwards, it states that no records were imported. Not sure if this has something to do with my changes.

Best regards,

Kris

Elita Kalāne - eazyBI Support · Answer

Hi @Kris Dewachter

Attaching them here again:

Heres my data set

Here's how you can clone the column:

Map the cloned cloumn to the Logged by dimension

Edit the properties

Apply the row filter for the imported Date count measure.

Hopefully the images come up this time. If not, please reach out to us directly at support@eazybi.com referring to this Community post!

Best wishes,

Elita from support@eazybi.com