Hi,

We already support the most basic sliding intervals: day, week, month, quarter, year. Custom ones would be convenient, I agree.

Check the menu when you hover the header of the column "week confirmed_at" here: http://insights-demo.mariusandra.com/explorer?columns=Order....

The plan is to add a view called "generated SQL", where you can see and copy/export the raw query that went into generating the data. This way you can always validate the data and get some "insight" into how it's fetched.