Hi @ASK -
Currently QuickSight does not allow you to perform a union in data prep. The easiest approach would be to union this data in your ETL.
Assuming that you want to do this 100% in QuickSight, you can use this work around.
Step 1 - Create a modified calendar table to serve as your union.
This will be all possible dates plus a column indicating Table1 (Creation) or Table 2 (Deletion)
Step 2 & 3 - Create a calculated field in Table1 and Table2 datasets.
Table
Step 4 - Join Table1 and Table2 to your union dataset using your Table calculated field and date.
Step 5 - Create calculated field to count the creation/deletion. Note: you will take the same approach for any value fields you have.
c_count
ifelse(isnull(Table),{Table[table1]},Table)
Result:
