Store data from visual and connect with date and time

Hi all, im new to this community

I'm struggling with following and i can't find any solution in the community.

I have data which i import from a csv. The csv refreshes every hour. From this csv i calculate various summs of total warehouse worth and total warehouse part count. The "live" data works fine.

Now i want do bring this data in relation with date and time, so i can show a trend over time.

The csv don't have any time informations.

My idea is, that a can store the calculated summs in a new table with a date and time. So i can afterwards use this new table for a new visual.

Unfortunately i have no clue how to solve this.

Any ideas out there...

Thanks