Is it possible to view a field in a previous state and the value associate with the previous state? I'm looking to find the previous Property Value Source and Value and then compare them with the final Property Value Source and Value for Home Equity Applications.
Hi Alucero.
Welcome to the Community and thank you for reaching out.
There isn't a way to retain historical data natively in Sisense, but there are a couple of options.
1. Track Historical Data:
- Ensure your data pipeline is capturing and storing historical states of the data. If modifications or updates to properties (such as Property Value Source and Value) are being logged and timestamped in your database, it can be accessed from there.
2. Create a Time-Bound Field for Tracking Changes:
- In your data warehouse back-end, you can create a column that captures the timestamp for when each property value and source was recorded.
3. ETL Processes:
- Use an Extract, Transform, Load (ETL) process to properly analyze and extract only the states you need.
