Create a new table from existing table with data for last few days
Let say I have a table that corresponds to a Domo card.
This table has a field with type 'Date'
Now I want to create another table that is exactly mirror to my 1st original table, but will consider data only for last x-days starting from my System-date. Furthermore, that new table should be updated automatically when my original table gets new data.
Is there any way to establish such process? If it is there, can you be explain how-to