I have created a Asset view to save the last 30 days of some attributes into a SQL server database.
The view refreshes data every day, but keeps accumulating data from more than 30 days old.
I only want to get and save to the database data from last 30 days, delete any data older than that and refresh the SQL database.
How can I create the view that will do this? Is it possible?