Forum Discussion
TimeStamp - Help
Hi,
Have a bit of a problem that I am trying to solve and can't figure it out.
Here is the problem:
- Trying to measure # of late tasks each month to illustrate incramental improvement (this data is being pulled from MS Projects)
- Right now, this percentage obviously changes each time data is refreshed, so I lose any historical %
- I was hoping for some guidance on how to essentially timestamp % of late tasks each month regardless of the daily refresh.
Hope this makes sense but can share more.
amirzoyan Right, so with Premium I believe you could use Goals to get snapshots at points in time. Otherwise, you would have to import the data for each month in a query that you disable reload and append all the tables together essentially. Doable but not pretty or elegant. Problem is that it doesn't sound like your source system is preserving historical information like, say, a slowly changing dimension. So you are going to have to preserve that historical information somehow in some other system. I would spin up an Azure SQL database and create an Azure Data Factory job to periodically import the data, you timestamp it at the time of the import and you just keep appending rows.
1 Reply
amirzoyan Right, so with Premium I believe you could use Goals to get snapshots at points in time. Otherwise, you would have to import the data for each month in a query that you disable reload and append all the tables together essentially. Doable but not pretty or elegant. Problem is that it doesn't sound like your source system is preserving historical information like, say, a slowly changing dimension. So you are going to have to preserve that historical information somehow in some other system. I would spin up an Azure SQL database and create an Azure Data Factory job to periodically import the data, you timestamp it at the time of the import and you just keep appending rows.