Hi @jcatulo ,
From what I understand, your custom sql is filtering data at different time intervals on the same data . At times you are looking at data for a month , at times you are looking at data for 2 months.
Take a look at period over period calculations that are possible and test if use-case is resolved by building them in QuickSight analysis. : Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)
If the above does not solve your use case , you can build the views in your backend database . Create an individual SPICE dataset for each view.
Kind regards,
Koushik